Problem with dataset to sql

Question

{ 
   string selectDesc = @" SELECT     [Descripion id], [Sub Collection FROM      Descripion   ";

    DataSet dsD = new DataSet();
    SqlCommand comD = new SqlCommand();
    comD.Connection = con;
    comD.CommandText = selectDesc;
    SqlDataAdapter daD = new SqlDataAdapter();
    daD.SelectCommand = comD;
    SqlCommandBuilder cbD = new SqlCommandBuilder(da);
    daD.Fill(dsD, "Descripion");
    DataRow new_row_Desc = dsD.Tables[0].NewRow();
    new_row_Desc["Descripion id"] = 58589;
    new_row_Desc["Sub Collection"] = TextBox18.Text;
            dsD.Tables[0].Rows.Add(new_row_Desc);
    daD.Update(dsD.Tables[0]);
}

I am getting this error:

Update requires a valid InsertCommand when passed DataRow collection with new rows.

What is the problem?

What language is this? What platform? It doesn't look like javascript. — Oded
– Oded, Commented Dec 8, 2010 at 11:44

Thorsten Dittmar · Accepted Answer · 2010-12-08 11:50:18Z

2

First of all, your select statement is missing a closing "]" before FROM. Also, you're assigning a select command to the data adapter, but no insert and update commands. So the data adapter does not know what to do when inserting a new row.

answered Dec 8, 2010 at 11:50

Thorsten Dittmar

56.9k10 gold badges95 silver badges145 bronze badges

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

Collectives™ on Stack Overflow

Problem with dataset to sql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related