Writing to database

[leemp5]

Hi everyone.

First off this is the first time i have ever used VB. I am trying to write a program for work.

I have created a form in VB where the user enters data into text boxes and rich text boxes.

Please could somone tell me how to do the following:

When the user clicks the "save" button, the data they have entered in the text boxes gets saved into an excel or access database for later viewing.

All help is greatly appreciated!

[GaryMazzone]

There are complete examples for this in the FAQ section at the top of the Database fourm

[leemp5]

Hi thanks for the reply, iv had a look around the FAQ section but i have no idea where i am looking. Please could you point me to the post that explains what i need?
Many thanks.

[GaryMazzone]

For .Net start here:

http://www.vbforums.com/showthread.php?t=469872

[leemp5]

Hi,
I dont understand any of that post.
Some of the questions running through my head are:
Do i use that code?
Where do i place the code?
What do i put in place of "connection string here"?

I am a complete beginner at this. I created my form simply by using "drop and drag" in VB.
Thanks.

[GaryMazzone]

No one here will write this for you. You must make an attempt post errors you get. The code you write, what goes wrong, what you expected and what line it errors on.

[leemp5]

Hi,
Im sorry i may have misled you.
I do not wish anybody to write this code for me. Im a wizz at html css etc and i have been on forums many times and know how the system works.

Im simply after a few quick instructions of how to get the form i have created to write the fields to the database in Visual Basic 2008 Express Edition.

For example if i wanted to create a text box, i wouldnt be expecting anybody to provide the code for me, id be after something like the following:

1. Click the toolbox button which is towards the right hand side of the toolbar.
2. Select "text box" from the list.
3. Click on the form where you want to place the textbox.

Thanks

[GaryMazzone]

What you asking will depend on how you go about connecting to and getting data from the database.

I you use wizard then thing go one way, if you connect manually and do every thing in your own code it chages a little.

You the code will go in varoius places, on form load you coud place code that would fill a datagrid with information from a database (or textboxes), could might need a binding datasource if the data is expected to automaticly change in the textboxs when you scroll though a datatable (something returned from the database).

You could on a button click event add code to that will insert/update/delete to the database on your own. Or you might have an Insert/Update/Delete that is connected to the data adapter (that will fill a datatable).