example

[kante]

i'd 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 can't 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 it's 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]

:eek:

i'm 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 couldn't 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...

i'm not asking you boys to convert it.... but if anyone is so gently to do that thing ....:D

 

 

thank you

database.zip