string ConnStr = System.Configuration.ConfigurationManager.ConnectionStrings["dbconn"].ToString();
SqlConnection myconn = new SqlConnection(ConnStr);
myconn.Open(); //打开数据库连接
// string sqlstr = "select * from book where ";
string sqlstr = "select TB_Trade.buyer_nick,TB_Order.* from TB_Trade,TB_Order where TB_Trade.tid=TB_Order.tid and TB_Trade.buyer_nick='" + nick + "' and TB_Order.status='WAIT_BUYER_CONFIRM_GOODS'";
SqlCommand mycmd = new SqlCommand(sqlstr, myconn);//创建数据库命令
SqlDataReader mydr = mycmd.ExecuteReader(); //Repeater数据控件绑定
DropDownList1.DataSource = mydr;//指定数据源
DropDownList1.DataTextField = "TB_Order.title";
DropDownList1.DataValueField = "TB_Order.tid";
DropDownList1.DataBind();//绑定到指定的数据源
myconn.Close();
不知道哪错了
SqlConnection myconn = new SqlConnection(ConnStr);
myconn.Open(); //打开数据库连接
// string sqlstr = "select * from book where ";
string sqlstr = "select TB_Trade.buyer_nick,TB_Order.* from TB_Trade,TB_Order where TB_Trade.tid=TB_Order.tid and TB_Trade.buyer_nick='" + nick + "' and TB_Order.status='WAIT_BUYER_CONFIRM_GOODS'";
SqlCommand mycmd = new SqlCommand(sqlstr, myconn);//创建数据库命令
SqlDataReader mydr = mycmd.ExecuteReader(); //Repeater数据控件绑定
DropDownList1.DataSource = mydr;//指定数据源
DropDownList1.DataTextField = "TB_Order.title";
DropDownList1.DataValueField = "TB_Order.tid";
DropDownList1.DataBind();//绑定到指定的数据源
myconn.Close();
不知道哪错了
DropDownList1.DataTextField = "TB_Order.title";
DropDownList1.DataValueField = "TB_Order.tid";直接title,tid 应该就可以了
DropDownList1.DataTextField = "title";
DropDownList1.DataValueField = "tid";
试试。