Updating DataBase with DataTable & TableAdapte problem in C#?
Hi all.
I've had a DataBase that named Database1.mdf
After that VS2008 SP1 creates a DataSet in my Project, named Database1DataSet
Then I've created a TableAdapter.
Now I wanna update the DataBase with them ( DataSet & DataTable & TableAdapter ).
I used this code :
Code:
Database1DataSetTableAdapters.eventsTableTableAdapter eventsTableTableAdapte =
new WpfApplication1.Database1DataSetTableAdapters.eventsTableTableAdapter();
Database1DataSet.eventsTableDataTable eventsTableDataTable =
new Database1DataSet.eventsTableDataTable();
eventsTableTableAdapte.Fill(eventsTableDataTable);
var id = (from c in eventsTableDataTable.Distinct()
select c.id).Last();
id++;
DataRow newDataRow = eventsTableDataTable.NewRow();
newDataRow["event"] = "event" + id.ToString();
newDataRow["date"] = id;
eventsTableDataTable.Rows.Add(newDataRow);
eventsTableTableAdapte.Update(eventsTableDataTable);
eventsTableTableAdapte.Dispose();
eventsTableDataTable.Dispose();
But the changes not apply to the DataBase , Why ? Confused
What's wrong with it ?
Many thanks in advance.
Re: Updating DataBase with DataTable & TableAdapte problem in C#?
And is there an exception? Also, you are not creating and setting the connection, so some connection based on connection string used in design time is used. Are you sure it is right? Maybe other database is updated than the one you would expect to be.
Re: Updating DataBase with DataTable & TableAdapte problem in C#?
Quote:
is there an exception?
No, there isn't http://www.fileden.com/files/2008/8/...miles1/013.gif
Quote:
Also, you are not creating and setting the connection,
As I know if VS2008 creates it, otherwise an exception has occurred . http://www.fileden.com/files/2008/8/...miles1/016.gif
Quote:
Maybe other database is updated than the one you would expect to be.
I don't think so, because I've used the DataTable of DataBase1 http://www.fileden.com/files/2008/8/...miles1/005.gif
Re: Updating DataBase with DataTable & TableAdapte problem in C#?