Unable to update datasource

[Hemant Bhiwajee]

Hello there.

I have the following code to enter data into a dataset and subsequently save the data to a SQL Server database. A datagrid attached to the dataset shows the added data when the 'Save' button is clicked. But when I check the database no record is added. Can anyone help with that please??

Con.Open();
string name = TxtName2.Text.Trim();
string address = TxtAdd2.Text.Trim();
string phNo = TxtPhNo2.Text.Trim();

SqlDataAdapter DaMembers2 = new SqlDataAdapter("Select * from Members", Con);
DataSet dsMembers2 = new DataSet();
DataTable dtMembers2 = new DataTable();

DaMembers2.Fill(dsMembers2, "dtMembers2");
SqlCommandBuilder CbMembers = new SqlCommandBuilder( DaMembers2 );

//Datagrid
dgMembers.DataSource = dsMembers2.Tables["dtMembers2"];
DataRow insertRow = dsMembers2.Tables["DtMembers2"].NewRow();

insertRow["Mem_Name"] = name;
insertRow["Mem_Address"] = address;
insertRow["Mem_PhNo"] = phNo;

dsMembers2.Tables["DtMembers2"].Rows.Add(insertRow);
dsMembers2.AcceptChanges();

DaMembers2.Update(dsMembers2, "dtMembers2");


dgMembers.Refresh();
Con.Close();
}
catch(Exception e)
{
MessageBox.Show(e.ToString());
}