Database connectivity with the program.

hi,

The code below will be in your web.config

<connectionstrings>
        <add name="ConnectionStringName" connectionstring="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|DatabaseName.mdb;Persist Security Info=True" providername="System.Data.OleDb" />
 </connectionstrings>

Now below this is how you will use your ConnectionString name in your class or code behind a page


//Method for A Database Connection

public string dbConnection()
{

    string connString = ConfigurationManager.ConnectionStrings["ConnectionStringName"].ConnectionString;

    try
    {
        // set up and open connection
    dbConn = new OleDbConnection(connString);
     dbConn.Open();

    }

    catch (OleDbException exp)
    {

    }
    return connString;

}

maybe u will need the following namespace


using System.Configuration;

Hope it helps...

Best Luck
Happy Coding :)

This will give you a complete tutorial on all basic data access operations

A Beginner's Tutorial for Understanding ADO.NET[^]