Solved

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

Posted on 2011-02-15
5
666 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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

803 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