private void 管理员账户管理_Load(object sender, EventArgs e) { C_conn c1 = new C_conn(); my_conn = c1.get_conn(); my_adapter = new SqlDataAdapter("select * from users", my_conn); SqlCommandBuilder my_cb = new SqlCommandBuilder(my_adapter); my_ds = new DataSet(); my_adapter.Fill(my_ds, "users"); my_conn.Close(); my_bind = new BindingSource(); my_bind.DataSource = my_ds; my_bind.DataMember = "users"; dataGridView1.DataSource = my_bind; dataGridView1.AllowUserToAddRows = false; dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.Columns["userid"].HeaderText = "用户名"; dataGridView1.Columns["userid"].Width = 120; dataGridView1.Columns["password"].HeaderText = "密码"; dataGridView1.Columns["password"].Width = 120; dataGridView1.Columns["jobnum"].HeaderText = "职工号"; dataGridView1.Columns["jobnum"].Width = 120; textBox1.DataBindings.Clear(); textBox2.DataBindings.Clear(); textBox3.DataBindings.Clear(); textBox1.DataBindings.Add("text", my_bind, "userid"); textBox2.DataBindings.Add("text", my_bind, "password"); textBox3.DataBindings.Add("text", my_bind, "jobnum"); }
private void 线路录入_Load(object sender, EventArgs e) { C_conn c1 = new C_conn(); my_conn = c1.get_conn(); my_ds = new DataSet(); my_adapter = new SqlDataAdapter("select * from line", my_conn); my_adapter.Fill(my_ds, "type"); }
private void 乘客录入_Load(object sender, EventArgs e) { C_conn c1 = new C_conn(); my_conn = c1.get_conn(); my_ds = new DataSet(); my_adapter = new SqlDataAdapter("select * from bus", my_conn); my_adapter.Fill(my_ds, "type"); comboBox1.DataSource = my_ds.Tables["type"]; comboBox1.DisplayMember = my_ds.Tables["type"].Columns["num"].ColumnName.ToString(); comboBox1.ValueMember = my_ds.Tables["type"].Columns["num"].ColumnName.ToString(); my_conn.Close(); }
private void Form1_Load(object sender, EventArgs e) { C_conn c1 = new C_conn(); my_conn = c1.get_conn(); if (textBox1.Text.Trim() == "") { this.pictureBox2.Image = null; button3.Enabled = false; button4.Enabled = false; button5.Enabled = false; button6.Enabled = false; button7.Enabled = false; button8.Enabled = false; button9.Enabled = false; } }
private void 车辆管理系统_驾驶员查询窗口__Load(object sender, EventArgs e) { C_conn c1 = new C_conn(); my_conn = c1.get_conn(); textBox4.Enabled = false; textBox5.Enabled = false; if (textBox1.Text.Trim() == "") { button3.Enabled = false; button4.Enabled = false; button5.Enabled = false; } my_ds = new DataSet(); my_adapter = new SqlDataAdapter("select * from bus", my_conn); my_adapter.Fill(my_ds, "type"); comboBox1.DataSource = my_ds.Tables["type"]; comboBox1.DisplayMember = my_ds.Tables["type"].Columns["drivername"].ColumnName.ToString(); comboBox1.ValueMember = my_ds.Tables["type"].Columns["drivername"].ColumnName.ToString(); my_conn.Close(); }
private void 线路管理系统_发到站查询窗口__Load(object sender, EventArgs e) { C_conn c1 = new C_conn(); my_conn = c1.get_conn(); textBox1.Enabled = false; textBox2.Enabled = false; textBox3.Enabled = false; textBox4.Enabled = false; textBox5.Enabled = false; textBox6.Enabled = false; textBox7.Enabled = false; textBox8.Enabled = false; my_ds = new DataSet(); my_adapter = new SqlDataAdapter("select * from line", my_conn); my_adapter.Fill(my_ds, "type"); comboBox1.DataSource = my_ds.Tables["type"]; comboBox1.DisplayMember = my_ds.Tables["type"].Columns["busend"].ColumnName.ToString(); comboBox1.ValueMember = my_ds.Tables["type"].Columns["busend"].ColumnName.ToString(); my_conn.Close(); }
private void 旅客管理系统_车辆查询窗口__Load(object sender, EventArgs e) { C_conn c1 = new C_conn(); my_conn = c1.get_conn(); if (textBox1.Text.Trim() == "") { this.pictureBox2.Image = null; button3.Enabled = false; button4.Enabled = false; button5.Enabled = false; button6.Enabled = false; button7.Enabled = false; button8.Enabled = false; button9.Enabled = false; } my_adapter = new SqlDataAdapter("select id,name,num from peo", my_conn); my_ds = new DataSet(); my_adapter.Fill(my_ds, "type"); comboBox1.DataSource = my_ds.Tables["type"]; comboBox1.DisplayMember = my_ds.Tables["type"].Columns["num"].ColumnName.ToString(); comboBox1.ValueMember = my_ds.Tables["type"].Columns["num"].ColumnName.ToString(); my_conn.Close(); }
private void 退票系统_Load(object sender, EventArgs e) { C_conn c1 = new C_conn(); my_conn = c1.get_conn(); }