Updating the database from dataset after altering it in c#

Question

I trying to insert values to the dataset and i want the corresponding chages to be reflected in the database . I'm using this code:

_MyDatabase_1DataSet obj = new _MyDatabase_1DataSet();
MyDatabase_1DataSetTableAdapters.t1TableAdapter mytable = new testingconnection._MyDatabase_1DataSetTableAdapters.t1TableAdapter(); 
     mytable.Fill(obj.t1);
     obj.t1.Rows.Add("new value");
     mytable.Update(obj);

But the change is getting reflected in the dataset and not in the database. When i use another instance of the dataset I am able to get the new row but the updation is not reflected in the database(.sdf)

can you please try `mytable.Update(obj.t1);` – PraveenVenu May 09 '12 at 08:27 — PraveenVenu, May 09 '12 at 08:27
I tried all the overloads for Update but nothing worked. – gout May 09 '12 at 08:29 — gout, May 09 '12 at 08:29

score 0 · Answer 1 · edited May 23 '17 at 12:04

0

can you please try

 _MyDatabase_1DataSet obj = new _MyDatabase_1DataSet();
 MyDatabase_1DataSetTableAdapters.t1TableAdapter mytable = new testingconnection._MyDatabase_1DataSetTableAdapters.t1TableAdapter(); 
 mytable.Fill(obj.t1);
 DataRow dr=obj.t1.NewRow();
 dr[0]="new value";
 obj.t1.Rows.Add(dr);
 mytable.Update(obj.t1);

also try this

Insert method of TableAdapter not working?

edited May 23 '17 at 12:04

Community

1
1

answered May 09 '12 at 08:34

PraveenVenu

8,217
4
30
39

Updating the database from dataset after altering it in c#

1 Answers1