N
NoneOfBusiness
Does anyone know of any good tutorials that can show me how to
1) connect and retrieve data from an Acess and SQL Server DB
2) Update data in the db
3) Add new data to db
I can actually query the northwind db and display the results in a
datagrid already but i do not know if its the proper way to go about
it efficiently.
What i would like to see is code that actually adds new data to an
access database. let me give a scenario
Access db (dbPeople) consists of one table - tblPerson
tblPerson has 3 fields, pkey (autogenerated primary key), FirstName,
LastName.
Lets also say we have a form that has a first name text box and a Last
name textbox, with an ADD button. If data has been entered and add
clicked, what is the code to make the connection, add new rows to the
DB.
This seems like it would be simple, but as i am learning VB.net 2003
it is not so to me. i can do this already with CBuilder and Delphi,
but there are certain things in the .net framework that i would like
to be able to use and write the results to a DB
TIA for everyones help for this VB newbie....
1) connect and retrieve data from an Acess and SQL Server DB
2) Update data in the db
3) Add new data to db
I can actually query the northwind db and display the results in a
datagrid already but i do not know if its the proper way to go about
it efficiently.
What i would like to see is code that actually adds new data to an
access database. let me give a scenario
Access db (dbPeople) consists of one table - tblPerson
tblPerson has 3 fields, pkey (autogenerated primary key), FirstName,
LastName.
Lets also say we have a form that has a first name text box and a Last
name textbox, with an ADD button. If data has been entered and add
clicked, what is the code to make the connection, add new rows to the
DB.
This seems like it would be simple, but as i am learning VB.net 2003
it is not so to me. i can do this already with CBuilder and Delphi,
but there are certain things in the .net framework that i would like
to be able to use and write the results to a DB
TIA for everyones help for this VB newbie....