//分页查询
public DataSet GetPagesList(int Pager1, int Pager2, string TableName)
{string sql = "select * from myusers order by id desc";DataSet ds = DBHelper.GetDataSets(sql, Pager1, Pager2, TableName);
return ds;
}myusers表:(外键表)id nameid sex email 1 1 男 [email protected]
2 2 女 [email protected]
users表:(主键表)id name pwd1 aaa 1232 bbb 123
我这条sql 应该怎么写才可以正确展示?我需要在页面展示myusers表的数据应该这样展示:
1 aaa 男 [email protected]
2 bbb 女 [email protected] static DataSet GetDataSets(string SqlStrings, int Pager1, int Pager2, string TableName)
{
SqlConnection Connection = new SqlConnection(CONNECTION_STRING);
Connection.Open();
SqlDataAdapter sda = new SqlDataAdapter(SqlStrings, Connection);
DataSet ds = new DataSet();
sda.Fill(ds, Pager1, Pager2, TableName);
return ds;}传的参数是string 怎么把它弄成ilist?或者用其他方法写?谢谢!~
public DataSet GetPagesList(int Pager1, int Pager2, string TableName)
{string sql = "select * from myusers order by id desc";DataSet ds = DBHelper.GetDataSets(sql, Pager1, Pager2, TableName);
return ds;
}myusers表:(外键表)id nameid sex email 1 1 男 [email protected]
2 2 女 [email protected]
users表:(主键表)id name pwd1 aaa 1232 bbb 123
我这条sql 应该怎么写才可以正确展示?我需要在页面展示myusers表的数据应该这样展示:
1 aaa 男 [email protected]
2 bbb 女 [email protected] static DataSet GetDataSets(string SqlStrings, int Pager1, int Pager2, string TableName)
{
SqlConnection Connection = new SqlConnection(CONNECTION_STRING);
Connection.Open();
SqlDataAdapter sda = new SqlDataAdapter(SqlStrings, Connection);
DataSet ds = new DataSet();
sda.Fill(ds, Pager1, Pager2, TableName);
return ds;}传的参数是string 怎么把它弄成ilist?或者用其他方法写?谢谢!~
谢谢大家关注