Sample ADO.NET Request..

[billsecond]

Hello, i am inquring about ADO.NET and want to know the following using code only...

I want to open the database using a connection string of any kind

Then i want to open a specfic table in a database

Then i want to be able to have the following:
2 text boxs, and a button, basicly when the user enters a first name in the first textbox and presses the button, it will then open the database and search for the record, then once the record has been found (the first occurance) then it will display the last name in textbox2 (in vb.6 i use to use rs.fields("l_name") etc...)

Then once it does this, i want the user to be able to change the last name and have the user hit a second button to update the field

then i want the table updated and saved (database)

then i want the database closed..

I would also like to know how to do simple quaries like insert, delete tables, etc....

 

[chrisabbey]

Purchase the book:

ADO.NET Cookbook
by:Bill Hamilton

Or pay me $100 bucks and I'll email the working program to you.