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 ...
|
|||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
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 |
|
|||
|
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 |
![]() |
| Thread Tools | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| VB.NET 2005 (Database Deletion issues) | PlanTec | Microsoft .NET | 1 | 07-10-2006 11:38 PM |
| Microsoft .NET : Implementing The Google Web Service In VB.NET - Introduction | techguru | Microsoft .NET Tutorials and Articles | 4 | 04-28-2006 07:55 PM |
| hierarchail & network | kisshug | Oracle Tutorials | 2 | 05-01-2005 05:17 PM |
| .Net Interview Questions | Pramodm | Interview Questions | 12 | 08-07-2004 08:48 PM |
| Problem with DataSet | NareshShroff | Microsoft .NET Tutorials and Articles | 4 | 05-26-2004 06:18 AM |