Reader Level:
TUTORIAL

Connect to Access Database in C# and ADO.NET

Posted by Muhammad Imran Taj Tutorials | Visual C# February 26, 2008
This artilce explains how to connect and get data from an Access database in C# and ADO.NET.
  • 0
  • 0
  • 410159

These are very simple steps to create and connect an Access database in C#. 

  • Create Access database (e.g  student)



  • Now open you notepad and click on save As button. Name then Imran.hdl. Change save type "ALL FILES".

  • Now double click on imran.udl file. A wizard will start like this:

  • Click Provider TAB, select Microsoft Jet 4.0 OLE DB (denoted by black arrow) then click next. Now click "Select or enter a database name" and select the desire database then click open.

  • Now click on test connection and click OK
  • Now edit this UDL file with note pad and copy link as shown below



  • Now Open Visual Studio editor and create Text boxes and buttons like

  • Double click on the form and add some code

cmd.CommandText = "insert into student values(" + this.textBox1.Text + ",'" + this.textBox2.Text + ",'" + this.textBox3.Text + ",'" + this.textBox4.Text + "');";
int temp = cmd.ExecuteNonQuery();
if (temp > 0)
{
    MessageBox.Show("Record Added");
}
else
{
    MessageBox.Show("Record not Added");
}
mycon.Close();

Article Extensions
Contents added by akit kasliwal on Oct 17, 2012
g
Contents added by Edgar Picuasi on Jun 15, 2011
gracias
Contents added by dsfdsf dsfdsf on Nov 14, 2009

hx

Contents added by trushant pachnekar on Jul 10, 2009
dfgdfgfdgfd
Contents added by Kirk Vilaimal on May 25, 2009
Hi, I'm Kirk  just  beginner
COMMENT USING

Trending up