ADO.net 的增删改应用

 

 protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            databind();
         }
    }

    private void databind()
    {
        SqlConnection con = DB.createConnect();
        con.Open();
        SqlCommand cmd = con.CreateCommand();
        cmd.CommandText = "select * from xin";
        SqlDataAdapter da = new SqlDataAdapter();
        da.SelectCommand = cmd;
        DataSet ds = new DataSet();
        da.Fill(ds, "table");
        GridView1.DataSource = ds.Tables[0].DefaultView;
        GridView1.DataBind();
        con.Close();
    }

 

  protected void Button6_Click(object sender, EventArgs e)
    {
       
      //添加数据
            string stuid = TextBox1.Text;
            string stuname = TextBox2.Text;
            string stuclass = TextBox3.Text;
            SqlConnection con = DB.createConnect();
            con.Open();
            SqlCommand cmd = con.CreateCommand();
            cmd.CommandText = "insert into xin values('" + stuid + "','" + stuname + "','" + stuclass + "')";
            Int32 sum = cmd.ExecuteNonQuery();
            if (sum > 0)
            {
                databind();
                TextBox1.Text = TextBox2.Text = TextBox3.Text = "";
            }
            else
            {
                Response.Write("<script>alert('添加失败！')</script>");
            }
            con.Close();
    }
    protected void Button4_Click(object sender, EventArgs e)
    {
        //查询数据
        SqlConnection con = DB.createConnect();
        con.Open();
        SqlCommand cmd = con.CreateCommand();
        cmd.CommandText = "select * from xin where s_id="+TextBox4.Text.ToString();
        SqlDataReader dr = cmd.ExecuteReader();
        dr.Read();//上一句的方法将查询的结果转化成数据流的形式，通过read方法读取一条数据。如果用while(dr.Read())就可以循环读取了。
        TextBox5.Text = dr["s_name"].ToString();
        TextBox6.Text = dr["s_class"].ToString();//通过dr["当前行的某一字段"]。也可以用dr.get（2）读取当前行某一列数据；
        con.Close();
        dr.Close();
    }
    protected void Button7_Click(object sender, EventArgs e)
    {
        //修改数据
        SqlConnection con = DB.createConnect();
        con.Open();
        SqlCommand cmd = con.CreateCommand();
        cmd.CommandText = "update xin set s_name='"+TextBox5.Text+"',s_class='"+TextBox6.Text+"'where s_id='"+TextBox4.Text+"'";
        Int32 sum = cmd.ExecuteNonQuery();
        if (sum > 0)
        {
            databind();
            TextBox1.Text = TextBox2.Text = TextBox3.Text = "";
        }
        else
        {
            Response.Write("<script>alert('修改失败！')</script>");
        }
        con.Close();
    }

    protected void Button5_Click(object sender, EventArgs e)
    {
        //删除数据
        SqlConnection con = DB.createConnect();
        con.Open();
        SqlCommand cmd = new SqlCommand("delete from xin where s_id='"+TextBox7.Text+"'",con);
        int sum = cmd.ExecuteNonQuery();
        if (sum > 0)
        {
            databind();
            TextBox7.Text = "";
        }
        else
        {
            Response.Write("<script>alert('无法删除！')</script>");
        }
    }