Solved

c#2010 connect to access database

Posted on 2013-01-17
5
492 Views
Last Modified: 2013-01-17
Hi

I am new to c# and gotta develop a Windows appplication.  Needs to connect with access database.

how is this done??

All tutts assume you are using sqlserverr


Cheers
0
Comment
Question by:cycledude
  • 3
  • 2
5 Comments
 
LVL 15

Expert Comment

by:angus_young_acdc
ID: 38787713
To be honest it is basically the same code!  It is generally a case of replace 'Sql' with 'OleDb'

So
SqlConnection connection = new SqlConnection("My connection string");

Becomes

OleDbConnection connection = new OleDbConnection("my connection string");

Different namespaces but the syntax for them is generally the same.  The major difference would be in your connection string, but that isn't a big issue either.

For example: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MyDB.mdb"
0
 
LVL 15

Expert Comment

by:angus_young_acdc
ID: 38787755
Example here, reading from a database with a table called MyTable and two columns one for UserName and one for UserBirthday and you want to read everything in this table.

                    OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MyDb.mdb");
                    connection.Open();
                    OleDbCommand cmd = new OleDbCommand("SELECT * FROM myTable");
                    cmd.CommandType = System.Data.CommandType.Text;
                    OleDbDataReader reader = default(OleDbDataReader);
                    reader = cmd.ExecuteReader();
                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            // do something, eg
                            string myUser = reader["UserName"].ToString();
                            string myBirthday = reader["UserBirthday"].ToString();
                            // Do something else
                        }
                    }
                    connection.Close();

Open in new window

0
 

Author Comment

by:cycledude
ID: 38787857
Thanks angus

I get a problem on the line

Reader = cmd.executereader ()


Invalidoperationexception

Executereader connection property has not been initialised

Any ideas?
0
 
LVL 15

Accepted Solution

by:
angus_young_acdc earned 500 total points
ID: 38788190
Whoops missed a line!

Just after this: cmd.CommandType = System.Data.CommandType.Text;


put this:
cmd.Connection = connection;
0
 

Author Closing Comment

by:cycledude
ID: 38788375
dude, you are a star!
thanks
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In order to hide the "ugly" records selectors (triangles) in the rowheaders, here are some suggestions. Microsoft doesn't have a direct method/property to do it. You can only hide the rowheader column. First solution, the easy way The first sol…
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
This video discusses moving either the default database or any database to a new volume.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

747 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

12 Experts available now in Live!

Get 1:1 Help Now