This post originated from an RSS feed registered with .NET Buzz by Serdar Kilic. Original Post: SqlCommandBuilder Feed Title: kilic.net Feed URL: http://www.kilic.net/weblog/index_full.rdf Feed Description: Occassional entries in .NET, Cycling, and whatever I'm in the mood for. Latest .NET Buzz Posts Latest .NET Buzz Posts by Serdar Kilic Latest Posts From kilic.net

Just gotta say that the SqlCommandBuilder class absolutely rocks! For simple CRUD operations you should do yourself a favour and take a look at this. Usage is as simple as:

    SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Pubs", connectionString);

    SqlCommandBuilder bld = new SqlCommandBuilder(da);

    da.UpdateCommand = bld.GetUpdateCommand();
    da.InsertCommand = bld.GetInsertCommand();
    da.DeleteCommand = bld.GetDeleteCommand();

make your changes to your DataSet and then call the Update method on your DataAdapter to get the changes back to SQL and voila!