update database using datatable

Question

hello;
i have one table "Answer:" in database which has 6 columns and no rows.
now in a program i create datatable and add rows prgrammaticaly to this datatable.
now i want to update all the rows from datatable to the database in "Answer" table.
what should i do??????

Amit Patel · Answer

DataAdaptor will do it for you. just pass dataset to Dataadaptor and perform save operation private static void AdapterUpdate( string connectionString) { using (SqlConnection connection = new SqlConnection(connectionString)) { SqlDataAdapter dataAdpater = new SqlDataAdapter( "SELECT CategoryID, CategoryName FROM Categories" , connection); dataAdpater.UpdateCommand = new SqlCommand( "UPDATE Categories SET CategoryName = @CategoryName " + "WHERE CategoryID = @CategoryID" , connection); dataAdpater.UpdateCommand.Parameters.Add( "@CategoryName" , SqlDbType.NVarChar, 15, "CategoryName" ); SqlParameter parameter = dataAdpater.UpdateCommand.Parameters.Add( "@CategoryID" , SqlDbType.Int); parameter.SourceColumn = "CategoryID" ; parameter.SourceVersion = DataRowVersion.Original; DataTable categoryTable = new DataTable(); dataAdpater.Fill(categoryTable); DataRow categoryRow = categoryTable.Rows[0]; categoryRow[ "CategoryName" ] = "New Beverages" ; dataAdpater.Update(categoryTable); Console.WriteLine( "Rows after update." ); foreach (DataRow row in categoryTable.Rows) { { Console.WriteLine( "{0}: {1}" , row[0], row[1]); } } } }

lam pham · Answer

You can use SqlBulkCopy to insert database