ASP.NET增删改

1、条件查询

public void dbsearch(String x)
        {
            
            SqlConnection dsConn = new SqlConnection
               ("server=192.168.31.245;uid=sa;pwd=xx;database=news");
            dsConn.Open();

            //定义DataSet对象
            DataSet DS = new DataSet();

            //定义SqlDataAdapter对象
            SqlDataAdapter MyCommand = new SqlDataAdapter("select * from RTO_Commen where Did='"+ x +"'", dsConn);

            //填充数据
            MyCommand.Fill(DS, "RTO_Commen");

            //name1.Text = (string)DS.Tables[0].Rows[1]["D_Name"];

            // 将Repeater控件进行数据绑定
            MyRepeater.DataSource = DS.Tables["RTO_Commen"].DefaultView;
            MyRepeater.DataBind();

            dsConn.Close();
          
        }

2、删除

public void dbDell(string id)
        {
            SqlConnection con = new SqlConnection();
            con.ConnectionString = "server=192.168.31.245;database=news;uid=sa;pwd=xxx";
            con.Open();

            SqlCommand com = new SqlCommand();
            com.Connection = con;
            com.CommandType = CommandType.Text;
            com.CommandText = "delete from RTO_Commen where Did='" + id + "'";
            SqlDataReader dr = com.ExecuteReader();//执行SQL语句

            name1.Text = "Delect success";
            //也可以做绑定
            //MyRepeater.DataSource = dr;
            //MyRepeater.DataBind();

            dr.Close();//关闭执行
            con.Close();//关闭数据库
        }

3、修改

public void dbchang(string id,string val)
        {
            SqlConnection con = new SqlConnection();
            con.ConnectionString = "server=192.168.31.245;database=news;uid=sa;pwd=xxx";
            con.Open();

            SqlCommand com = new SqlCommand();
            com.Connection = con;
            com.CommandType = CommandType.Text;
            com.CommandText = "update RTO_Commen set D_Name='"+ val +"'where Did='"+ id +"'";
            SqlDataReader dr = com.ExecuteReader();//执行SQL语句

            name1.Text = "update success";
            //也可以做绑定
            //MyRepeater.DataSource = dr;
            //MyRepeater.DataBind();

            dr.Close();//关闭执行
            con.Close();//关闭数据库
        }

前端：

   //注意id  MyRepeater 和后台的对应

        <ASP:Repeater id="MyRepeater" runat="server">     
 <ItemTemplate>  
    <p>  
        Did：<%# DataBinder.Eval(Container.DataItem, "USERID") %>  
    </p>      
    </ItemTemplate>  
    </ASP:Repeater> 

其他：

sql = "insert into users(name,age) values('"+ tbName.Text.ToString().Trim() +"','" + tbAge.Text.ToString().Trim() +"')";  

sql = "insert into users(name,age) values('"+ tbName.Text.ToString().Trim() +"','" + tbAge.Text.ToString().Trim() +"')"; 

 
sql = "delete from users where name='" + tbName.Text.ToString().Trim() + "' and age='" + tbAge.Text.ToString().Trim()+"'"; 

sql = "update  users set age='"+ tbAge.Text.ToString().Trim()+"' where name='" + tbName.Text.ToString().Trim() + "'";  

sql = "select * from users where name='" + tbName.Text.ToString().Trim() + "'";