sql exception while updating data

Question

While updating data, I get the following exception:

Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.

Can anyone help me please?

string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
    cn = new SqlConnection(cs);
    da = new SqlDataAdapter("select*from Clinic_info", cn);
    SqlCommandBuilder cmd = new SqlCommandBuilder(da);
    ds = new DataSet();
    da.Fill(ds, "Clinic_info");
    //ds.Tables["Clinic_info"].Constraints.Add("CL_ID_pk", ds.Tables["Clinic_info"].Columns["CL_ID"], true);

    try
    {
        DataRow row;

        row = ds.Tables["Clinic_info"].Rows.Find(Session["msg"].ToString());
        row.BeginEdit();
        row["CL_Name"] = cl_name.Text;
        row["CL_Desc"] = cl_descri.Text;

Coder · Accepted Answer · 2011-09-27 08:54:38Z

1

Make sure sql table has primary key.

answered Sep 27, 2011 at 8:54

Coder

9062 gold badges13 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:12:01Z

1

Make sure you've got select * from Clinic_info in the code instead of select*from Clinic_info. And, as Coder has told you, check the table has a primary key. This is the reason behind the exception.

edited May 23, 2017 at 12:12

CommunityBot

11 silver badge

answered Sep 27, 2011 at 8:55

Xavi López

27.9k11 gold badges100 silver badges167 bronze badges

Collectives™ on Stack Overflow

sql exception while updating data

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related