ASP.NET

ASP.NET RSS

i need help in code of connecting from asp.net 2005 to access

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: May 2008

Posts: 6

Reputation: nada fouad is an unknown quantity at this point

Solved Threads: 0

nada fouad nada fouad is offline

Offline

Newbie Poster

i need help in code of connecting from asp.net 2005 to access

Feb 16th, 2009

i want to connect asp.net 2005 with access .
now i need for the code do do this connection

•

Join Date: Nov 2008

Posts: 34

Reputation: manoj_582033 is an unknown quantity at this point

Solved Threads: 0

manoj_582033 manoj_582033 is offline

Offline

Light Poster

Try This

Feb 16th, 2009

Create a variable Like x
Then
x="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\office.mdb"
Note :C:\Program Files\office.mdb By replacing it put your datasource And then try this

•

Join Date: May 2008

Posts: 6

Reputation: nada fouad is an unknown quantity at this point

Solved Threads: 0

nada fouad nada fouad is offline

Offline

Newbie Poster

Re: i need help in code of connecting from asp.net 2005 to access

Feb 17th, 2009

thnx for reply

what about the full code & the veriables when i want to do insert and the code to execute the query ???

•

Join Date: Jul 2005

Posts: 483

Reputation: campkev is an unknown quantity at this point

Solved Threads: 19

campkev

Offline

Posting Pro in Training

Re: i need help in code of connecting from asp.net 2005 to access

Feb 17th, 2009

Go to http://www.connectionstrings.com
It is your friend. Bookmark it.

•

Join Date: Feb 2009

Posts: 3,200

Reputation: sknake has much to be proud of

Solved Threads: 571

sknake

Offline

.NET Enthusiast

Re: i need help in code of connecting from asp.net 2005 to access

Feb 17th, 2009

There are two functions for generating the conn string depending on the version of access, which can be determined by the file extension or various other ways.

 Help with Code Tags 
 c# Syntax (Toggle Plain Text) 
    public static string BuildAccessConnectionString(string Filename, string Username, string Password, string DatabasePassword)
    {
      return string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='{0}';User Id={1};Password={2};Jet OLEDB:Database Password={3};",
                                   Filename.Replace("'", "''"),
                                   Username,
                                   Password,
                                   DatabasePassword);
    }
    public static string BuildAccess2007ConnectionString(string Filename, string DatabasePassword)
    {
      return string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source='{0}';Persist Security Info=False;Jet OLEDB:Database Password={1};",
                                 Filename.Replace("'", "''"),
                                 DatabasePassword);
    }
    private void simpleButton3_Click(object sender, EventArgs e)
    {
      string connStr = BuildAccessConnectionString(@"C:\data\CustList01.mdb", string.Empty, string.Empty, string.Empty);
      DataTable result = new DataTable();
      using (OleDbConnection conn = new OleDbConnection(connStr))
      {
        conn.Open();
        using (OleDbCommand cmd = new OleDbCommand(@"Select * From [CustList01]", conn))
        {
          using (OleDbDataReader dr = cmd.ExecuteReader())
          {
            result.Load(dr);
          }
        }
        conn.Close();
      }
      //Work with table
      MessageBox.Show(result.Rows.Count.ToString());
    }
    public static string BuildAccessConnectionString(string Filename, string Username, string Password, string DatabasePassword)
    {
      return string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='{0}';User Id={1};Password={2};Jet OLEDB:Database Password={3};",
                                   Filename.Replace("'", "''"),
                                   Username,
                                   Password,
                                   DatabasePassword);
    }
    public static string BuildAccess2007ConnectionString(string Filename, string DatabasePassword)
    {
      return string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source='{0}';Persist Security Info=False;Jet OLEDB:Database Password={1};",
                                 Filename.Replace("'", "''"),
                                 DatabasePassword);
    }
    private void simpleButton3_Click(object sender, EventArgs e)
    {
      string connStr = BuildAccessConnectionString(@"C:\data\CustList01.mdb", string.Empty, string.Empty, string.Empty);
      DataTable result = new DataTable();
      using (OleDbConnection conn = new OleDbConnection(connStr))
      {
        conn.Open();
        using (OleDbCommand cmd = new OleDbCommand(@"Select * From [CustList01]", conn))
        {
          using (OleDbDataReader dr = cmd.ExecuteReader())
          {
            result.Load(dr);
          }
        }
        conn.Close();
      }
      //Work with table
      MessageBox.Show(result.Rows.Count.ToString());
    }