Exforsys

Online Training

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 ...


Go Back   Exforsys > Programming Talk > Microsoft .NET

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 11-27-2006, 08:33 AM
Junior Member
 
Join Date: Nov 2006
Posts: 4
nfor_onlyme is on a distinguished road
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 11-27-2006, 08:36 AM
Junior Member
 
Join Date: Nov 2006
Posts: 4
nfor_onlyme is on a distinguished road
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

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


All times are GMT -4. The time now is 02:36 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0
Copyright 2004 - 2007 Exforsys Inc. All rights reserved.