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....