Exforsys
+ Reply to Thread
Results 1 to 2 of 2

Database Updations through dataset in vb.net

This is a discussion on Database Updations through dataset in vb.net within the Microsoft .NET forums, part of the Programming Talk category; Hi, I m a very beginner to vb.net so can anybody plz tell me How to work through Dataset to ...

  1. #1
    nfor_onlyme is offline Junior Member Array
    Join Date
    Nov 2006
    Answers
    2

    Database Updations through dataset in vb.net

    Hi,
    I m a very beginner to vb.net so can anybody plz tell me How to work through Dataset to updat,delete modify select or insert values to a database through dataset.Not through wizard but through coding.
    Plz help me.
    Thanks
    Namita


  2. #2
    nfor_onlyme is offline Junior Member Array
    Join Date
    Nov 2006
    Answers
    2
    I did this :
    But its not working.

    db = New SqlDataAdapter("select * from student", myConnection)
    db.Fill(Dset, "student")
    If Dset.HasChanges Then

    cmd = New SqlCommandBuilder(db)
    db.TableMappings.Add("Table", "Student")
    Dset.AcceptChanges()

    db.Update(Dset, "Student")
    Dset.GetChanges()
    ' Dset.AcceptChanges()
    db.Fill(Dset, "student")
    db.AcceptChangesDuringUpdate = True


Latest Article

Network Security Risk Assessment and Measurement

Read More...