Ejemplo n.º 1
0
        private void button2_Click(object sender, EventArgs e)
        {
            Form3 form3 = new 图书管理系统.Form3();

            form3.Show();
            this.Visible = false;
        }
Ejemplo n.º 2
0
        private void Form4_Load(object sender, EventArgs e)
        {
            connection = new SqlConnection(conn);
            connection.Open();

            sql = string.Format("select book_id1,book_id2,book_id3 from student_information where Student_ID = '{0}' ", Form1.Student_ID);
            SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);

            dt = new DataTable();
            dataadapter.Fill(dt);
            book_id1 = dt.Rows[0][0].ToString();
            book_id2 = dt.Rows[0][1].ToString();
            book_id3 = dt.Rows[0][2].ToString();

            sql2 = string.Format("select book_ID, book_name,book_writer from book_information where book_ID ='{0}' or book_ID ='{1}' or book_ID ='{2}'   ", book_id1, book_id2, book_id3);
            SqlDataAdapter dataadapter2 = new SqlDataAdapter(sql2, connection);
            DataSet        dataset      = new DataSet();

            dataadapter2.Fill(dataset);
            try
            {
                dataGridView1.Columns[0].DataPropertyName = "book_ID";
                dataGridView1.Columns[1].DataPropertyName = "book_name";
                dataGridView1.Columns[2].DataPropertyName = "book_writer";
                dataGridView1.DataSource = dataset.Tables[0];
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "显示失败", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }

            if (dt.Rows[0][0].ToString() == "" || dt.Rows[0][0] == null)
            {
                MessageBox.Show("请选择图书", "欢迎使用图书馆查询借阅系统", MessageBoxButtons.OK, MessageBoxIcon.Information);


                this.Close();
                Form3 form3 = new 图书管理系统.Form3();
                form3.Show();
            }
            else
            {
                book_id = (int)dataGridView1.Rows[0].Cells["Column1"].Value;
                connection.Close();
            }
        }