public void BindSalesType()
{
string sqlstr = "select * from SaleType";
DataSet ds = SqlHelper.QueryERP(sqlstr);
salestype.Items .Insert(0,new ListItem("请选择",""));
salestype.DataSource = ds.Tables[0];
salestype.DisplayMember = "cSTName";
salestype.ValueMember = "cSTCode";
}
这是我写的你个下拉框的绑定方法但是绑定不上请看下错在哪里了,谢谢 在线等
{
string sqlstr = "select * from SaleType";
DataSet ds = SqlHelper.QueryERP(sqlstr);
salestype.Items .Insert(0,new ListItem("请选择",""));
salestype.DataSource = ds.Tables[0];
salestype.DisplayMember = "cSTName";
salestype.ValueMember = "cSTCode";
}
这是我写的你个下拉框的绑定方法但是绑定不上请看下错在哪里了,谢谢 在线等
{
string sqlstr = "select * from SaleType";
DataSet ds = SqlHelper.QueryERP(sqlstr);
DataRow dr=ds.tables[0].NewRow;
dr["cSTCode"]="XXX";
dr["cSTName"]="请选择";
ds.tables[0].rows.add(dr);
salestype.DataSource = ds.Tables[0];
salestype.DisplayMember = "cSTName";
salestype.ValueMember = "cSTCode";
}
DataTable table = dataset.Tables[0]; //把数据源赋给table
DataRow dr = table.NewRow();
dr[0] = "0";
dr[1] = "==请选择==";
table.Rows.InsertAt(dr, 0);
cboProvince.DataSource = table; //comboBox1 的数据源为table
cboProvince.SelectedIndex = 0; //默认显示"请选择
cboProvince.DisplayMember = "provinceName";
cboProvince.ValueMember = "provinceID";
{
string sqlstr = "select * from SaleType";
DataSet ds = SqlHelper.QueryERP(sqlstr);
DataRow dr=ds.tables[0].NewRow;
dr["cSTCode"]="XXX";
dr["cSTName"]="请选择";
ds.tables[0].rows.insert(dr,0);
salestype.DisplayMember = "cSTName";
salestype.ValueMember = "cSTCode";
salestype.DataSource = ds.Tables[0];
cboProvince.SelectedIndex = 0; //默认显示"请选择
}