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.