A desperate help in Update

[Sajid]

Hello! Experts,

I have the following piece of code in VB.NET that I want to use to
update any records in the database. I would like to use a code as well
as DataGrid to update the records. Please guide me how can I achieve
it. I know there is an Update command to to do this that but since I
am a newbie I don't know how? I'll be really grateful to those who may
help me buy modifying the following code. I am really desperately
looking for your help. I know this will only take a fraction of your
time but it will be a very big help for me. Thanks to all...

------------------------------------------------------------------------
Private odbcAd As New Microsoft.Data. Odbc.OdbcDataAd apter
Private Conn As New Microsoft.Data. Odbc.OdbcConnec tion
Private ds As New DataSet("AnyTab le")

Conn.Connection String = "DSN=TestDS N"

Conn.Open()

Dim SQL As String
SQL = "SELECT * FROM AnyTable"

odbcAd = New Microsoft.Data. Odbc.OdbcDataAd apter(SQL, Conn)

ds.Clear()

odbcAd.Fill(ds, "AnyTable")

DataGrid1.SetDa taBinding(ds, "AnyTable")

ds.Tables("AnyT able").Rows(1). Item(3) = "Test"
------------------------------------------------------------

[Steven Stein [MSFT]]

Hello -

You need to call the Update method of your DataAdapter. Check out this help
topic:

Updating a Data Source with a Dataset (Visual Basic and Visual C# Concepts)
http://msdn.microsoft.com/library/en...mingUpdates.as
p
hope that helps
Steve Stein
VB Team

This posting is provided "AS IS" with no warranties and confers no rights.

--------------------

From: sa*********@yah oo.com (Sajid)
Newsgroups: microsoft.publi c.dotnet.langua ges.vb.data,mic rosoft.public.d otnet.languages .
vbSubject: A desperate help in Update
Date: 27 Jan 2004 11:18:46 -0800
Organization : http://groups.google.com
Lines: 33
Message-ID: <e0************ **************@ posting.google. com>
NNTP-Posting-Host: 195.13.97.12
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google. com 1075231126 22381 127.0.0.1 (27 Jan 2004 19:18:46 GMT)X-Complaints-To: gr**********@go ogle.com
NNTP-Posting-Date: Tue, 27 Jan 2004 19:18:46 +0000 (UTC)
Path: cpmsftngxa07.ph x.gbl!cpmsftngx a06.phx.gbl!TK2 MSFTNGP08.phx.g bl!news-out.cwix
..com!newsfeed. cwix.com!news.m axwell.syr.edu! postnews1.googl e.com!not-for-mai
lXref: cpmsftngxa07.ph x.gbl microsoft.publi c.dotnet.langua ges.vb:176578 microsoft.publi c.dotnet.langua ges.vb.data:299 8X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.vb

Hello! Experts,

I have the following piece of code in VB.NET that I want to use to
update any records in the database. I would like to use a code as well
as DataGrid to update the records. Please guide me how can I achieve
it. I know there is an Update command to to do this that but since I
am a newbie I don't know how? I'll be really grateful to those who may
help me buy modifying the following code. I am really desperately
looking for your help. I know this will only take a fraction of your
time but it will be a very big help for me. Thanks to all...

------------------------------------------------------------------------
Private odbcAd As New Microsoft.Data. Odbc.OdbcDataAd apter
Private Conn As New Microsoft.Data. Odbc.OdbcConnec tion
Private ds As New DataSet("AnyTab le")

Conn.Connectio nString = "DSN=TestDS N"

Conn.Open()

Dim SQL As String
SQL = "SELECT * FROM AnyTable"

odbcAd = New Microsoft.Data. Odbc.OdbcDataAd apter(SQL, Conn)

ds.Clear()

odbcAd.Fill(ds , "AnyTable")

DataGrid1.SetD ataBinding(ds, "AnyTable")

ds.Tables("Any Table").Rows(1) .Item(3) = "Test"
------------------------------------------------------------