updating vb

[rhm532005]

hi every one
i'm writing a program in vb.net in visualstudio i want to know how can i update my database by using dataadapter dataset dataconnection and command builder can you give me an example thank you

[Pgmer]

Which database are you using? What is the table you want to update? Be specific.

[rhm532005]

hi
i'm going to make relation between my program a windows application and an access database i have a form with two text boxes buttons for update, new record and delete of records in my database

[G_Waddell]

You could specify and update command for your Dataset like this Updating Database with a DataAdapter OR something like this:

dim cmd as new OLEDBCommand

With cmd
.connection = myconnection
.CommandType = CommandType.Text
.Text = "MyUpdate Query"
end With
cmd.ExecuteNonQuery 

[M.Waqas Aslam]

hello
try something like this.

dim con as new sqlconnection("connection string")
dim cmd as new sqlcommand
con.open()
cmd.connection = con 
cmd.commandtext = "update table1 set col1=@col1,col2=@col2,col3=@col3,col4=@col4 where recid = @recid"
cmd.paramerter.addwithvalues("@col1",txt1.text)
cmd.paramerter.addwithvalues("@col2",txt2.text)
cmd.paramerter.addwithvalues("@col3",txt3.text)
cmd.paramerter.addwithvalues("@col4",txt4.text)
cmd.paramerter.addwithvalues("@recid",txtRecId.text)
cmd.ExecutenonQuery()
con.close()

hope this will help you .

Regards