example

[kante]

id like to have the source code of an example in vb.net taht shows how to manage a local databse

creating db and tabkes...
inserting updating deleting....etc...

thank you

 

[wayko]

if using a regular webform
you can use
(update)
sqldataadapter1.updatecommand.parameter("@whatever").value = whatever you are using to input the information (ie. textbox1.text)
sqldataadapter1.updatecommand.open()
sqldataadapter1.updatecommand.executenonquery()
SqlDataAdapter1.UpdateCommand.Connection.Close()
SqlDataAdapter1.Fill(DataSet11)
(insert)
SqlDataAdapter1.InsertCommand.Parameters("@Notes").Value = whatever you are using to input the information (ie. textbox1.text)
SqlDataAdapter1.InsertCommand.Connection.Open()
SqlDataAdapter1.InsertCommand.ExecuteNonQuery()
SqlDataAdapter1.Fill(DataSet11)

 

[kante]

a simple addres book ... to see how local database works?

 

[Divil]

kante, you cant expect people to write a complete application for you. Somebody might, if you are very lucky, but I would be surprised.

You should find some samples online (there are bound to be dozens) and then try and make your own. If and when you run in to a specific problem, post a question here and its likely somebody will be able to help you.

 

[Goofy]

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q301075 i hope that will help you

 

[kante]

im not expeting anyone to write some code for me....

i just asked that cause i posted this thread in the VB6 forum and a guy sent me an address book application that was perfect... bu t i couldnt open that vbproject with vb.net(for the reasons we know... the converter vb6->vb.net sometimes needs some manual actions at code level to work properly)


now i attach that application...
im not asking you boys to convert it.... but if anyone is so gently to do that thing ....


thank you