Previous | Home | Next |
private static void DisplayROWs(string , DataTable table) { Console.Clear(); Console.WriteLine("\n"); Console.WriteLine(s); Console.WriteLine("-------------------------------------------"); foreach (DataRow dr in table.Rows) { Console.WriteLine(dr.RowState.ToString()); } Console.WriteLine("\nPress Enter to Continue ..") ; Console.Read() ; }
Filling a DataTable and Displaying the Row States in C#
static void Main(string[] args) { using (SqlConnection scon = new SqlConnection(connectionString)) { SqlCommand scmd = scon.CreateCommand(); scmd.CommandText = "Select * from student"; SqlDataAdapter sqlDa = new SqlDataAdapter(scmd); DataTable StudentTable = new DataTable("student"); sqlDa.Fill(StudentTable); DisplayRowStates( "Row states for a freshly filled DataTable:",StudentTable); } }
Making Changes to the DataTable in C#
DataRow dr; // Make Changes - Modify the puppy dr = StudentTable.Rows[0]; dr["StudentName"] = "Anil"; // Make Changes - Delete the cat dr = StudentTable.Rows[1];dr.Delete(); // Leave the Horse untouched. // Make Changes - Insert a Record dr = StudentTable.NewRow(); dr["StudentID"] = 4;dr["StudentName"] = "Ajay"; StudentTable.Rows.Add(dr); DisplayRowStates("Row states for a modified DataTable:", StudentTable);
Setting Various Commands in C#
// Update the changes back to the database. SqlCommandBuilder sqlcommr = new SqlCommandBuilder(sqlDa); // Setup Update Command sqlDa.UpdateCommand = sqlcommr.GetUpdateCommand(); Console.WriteLine("Update Command: " + sqlDa.UpdateCommand.CommandText); // Setup Insert Command sqlDa.InsertCommand = sqlcommr.GetInsertCommand(); Console.WriteLine("Insert Command: " + sqlDa.InsertCommand.CommandText); // Setup Delete Command sqlDa.DeleteCommand = sqlcommr.GetDeleteCommand() ; Console.WriteLine("Delete Command: " + sqlDa.DeleteCommand.CommandText); sqlDa.Update(animalsTable);
Previous | Home | Next |