Now I want access data in anther system which is in MS Access.How can I do this ?
I am using c# .net front end and MS access for back end for window application.?
Make a new Connection via OledbDataAdapter.In the dataadapter's configuration wizard, Select newConnection. A dialogue box will appear. In provider tab Select Microsoft Jet 4.0 OLEDB Provider and click next. In connection tab , enter the database name and click test connection. A message will appear indicating the success of connection. now you can create your query through Query Builder and bring the data in dataset and can display in Grid or list or anything else. The main thing is making a connection with Ms Access.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment