public DataTable GetPage2(int PageIndex, int PageSize, out int RecordCount, out int PageCount,string AdduserName)
{
string sql = " ";
string AllFields = "ID,UserName,UserNum,LoginName,LoginPass,UserType,IsDeleted,InDateTime,province,city,county,IndustryId,Email,Phone,Add_UserName";
string Condition = "Users " + sql + "";
string IndexField = "ID";
string OrderFields = "order by ID desc";
return DbHelperSQL.ExecutePage(AllFields, Condition, IndexField, OrderFields, PageIndex, PageSize, out RecordCount, out PageCount, null);
}
我要写的是 where UserNum=Usernum and UserNum=AdduserName
可是我不知道该在上面那些代码那怎么写啊 帮帮忙啊
{
string sql = " ";
string AllFields = "ID,UserName,UserNum,LoginName,LoginPass,UserType,IsDeleted,InDateTime,province,city,county,IndustryId,Email,Phone,Add_UserName";
string Condition = "Users " + sql + "";
string IndexField = "ID";
string OrderFields = "order by ID desc";
return DbHelperSQL.ExecutePage(AllFields, Condition, IndexField, OrderFields, PageIndex, PageSize, out RecordCount, out PageCount, null);
}
我要写的是 where UserNum=Usernum and UserNum=AdduserName
可是我不知道该在上面那些代码那怎么写啊 帮帮忙啊
string sql="select * from 某表 where UserNumer='"+Usernum+"' and UserNum='"+AdduserName+"'"";