How to update gridview using vb.net and microsoft access?

[fanoftvb]

Hi, i am new to vb.net so i have been facing a lot of problems with my code. Can someone pls check for me where i go wrong..thanks

p.s I'm using visual basic 2005

my code is below

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)

Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & Server.MapPath("database\db1.mdb")

Dim conn As New OleDbConnection(strConn)
conn.Open()
Dim da As New OleDbDataAdapter
Dim updatecommand As New OleDbCommand("Update Coor_Remark From Table3", conn)
updatecommand.Connection = conn
Dim ds As New DataSet(strConn)
da.Update(ds, "Table3")
GridView1.DataSource = ds.Tables("Coor_Remark")
GridView1.DataBind()

conn.Close()
End Sub

[NithyaJai]

hai,
dg is the datagrid used to output database details..........

On page load:

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Page.IsPostBack = False Then
binddata()
End If
End Sub

Function (created by us):

Private Sub binddata()
Dim con As New SqlConnection("server=SANISH1; database=master; uid=sa; pwd= ")
con.Open()
Dim da As New SqlDataAdapter("select * from xyz", con)
Dim ds As New DataSet
da.Fill(ds)
dg.DataSource = ds
dg.DataBind()
con.Close()
End Sub

Updation part:

Private Sub update_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles insert.Click
Dim con As New SqlConnection("server=xxx; database=master; uid=sa; pwd= ")
con.Open()
Dim strid As String = txtuserid.Text.Trim()
Dim strname As String = txtusername.Text
Dim strpwd As String = txtpwd.Text
Dim cmd As New SqlCommand("update xyz set uname=@uname where userid=@userid", con)
cmd.Parameters.Add("@uname", strname)
cmd.Parameters.Add("@pwd", strpwd)
cmd.ExecuteNonQuery()
Response.Write("Records Updated")
binddata()
con.Close()

End Sub

this is the easy way to start doing VB.NET....
if u hav more doubt.. go to the following link..
http://asp.dotnetheaven.com/howto/doc/adoplus/UpdateDataFromDB.aspx

[fanoftvb]

Hi, thanks for the reply.

However, i still have error in my program. There is some problem with my cmd.Parameters.Add

The error msg is below.....

'Public Function Add(parameterName As String, value As Object) As System.Data.OleDb.OleDbParameter' is obsolete: 'Add(String parameterName, Object value) has been deprecated. Use AddWithValue(String parameterName, Object value). http://go.microsoft.com/fwlink/?linkid=14202'

i also have problem with this line:
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles insert.click

the error -------->Handles clause requires a WithEvents variable defined in the containing type or one of its base types.

Can someone help, i have no idea what the errors mean.....Thanks