Your WebConfig File.
===========================
<add name="ConnectionString" connectionString="Data Source=SERVER;Initial Catalog=DbName;User ID=YourUserName;Password=YourPwd" providerName="System.Data.SqlClient"/>
string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
Declaration For ADodb
================================
string str;
SqlConnection con;
SqlCommand com;
SqlCommand cmd;
SqlDataAdapter sqlda;
DataSet ds;
DataTable Dt = new DataTable();
public DataTable ReturnDt(string RecStr)
{
SqlConnection con = new SqlConnection(strConnString);
con.Open();
str = RecStr;
com = new SqlCommand(str, con);
sqlda = new SqlDataAdapter(com);
ds = new DataSet();
sqlda.Fill(Dt);
return Dt;
}
Mark as Answer if its helpful to you
Kumaraspcode2009@gmail.com
Aspbimal, if this helps please login to Mark As Answer. | Alert Moderator