private void ManagerSystem_Load(object sender, EventArgs e) { this.tabControl1.SelectedIndex = 1; string getUsers = "select * from users"; string getMachines = "select * from machines"; //显示管理员信息 DataSet dsUser = DataBaseSys.GetDataSetValue(getUsers, "Tables"); userDataView.DataSource = dsUser.Tables[0]; userDataView.Columns[0].HeaderText = "编号"; userDataView.Columns[1].HeaderText = "管理员"; userDataView.Columns[2].HeaderText = "密码"; userDataView.ReadOnly = true; dsUser.Dispose(); //显示机种信息 DataSet dsMac = DataBaseSys.GetDataSetValue(getMachines, "Tables"); dsMac.Tables[0].Columns[3].ReadOnly = false; adressDataView.DataSource = dsMac.Tables[0]; adressDataView.Columns[0].HeaderText = "编号"; adressDataView.Columns[1].HeaderText = "机种号"; adressDataView.Columns[2].HeaderText = "点数"; adressDataView.Columns[3].HeaderText = "坐标"; adressDataView.ReadOnly = true; dsMac.Dispose(); }
private void buttonSerach_Click(object sender, EventArgs e) { string machineGet = textMessage.Text; string sql = "select * from machines where machineId like'" + machineGet + "%'"; DataSet dsMoHu = DataBaseSys.GetDataSetValue(sql, "Tables"); adressDataView.DataSource = dsMoHu.Tables[0]; if (machineGet == "" || textMessage.ForeColor == SystemColors.InactiveCaption) { ManagerSystem_Load(null, null); } if (adressDataView.Rows.Count == 0) { MessageBox.Show("无类似机种!"); } }