Solved

VB.Net - Connecting a datagridview to an access database

Posted on 2011-09-22
2
252 Views
Last Modified: 2012-05-12
Hi Experts.   In VB.net, I have a datagridview and have set the binding source to bindingsource1 and a BindingNavigator also connected to bindingsource1.
I then have bindingsource1 connected to a dataset which connect successfully to an small Access Database.   All these connections are made under properties.  When I run the program I get nothing in the Datagridview.  Shouldnt I get the databse data appearing in the Datagridview?    
0
Comment
Question by:PNRT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 11

Accepted Solution

by:
Deepak Lakkad earned 500 total points
ID: 36580102
Hi
Try following code

YourDataGridView.DataSource = YourBidningSource
0
 
LVL 2

Author Comment

by:PNRT
ID: 36580154
Still the same I'm afarid.  If I disconnect bindingsource1 from the dataset then the DGV and the navigator work OK together, but as soon as I add the dataset to bindingsource1, the DGV and the navigator are all greyed out.  Thanks for the reply
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question