{
public partial class employeeInfo : Form
{
DataTable dt;
CurrencyManager cmdOrders;
linkDatabase link = new linkDatabase();
int flag = 0;
public employeeInfo()
{
InitializeComponent();
}
private void employeeInfo_Load(object sender, EventArgs e)
{
toolStrip1.Enabled = false;
string strSql = "select * from 部门信息";
DataTable strDt = link.relateData(strSql);
comboBox1.DataSource = strDt;
comboBox1.DisplayMember = "部门名称";
comboBox1.ValueMember = "部门编号";
comboBox2.DataSource = strDt;
comboBox2.DisplayMember = "部门名称";
comboBox2.ValueMember = "部门编号";
}
private void button1_Click(object sender, EventArgs e)
{
toolStrip1.Enabled = true;
[color=#FFFF00] string strSql = "select a.职工号,a.姓名,a.部门编号,a.性别,a.入职时间,a.联系方式,a.提交状态,b.部门名称 from 职工信息 as a,部门信息 as b where a.部门编号=b.部门编号 and a.职工号 like '%" + textBox1.Text.Trim() + "%'and a.姓名 like'%" + textBox5.Text.Trim() + "%'and a.部门名称 like '%" + comboBox1.SelectedValue.ToString().Trim() + "%'";运行老是指向这一行代码说是未将对象引用设置到对象的实例
dt = link.relateData(strSql);
dataGridView1.DataSource = dt;
cmdOrders = (CurrencyManager)BindingContext[dt];
setBindingClear();
textBox2.DataBindings.Add("Text", dt, "部门编号");
textBox3.DataBindings.Add("Text", dt, "姓名");
textBox4.DataBindings.Add("Text", dt, "组建时间");
textBox6.DataBindings.Add("Text", dt, "联系方式");
comboBox3.DataBindings.Add("Text", dt, "性别");
comboBox2.DataBindings.Add("Text", dt, "部门名称");
}
求解决方法！
