static void UseDataTable(DbDataTable myDataTable, IDbConnection myConnection)
{
myDataTable.Connection = myConnection;
myDataTable.SelectCommand = myConnection.CreateCommand();
myDataTable.SelectCommand.CommandText = "SELECT * FROM Dept";
try
{
myDataTable.Fill();
myDataTable.Rows[1].Delete();
myDataTable.Update();
foreach(DataRow myRow in myDataTable.Rows)
{
foreach(DataColumn myCol in myDataTable.Columns)
{
Console.Write(myRow[myCol] + "\t");
}
Console.WriteLine();
}
}
finally
{
myDataTable.Clear();
}
}