forum

Home / DeveloperSection / Forums / Unable to add new entry in datatable c#

Ask Question

Unable to add new entry in datatable c#

Anonymous User245219-Jun-2013
Hi Expert,

i'm trying to add a new row to my datatable.

I've no error while running this code but nothing happened in my table.

Here's my code :

        string table = "`DONNEE ENTRANT`";
        OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * From " + table, _conn);
        OleDbCommandBuilder cmdBuilder = new OleDbCommandBuilder(adapter);

        DataTable dataTable = new DataTable(table);
        adapter.Fill(dataTable);
        DataRow row = dataTable.NewRow();

        row["CODE LIAISON"] = "TEST";

        dataTable.Rows.Add(row);
        dataTable.AcceptChanges();

        adapter.Update(dataTable);

Any idea what i'm doing wrong (in this way, I know that we can run command with oleDb but really don't like this way ...).

Thanks
ado.netado.net 
Updated on 19-Jun-2013
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Anonymous User

Anonymous User

19-Jun-2013
Hi Expert,

So remove this line:

dataTable.AcceptChanges();

because that's changing the RowState to Unchanged and you need it left at Added. Further, you need to make sure that your adapter has an InsertStatement defined so it can use it.

Thanks in advance. 

Liked By