Cannot Add a Row Using SQL and CommandBuilder C#

Question

I'm doing this exactly (see Using SqlDataAdapter to insert a row) but it doesn't give me the .ADD method

Here is my code:

var sqlQuery = "select * from CT_DETIMP where 0 = 1";
SqlDataAdapter tableAdapter = new SqlDataAdapter(sqlQuery, myConnection);
DataSet dataSet = new DataSet();
tableAdapter.Fill(dataSet);

var impRow = dataSet.Tables["CT_DETIMP"].NewRow();
impRow["TRANSCD"] = tranCode;
impRow["MISC"] = misc;
impRow["ADDENDA"] = addenda;

dataSet.Tables["CT_DETIMP"].Add(impRow);  // THIS IS WHERE THE ERROR IS 

new SqlCommandBuilder(tableAdapter);
tableAdapter.Update(dataSet);

I get the error DataTable does not contain a reference for ADD. I'd be happy to do this another way but I can't use table.Adapter.Insert because I need my data to go into specific fields.

So I changed dataSet.Tables["CT_DETIMP"].Add(impRow); to dataSet.Tables["CT_DETIMP"].Rows.Add(impRow); and now I am getting a null error on this line: var impRow = dataSet.Tables["CT_DETIMP"].NewRow();

This code worked:

' SqlConnection myConnection = new SqlConnection(connectionString); myConnection.Open();

        var sqlQuery = "select * from CT_detimp where 0 = 1";
        SqlDataAdapter tableAdapter = new SqlDataAdapter(sqlQuery, myConnection);

        SqlCommandBuilder cb = new SqlCommandBuilder(tableAdapter);

        DataSet dataSet = new DataSet("CT_DETIMP");
        tableAdapter.Fill(dataSet,"CT_DETIMP");

        DataTable detailTable = dataSet.Tables["CT_DETIMP"];
        DataRow impRow = detailTable.NewRow();'

also DataTable is the underlying of DataSet for example dataSet.Tables[0].Rows.Add — MethodMan
– MethodMan, Commented Jun 24, 2016 at 18:30

Rico · Accepted Answer · 2016-06-24 18:31:54Z

1

Change the line with the error to this:

dataSet.Tables["CT_DETIMP"].Rows.Add(impRow);

answered Jun 24, 2016 at 18:31

Rico

4025 silver badges9 bronze badges

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

1 Comment

Missy Over a year ago

Oh no. Now I'm getting a null error on 'var impRow = dataSet.Tables["CT_DETIMP"].NewRow();' Any clue?

paparazzo · Accepted Answer · 2016-06-24 18:34:26Z

1

You need to add to the DataTable.Rows collection

dataSet.Tables["CT_DETIMP"].Rows.Add(impRow);

answered Jun 24, 2016 at 18:34

paparazzo

45.2k24 gold badges110 silver badges180 bronze badges

Collectives™ on Stack Overflow

Cannot Add a Row Using SQL and CommandBuilder C#

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related