Use enterprise library.
Download Enterprise Library from
here[
^]
Add something like this into your web.config
<configSections>
<section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data" />
</configSections>
<dataConfiguration defaultDatabase="Connection String" />
<connectionStrings>
<add name="yourDatabase" connectionString="Database=yourDatabase;Server=(local);Integrated Security=SSPI" providerName="System.Data.SqlClient" />
</connectionStrings>
Then access the databse using code like this:
public static User LogOn(string userCode, string password)
{
Database db = DatabaseFactory.CreateDatabase("eValue8DB");
DbCommand dbCommand = db.GetStoredProcCommand("Get_User");
db.AddInParameter(dbCommand, "UserCode", System.Data.DbType.String, userCode);
db.AddInParameter(dbCommand, "Password", System.Data.DbType.String, password);
using (IDataReader reader = db.ExecuteReader(dbCommand))
{
if (reader.Read())
{
}
else
{
return null;
}
}
}
P.S. you need to add a reference to the entrprise library in the project in which yo uhave this DB access code