Home All Groups Group Topic Archive Search About

Inserting information to Database please help

Author
27 Jul 2006 7:47 PM
Teo
Hey guys!!
I created a database using the built in SQL Express that comes with Visual
Basic Express.
I created the tables and relationships for now and I want to start testing
how the information would go into the database.
On my application I will be adding information as well as retrieving
information from the DB for analysis in my company.
What would be the best way to add information that I insert on a windows
form into a specific table on my database? I already created the textboxes
with the appropiate labels and the command button. Now, I am blocked at what
should I add inside the command button to open the connection to the DB and
add the information to the table.
Please any help would be appreciated.
Also I am not sure what type of connection VB created for me when I added
the tables and relationships to the SQL Express Database.

Thanks much in advance.
Teo

Author
27 Jul 2006 9:46 PM
Mike Lowery
You can start by reading this:
http://www.asp.net/QuickStart/aspnet/doc/data/default.aspx

Show quoteHide quote
"Teo" <t**@teo.com> wrote in message
news:e4k$RWbsGHA.4608@TK2MSFTNGP04.phx.gbl...
> Hey guys!!
> I created a database using the built in SQL Express that comes with Visual
> Basic Express.
> I created the tables and relationships for now and I want to start testing
> how the information would go into the database.
> On my application I will be adding information as well as retrieving
> information from the DB for analysis in my company.
> What would be the best way to add information that I insert on a windows
> form into a specific table on my database? I already created the textboxes
> with the appropiate labels and the command button. Now, I am blocked at what
> should I add inside the command button to open the connection to the DB and
> add the information to the table.
> Please any help would be appreciated.
> Also I am not sure what type of connection VB created for me when I added
> the tables and relationships to the SQL Express Database.
>
> Thanks much in advance.
> Teo
>
>
>