public static int Retrieve_Count(string sql)
{
SqlConnection conn = DataProvider.CreateConnect();
SqlCommand cmd = new SqlCommand(sql, conn);
int row = (int)cmd.ExecuteScalar();
return(row);
}
public static SqlDataReader Retrieve_Table(string sql)
{
SqlDataReader dr;
SqlConnection conn = DataProvider.CreateConnect();
SqlCommand cmd = new SqlCommand(sql, conn);
dr = cmd.ExecuteReader();
return(dr);
}
