How To Add Data Environment
1. Go to project menu and choose data environment.
2. On the data environment window, right click the connection icon and then choose properties.
3. On the data link properties dialog box, choose a provider (microsoft.jet 4.0 OLEDB Provider)
4. Click next.
5. Select the database by clicking the small browse button.
6. Browse the existing database then click open.
7. Click text connection.
8. Click ok when done.
9. Right click the connection icon again and choose add command.
10. A command icon will appear (you can remove it by right clicking on it and typing the desired command name.)
11. Right click it and then choose properties.
12. Click the SQL statement option button for easier table recordset connection.
13. Type select * from table on the text area below.
Note: (*refer to the entire field name on the table, while table1 is the name of the existing table.)
14. Click ok when done.
1. Go to project menu and choose data environment.
2. On the data environment window, right click the connection icon and then choose properties.
3. On the data link properties dialog box, choose a provider (microsoft.jet 4.0 OLEDB Provider)
4. Click next.
5. Select the database by clicking the small browse button.
6. Browse the existing database then click open.
7. Click text connection.
8. Click ok when done.
9. Right click the connection icon again and choose add command.
10. A command icon will appear (you can remove it by right clicking on it and typing the desired command name.)
11. Right click it and then choose properties.
12. Click the SQL statement option button for easier table recordset connection.
13. Type select * from table on the text area below.
Note: (*refer to the entire field name on the table, while table1 is the name of the existing table.)
14. Click ok when done.
No comments:
Post a Comment