Exemplo n.º 1
0
        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new Opreate().conn();

            conn.Open();
            string strCmd;

            if (textBox1.Text.Equals("*"))
            {
                strCmd = "select score.sno,sname,course.cno,cname,ccategory,score.grade from student, score, course where student.sno =score.sno  and score.cno = course.cno";
            }
            else
            {
                strCmd = "select score.sno,sname,course.cno,cname,ccategory,score.grade from student,score,course where score." + comboBox1.Text + " = '" + textBox1.Text + " ' and student.sno = score.sno  and score.cno = course.cno";
            }

            //dtGrdViewSearch.Rows.Clear();

            SqlDataAdapter myDataAdapter;
            DataSet        myDataSet = new DataSet();

            myDataAdapter = new SqlDataAdapter(strCmd, conn);
            myDataAdapter.Fill(myDataSet, "student");
            dataGridView1.DataSource = myDataSet.Tables["student"];
            //textBox1.Text = myDataSet.Tables["student"].;

            conn.Close();
        }
        private void searchID_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new Opreate().conn();

            conn.Open();
            string strCmd;

            if (textBox1.Text.Equals("*"))
            {
                strCmd = "select * from student";
            }
            else
            {
                strCmd = "select * from student where " + comboBox1.Text + " = '" + textBox1.Text + " '";
            }

            //dtGrdViewSearch.Rows.Clear();

            SqlDataAdapter myDataAdapter;
            DataSet        myDataSet = new DataSet();

            myDataAdapter = new SqlDataAdapter(strCmd, conn);
            myDataAdapter.Fill(myDataSet, "student");
            //dtGrdViewSearch.DataSource = myDataSet.Tables["student"];
            dataGridView1.DataSource = myDataSet.Tables["student"];

            conn.Close();
        }
Exemplo n.º 3
0
        private void skinButton1_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new Opreate().conn();

            conn.Open();
            string strCmd;

            if (textBox1.Text.Equals("*"))
            {
                strCmd = "select * from Teacher_teaching";
            }
            else
            {
                strCmd = "select * from Teacher_teaching where " + skinComboBox1.Text + " = '" + textBox1.Text + " '";
            }

            //dtGrdViewSearch.Rows.Clear();

            SqlDataAdapter myDataAdapter;
            DataSet        myDataSet = new DataSet();

            myDataAdapter = new SqlDataAdapter(strCmd, conn);
            myDataAdapter.Fill(myDataSet, "Teacher_teaching");
            skinDataGridView1.DataSource = myDataSet.Tables["Teacher_teaching"];

            conn.Close();
        }
Exemplo n.º 4
0
        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new Opreate().conn();

            conn.Open();
            string strCmd;

            if (comboBox1.Text.Equals(""))
            {
                MessageBox.Show("请选择查询条件!");
            }
            else if (textBox1.Text.Equals(""))
            {
                MessageBox.Show("请输入查询值!");
            }
            else if (textBox1.Text.Equals("*"))
            {
                strCmd = "select * from course";
            }
            else
            {
                strCmd = "select * from course where " + comboBox1.Text + "= '" + textBox1.Text + "'";
                SqlDataAdapter myDataAdapter;
                DataSet        myDataSet = new DataSet();
                myDataAdapter = new SqlDataAdapter(strCmd, conn);
                myDataAdapter.Fill(myDataSet, "course");
                dataGridView1.DataSource = myDataSet.Tables["course"];
            }

            conn.Close();
        }
Exemplo n.º 5
0
        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new Opreate().conn();

            conn.Open();
            string strCmd = "";

            if (textBox1.Text.Equals(""))
            {
                // strCmd = "";
                MessageBox.Show("请输入学号!");
            }
            else
            {
                strCmd = "select * from Teacher_teaching where tno ='" + textBox1.Text + "'";
                SqlDataAdapter myDataAdapter;
                DataSet        myDataSet = new DataSet();
                myDataAdapter = new SqlDataAdapter(strCmd, conn);
                myDataAdapter.Fill(myDataSet, "Teacher_teaching");
                dataGridView1.DataSource = myDataSet.Tables["Teacher_teaching"];
            }


            conn.Close();
        }
Exemplo n.º 6
0
        private void skinButton7_Click(object sender, EventArgs e)
        {
            SqlConnection Conn = new Opreate().conn();//到sqlsever的连接

            Conn.Open();
            string        Sql  = "select top 1 * from teacher order by tno desc";
            SqlCommand    comm = new SqlCommand(Sql, Conn);                  //command对象
            SqlDataReader dr   = comm.ExecuteReader();                       //定义数据读取对象

            if (dr.Read())
            {
                skinTextBox1.Text  = (string)dr.GetValue(0);
                skinTextBox2.Text  = (string)dr.GetValue(1);
                skinComboBox1.Text = (string)dr.GetValue(2);
                skinComboBox2.Text = dr.GetValue(3).ToString();
            }
            Conn.Close();
        }
Exemplo n.º 7
0
        private void 排课_Load(object sender, EventArgs e)
        {
            SqlConnection conn = new Opreate().conn();

            conn.Open();
            string strCmd = "select * from Teacher_teaching";

            //dtGrdViewSearch.Rows.Clear();

            SqlDataAdapter myDataAdapter;
            DataSet        myDataSet = new DataSet();

            myDataAdapter = new SqlDataAdapter(strCmd, conn);
            myDataAdapter.Fill(myDataSet, "Teacher_teaching");
            skinDataGridView1.DataSource = myDataSet.Tables["Teacher_teaching"];

            skinDataGridView1.Columns[0].ReadOnly = true;
            skinDataGridView1.Columns[1].ReadOnly = true;
            skinDataGridView1.Columns[2].ReadOnly = true;

            conn.Close();
        }