private void button1_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog = cdsj;Integrated Security=true");//Initial catalog后面跟数据库的名字 conn.Open();//数据库链接打开 SqlCommand cmd = new SqlCommand("select * from site_info where site_code = '" + textBox1.Text.Trim() + "'", conn); SqlDataReader sdr = cmd.ExecuteReader(); Myclass.sitecode = this.textBox1.Text;//保存输入的场地代码 if (sdr.HasRows) { MessageBox.Show("查询成功!"); modify_table_menu f4 = new modify_table_menu(); f4.Show(); this.Hide(); } else { MessageBox.Show("查询失败!请重新输入"); } conn.Close();//关闭对象并释放所占内存空间 sdr.Close(); }
private void button2_Click(object sender, EventArgs e) { modify_table_menu mm = new modify_table_menu(); mm.Show(); this.Hide(); }