private void frmBatchAddBusinessCard_Load(object sender, EventArgs e)
{
try
{
frmMain main = new frmMain();
SqlConnection conn = BLL.conn.SqlConn();
string sql = "select kfglid,kfglxm from kfgl where kfgldl='" + adminname+"'";//adminname 是客户的登录名
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds);
int id = Convert.ToInt32(ds.Tables[0].Rows[0]["kfglid"].ToString()); string sql1 = "select fzbid,kfglid,fzbm from fzb where kfglid= " + id;
SqlDataAdapter cmd = new SqlDataAdapter(sql1, conn);
DataSet model = new DataSet();
cmd.Fill(model);
cbxGroup.DataSource = model;
cbxGroup.DisplayMember = "fzb.fzbm";
cbxGroup.ValueMember = "fzb.fzbid";
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}各位大侠帮我看看问题处在哪,运行总是提示无法绑定新的成员。谢谢 在线急等。。
cbxGroup.DisplayMember = "fzbm";
cbxGroup.ValueMember = "fzbid";
cbxGroup.DataSource = model.Tables[0];[align=center]*****************************************
本内容使用CSDN小秘书回复
每天回帖即可得10分可用分!
*****************************************[/align]
cbxGroup.ValueMember = "fzbid";
cbxGroup.DisplayMember = "fzb.fzbm";
cbxGroup.ValueMember = "fzb.fzbid"; 改成
cbxGroup.DataSource = model.Tables[0].DefaultView;是一个集合
cbxGroup.DisplayMember = "fzbm";
cbxGroup.ValueMember = "fzbid";
还可以试试自动填充
cbxGroup.ImeMode = ImeMode.Disable;
cbxGroup.DataSource =model.Tables[0].Rows[0][""].ToString();//是一个集合
cbxGroup.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cbxGroup.AutoCompleteSource = AutoCompleteSource.CustomSource;
cbxGroup.AutoCompleteCustomSource.AddRange(model);
cbxGroup.DataSource = model.Tables[0].DefaultView;是一个集合
cbxGroup.DisplayMember = "fzbm";
cbxGroup.ValueMember = "fzbid";
cbxGroup.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cbxGroup.AutoCompleteSource = AutoCompleteSource.CustomSource;
cbxGroup.AutoCompleteCustomSource.AddRange(model.Tables[0].AsEnumerable().Select<DataRow, string>(x => x.Field<string>("fzbm")).ToArray());