pc.aspx.cs代码如下
private void InitData()
{ DataTable dt = pc.QueryJtfs(new Hashtable());
int sgbh = Convert.ToInt32(Request.QueryString["sgbh"]);//---------如何根据上面接受到的变量显示数据---------------// DropDownListJtfs.Items.Add(new ListItem("aaa", "1"));
DropDownListJtfs.Items.Add(new ListItem("bbb", "2"));
DropDownListJtfs.Items.Add(new ListItem("ccc", "3"));
foreach (DataRow dr in dt.Rows)
{
DropDownListJtfs.Items.Add(new ListItem(dr["dsrbx"].ToString(), dr["dsrbx"].ToString()));
}
DropDownListJtfs.Items.Add(new ListItem("eee", "5"));
}bll/pc.cs代码如下
public static DataTable QueryJtfs(Hashtable queryItems)
{
string where = SqlStringConstructor.GetConditionClause(queryItems);
string sql = "Select * From [pc_party] "+where;
//---想实现这样的查询效果:string sql = "Select * From [pc_party] where sgbh=12345";-----//
Database db = new Database();
return db.GetDataTable(sql);
}
private void InitData()
{ DataTable dt = pc.QueryJtfs(new Hashtable());
int sgbh = Convert.ToInt32(Request.QueryString["sgbh"]);//---------如何根据上面接受到的变量显示数据---------------// DropDownListJtfs.Items.Add(new ListItem("aaa", "1"));
DropDownListJtfs.Items.Add(new ListItem("bbb", "2"));
DropDownListJtfs.Items.Add(new ListItem("ccc", "3"));
foreach (DataRow dr in dt.Rows)
{
DropDownListJtfs.Items.Add(new ListItem(dr["dsrbx"].ToString(), dr["dsrbx"].ToString()));
}
DropDownListJtfs.Items.Add(new ListItem("eee", "5"));
}bll/pc.cs代码如下
public static DataTable QueryJtfs(Hashtable queryItems)
{
string where = SqlStringConstructor.GetConditionClause(queryItems);
string sql = "Select * From [pc_party] "+where;
//---想实现这样的查询效果:string sql = "Select * From [pc_party] where sgbh=12345";-----//
Database db = new Database();
return db.GetDataTable(sql);
}
对应值放入value中,再根据哈希表生成动态的查询语句,当然,一般直接使用DataTable做的居多