Ejemplo n.º 1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        Class2 ad = new Class2();
        DataSet abc = ad.GetAll();

        GridView1.DataSource = abc;
        GridView1.DataBind();
    }
Ejemplo n.º 2
0
    protected void Button2_Click(object sender, EventArgs e)
    {
        Class2 ad = new Class2();
        DataSet abc = ad.GetAll();

        GridView1.DataSource = abc;
        GridView1.DataBind();
    }
Ejemplo n.º 3
0
    protected void Button1_Click(object sender, EventArgs e)
    {
        string qq = "Data Source=gz-20150728tajv\\sqlexpress;Initial Catalog=Student1;Integrated Security=True ";
        SqlConnection Conn = new SqlConnection(qq);
        Conn.Open();
        string SQL = "UPDATE student_management SET " + TextBox2.Text + "='" + TextBox3.Text + "' where 学号='" + TextBox1.Text + "'";
        SqlCommand cmd = new SqlCommand(SQL, Conn);
        cmd.ExecuteNonQuery();
        Conn.Close();

        Class2 ad = new Class2();
        DataSet abc = ad.GetAll();

        GridView1.DataSource = abc;
        GridView1.DataBind();
    }
Ejemplo n.º 4
0
    protected void Button3_Click(object sender, EventArgs e)
    {
        string qq = "Data Source=gz-20150728tajv\\sqlexpress;Initial Catalog=Student1;Integrated Security=True ";
        SqlConnection Conn = new SqlConnection(qq);
        Conn.Open();
        string SQL1 = "UPDATE student_management SET 寝室号='" + TextBox4.Text + "',是否入住='是' where 学号='" + TextBox3.Text + "'";
        string SQL2 = "UPDATE dormitory_management SET 是否住满='是' where 寝室号='"+TextBox4.Text+"'";
        string SQL3 = "UPDATE dormitory_management SET 是否住满='否' where 寝室号='" + TextBox4.Text + "'";
        string str = "select count(*) from student_management where 寝室号='" + TextBox4.Text + "'";

        SqlCommand cmd1 = new SqlCommand(SQL1, Conn);

        cmd1.ExecuteNonQuery();

        SqlCommand count = new SqlCommand(str, Conn);
        string num1 = (count.ExecuteScalar()).ToString();
        int number = Convert.ToInt16(num1);

        if (number == 4)
        {
            SqlCommand cmd2 = new SqlCommand(SQL2, Conn);
            cmd2.ExecuteNonQuery();
        }
        else
        {
            SqlCommand cmd2 = new SqlCommand(SQL3, Conn);
            cmd2.ExecuteNonQuery();
        }

        Conn.Close();

        Class2 ad1 = new Class2();
        DataSet abc1 = ad1.GetAll();

        GridView1.DataSource = abc1;
        GridView1.DataBind();

        Class1 ad2 = new Class1();
        DataSet abc2 = ad2.GetAll();

        GridView2.DataSource = abc2;
        GridView2.DataBind();

        TextBox3.Text = "";
        TextBox4.Text = "";
    }