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); }