
- Forum
- Programming Talk
- Microsoft .NET
- Database Updations through dataset in vb.net
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 ...
-
11-27-2006, 08:33 AM #1
- 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
-
11-27-2006, 08:36 AM #2
- 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

Reply With Quote





