Add the Standard Exe Project in vb6 IDE on the New Menu
Adding DataEnvironMent to your Project
Click the Project --> DataEnvironment in VBIDE or
RightClick in the ProjectWindow on the project title and click the add and then add the DataEnvironment Designer

Now after Adding the DataEnvironment Right Click on the Connection node you see the Following menu

Now click the Properties add the Connection According to your Need Whether the Access or sql
Now Click the AddCommand Menu
Now a New node will be add under the connection Node
Now Right click on the command Node click the properties now on the Database objects select Table and select your Table and then click ok
Now there is new nodes under the command node these are the fields in your table
Now in the Vb6 IDE Click the Menu window TileVertically
Now the form and the DataEnvironment show side by side Click and drag the commandObject into the Form
Now you see that there is some text boxes and labels according to your fields Name
Now Add command buttons in your form for move records move Records,Adding new records and save it, Etc..
With the following RecordSet
DataEnvironMent1.rsCommand1
you can play with this recordset as like normal recordset
No comments:
Post a Comment