How to Add,Modify,Delete Rows in DataTable which has been populated with Data From Database table?

Hi
 
//Adding rows into Datatable:-
DataRow row = null;
for (int i = 0; i < 5; i++)
{
row = dTable.NewRow();
row["AutoID"] = i + 1;
row["Name"] = i + " - Datta";
row["Address"] = "Mumbai, India - " + i;
dTable.Rows.Add(row);
}

//Modify certain values into the DataTable:-
dTable.Rows[2]["AutoID"] = 20;
dTable.Rows[2]["Name"] = "Modified";
dTable.Rows[2]["Address"] = "Modified Address";
dTable.AcceptChanges();

// Delete row:-
dTable.Rows[1].Delete();
dTable.AcceptChanges();
//OR
foreach( DataRow row in someTable.Rows )
{
if( /* your condition here */ )
row.Delete();
}
someTable.AcceptChanges(); //You then need to call AcceptChanges() on the data table to finalize the delete - presumably

//Filtering data from DataTable:-
DataRow[] rows1 = dTable.Select(" AutoID > 5", "AuotID ASC");

//For more detail of Datatable operation refer this link:-
http://www.dotnetfunda.com/articles/article131.aspx

see this