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
Solved

VB.Net - Connecting a datagridview to an access database

Posted on 2011-09-22
2
247 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 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

837 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