OleDbConnection con = db.con();
con.Open();
string constr1 = "SELECT * FROM [pro_c1] ORDER BY [Order_] DESC ";
OleDbDataAdapter adp = new OleDbDataAdapter(constr1, con);
DataSet ds = new DataSet();
adp.Fill(ds, "pro_c1");
this.drop_class1.DataSource = ds.Tables["pro_c1"];
this.drop_class1.DataTextField = "ClassName";
this.drop_class1.DataValueField = "Class1ID";
this.drop_class1.DataBind();
//this.drop_class1.Items.Insert(0, new ListItem("一级分类", "0"));
con.Close();
//this.drop_class1.Items.Insert(0, new ListItem("一级分类", "0"));
我现在不要这个为默认的,我是能过产品数据库c1,c2的值选择为默认的类别
dropdownlist的value为C1,C2的值,请教
con.Open();
string constr1 = "SELECT * FROM [pro_c1] ORDER BY [Order_] DESC ";
OleDbDataAdapter adp = new OleDbDataAdapter(constr1, con);
DataSet ds = new DataSet();
adp.Fill(ds, "pro_c1");
this.drop_class1.DataSource = ds.Tables["pro_c1"];
this.drop_class1.DataTextField = "ClassName";
this.drop_class1.DataValueField = "Class1ID";
this.drop_class1.DataBind();
//this.drop_class1.Items.Insert(0, new ListItem("一级分类", "0"));
con.Close();
//this.drop_class1.Items.Insert(0, new ListItem("一级分类", "0"));
我现在不要这个为默认的,我是能过产品数据库c1,c2的值选择为默认的类别
dropdownlist的value为C1,C2的值,请教
解决方案 »
- FCK编辑器图片上传问题。。
- 网页中的验证码通过点击按钮刷新
- 一条update语句
- VS2005使用上的小技巧
- 如何在程序中实现DTS 将access库导入到sqlServer中
- asp.netforums中定时器得问题
- 急:如何在GridView执行特殊的SQL语句
- report或者datagrid的内容转excel文件中文变乱码的问题,急!
- 中文变成??????
- datagrid返回到客户端是<table></table>,现在我要<td class=aa></td>,应该设置datagrid的哪个属性?
- 求Visual Stdio .net 下载地址
- 哪位兄弟姐妹们进来帮帮啊~~在线等 ~~急
private void SetListSelected(ListControl list, string match)
{
for (int i=0; i<list.Items.Count; i++)
{
if ((list.Items[i].Value == match)||(list.Items[i].Text == match))
{
if (list.SelectedItem != null) list.SelectedItem.Selected = false;
list.Items[i].Selected = true;
break;
}
else
{
list.Items[i].Selected = false;
}
}
}然后调用this.SetListSelected(drop_class1,strValue);//strValue就是你数据库中产品的值
this.drop_class1.DataBind();
this.drop_class1.SelectedValue = "c1"
this.drop_class1.SelectedValue = c1;
string c2 = Convert.ToString(dr["c2"]);
this.drop_class2.SelectedValue = c2;
我用这种方法,读取产品表中的类的,值,这样也行哦....