public static int GetTableCount(SqlConnection connection, string tableName, string condition)
{
int count = 0;
DataTable dt = TableDAL.GetTable(connection, tableName, condition);
if (null != dt & 0 < dt.Rows.Count)
{
count = dt.Rows.Count;
}
return(count);
}
public static DataTable GetTopTable(int topCount, string tableName, string condition)
{
SqlConnection cn = new SqlConnection(TableDAL.DefaultConnectionString);
return(TableDAL.GetTable(tableName, condition, " top " + topCount + " * "));
}
public static DataTable GetTable(SqlConnection connection, string tableName, string condition)
{
return(TableDAL.GetTable(connection, tableName, condition, ""));
}
public static DataTable GetTable(string tableName, string condition, string fieldList)
{
SqlConnection cn = new SqlConnection(TableDAL.DefaultConnectionString);
return(TableDAL.GetTable(cn, tableName, condition, fieldList));
}