string ConnectionString = DAL.ConnectionString;
using System.Configuration;
public class DAL
{
public static string ConnectionString
{
get { return @"Data Source=.;Initial Catalog=BOOKHOME;Persist Security Info=True;User ID=sa;Password=***********"; }
}
}
public DataTable All_Category()
{
SqlConnection con = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = SqlSelect;
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
con.Close();
return dt;
}