Solved

i want to connect MSAccess 2007 database to my DataGridview in C#.net window application ??

Posted on 2011-02-15
5
664 Views
Last Modified: 2012-06-27
My MS access 2007 database is in C:\Data folder named 'Question_Assistant.accdb'

now i want to display the table from this access database to my datagridview ...
i have the coding for the connection but i don't know the connectionstring for MS Access 2007,
please tell me the connection string for that ..
0
Comment
Question by:Parth48
5 Comments
 
LVL 5

Accepted Solution

by:
Tompa99 earned 400 total points
ID: 34904173
Hi,

On this website you get all the connection strings you need.
http://www.connectionstrings.com/

Best Regarsd Tompa
0
 
LVL 53

Expert Comment

by:Dhaest
ID: 34904238
A complete example, with connection and getting the data can be found here:

C# Tutorial - Binding a DataGridView to a Database
http://www.switchonthecode.com/tutorials/csharp-tutorial-binding-a-datagridview-to-a-database

Working with Data—Using the DataGridView
http://en.csharp-online.net/Working_with_Data%E2%80%94Using_the_DataGridView
0
 
LVL 14

Expert Comment

by:Dhanasekaran Sengodan
ID: 34904243
0
 
LVL 14

Expert Comment

by:Dhanasekaran Sengodan
ID: 34904246
0
 
LVL 11

Assisted Solution

by:SAMIR BHOGAYTA
SAMIR BHOGAYTA earned 100 total points
ID: 34904524
Hi,  you have to use the following namespace for it.


using System.Data.Oledb;

Then, OledbConnection, OledbCommand, OledbDataSet
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

708 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now