Dataset to database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Inbaraj
    New Member
    • Apr 2007
    • 76

    Dataset to database

    Hi..

    I am having values in DataSet. I want to update the values of dataset to database. Can any one say me how to do that...

    thanks in advance...

    with reg
    inbaraj
  • Kermit
    New Member
    • Aug 2007
    • 16

    #2
    use DataAdapter.Upd ate(DataSet) method.

    use SqlCommandBuild er mySqlCommandBui lder = new SqlCommandBuild er(mySqlDataAda pter);
    to create InsertCommand, UpdateCommand and DeleteCommand for you (if you don't have to complicated SQL queries) and then call
    mySqlDataAdapte r.Update(dataSe t, "name of the table");

    Comment

    Working...