aspnet的增删查改

1.

//--添加
        String userName = txtUserName.Text;
        String Pwd = txtPwd.Text;
         String strSql = "insert into b_User (UserName,Pwd) values('" + userName + "','" + Pwd + "')";
        
        SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["SQLConnString"].ToString());

         SqlCommand com = new SqlCommand();
         con.Open();
         com.Connection = con;
         com.CommandText = strSql;
         int exeResult = com.ExecuteNonQuery();

         Response.Write(exeResult);
         con.Close();

 

 

 

 

 

2. //删除  

 string strSql = "delete from b_user ";
        SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["SQLConnString"].ToString());

        con.Open();
        SqlCommand com = new SqlCommand(strSql,con);       

        int count = com.ExecuteNonQuery();

        if (count > 0)
        {
          Response.Write("删除成功！");
        }

        con.Close();

 

3. //查

 

 
        String strSql = "select * from b_user";
        SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["SQLConnString"].ToString());
        con.Open();
       // SqlCommand com = new SqlCommand(strSql, con);   //--使用适配器时，使用不到SqlCommand类

        SqlDataAdapter sda = new SqlDataAdapter(strSql,con);
        DataSet ds = new DataSet();
        sda.Fill(ds);
        this.GridView1.DataSource = ds;   //--赋予数据集后，
        this.GridView1.DataBind();        //--绑定

        Label1.Text = ds.Tables[0].Rows[0]["userName"].ToString();   //取0行的叫userName字段名的值

        con.Close();

 

 

4. 改

 

String userName = txtUserName.Text;
        String strSql = "update b_user set username='"+userName+"'";
        SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["SQLConnString"].ToString());

        SqlCommand com = new SqlCommand(strSql, con);
        con.Open();

        int count = com.ExecuteNonQuery();

        if (count > 0)
        {
            Response.Write("更新成功！");

        }

        con.Close();