ADO Data Control

[vidkrish]

Hi,

I used a ADO Data Control to fetch the records from a table in SQL
Server ( 6.5 ) database. Please let me know as to how changes could be made to the records through Visual Basic ( 6.0 ) itself & not going to the table & changing it.
I would appreciate any help.

Thanking you,
Vidya.

[Nick Anderson]

I am currently learning to use ADO Data Controls... What I suggest you do is to use the form builder utility in VB Data Manager to build a sample form. I know that this form uses the "simple" data control (not ADO) but it is a good ground to start on. From this form, you can get the basic ideas of what types of commands you need to accomplish certain things. For starters, to enter information into a database via VB, you will need textboxes that are data bound ("bound" to your database). Check the textbox properties for more information. There are various properties such as "Data source", "Record source", "Data field", etc. The MSDN library also has very useful examples on using ADO. Best of luck!

[vidkrish]

Thanks a lot for the reply.
I'll certainly try it out.

Thanking you,
Vidya.