Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

VB.Net - Connecting a datagridview to an access database

Posted on 2011-09-22
2
Medium Priority
?
265 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
2 Comments
 
LVL 11

Accepted Solution

by:
Deepak Lakkad earned 2000 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

564 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