insert update delete Table.aspx.cs

来源：互联网发布：java取两位小数编辑：程序博客网时间：2024/05/22 13:46

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;

namespace demo3
{
    public partial class insertDeleteUpdateTable : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

}

        protected void btnInsert_Click(object sender, EventArgs e)
        {
            //1连接字符串
            string constr = "data source=.;initial catalog=School;User ID=sa;Password=842674";
            //2创建连接对象
            using (SqlConnection con = new SqlConnection(constr))
            {
                //con.ConnectionString = constr;
                //打开连接
                con.Open();

                //拼接sql语句
                string sql = string.Format("insert into class3(cname,cdesc) values('{0}','{1}')", txtClassName.Text.Trim(), txtClassDesc.Text.Trim());
                //3创建命令对象
                using (SqlCommand cmd = new SqlCommand(sql, con))
                {
                    //cmd.Connection = con;
                    //cmd.CommandText = sql;
                    int r = cmd.ExecuteNonQuery();//执行insert，delete ，update正合适
                    //它的返回值就是执行命令后影响数据表中记录的条数。（正整数0---n）

                    this.Response.Write("插入"+r+"行");
                }
            }
        }

        protected void btnDelete_Click(object sender, EventArgs e)
        {
            //1连接字符串
            string constr = "data source=.;initial catalog=School;User ID=sa;Password=842674";
            //2创建连接对象
            using (SqlConnection con = new SqlConnection(constr))
            {
                //con.ConnectionString = constr;
                //打开连接
                con.Open();

                //拼接sql语句
                string sql = string.Format("delete from class3 where id={0}", txtId.Text.Trim());
                //3创建命令对象
                using (SqlCommand cmd = new SqlCommand(sql, con))
                {
                    //cmd.Connection = con;
                    //cmd.CommandText = sql;
                    int t = cmd.ExecuteNonQuery();//执行insert，delete ，update正合适
                    //它的返回值就是执行命令后影响数据表中记录的条数。（正整数0---n）

                    this.Response.Write("删除" + t + "行。");
                }
            }
        }

        protected void btnUpdate_Click(object sender, EventArgs e)
        {
            //1连接字符串
            string constr = "data source=.;initial catalog=School;User ID=sa;Password=842674";
            //2创建连接对象
            using (SqlConnection con = new SqlConnection(constr))
            {
                //con.ConnectionString = constr;
                //打开连接

                //拼接sql语句
                string sql = string.Format("update class3 set cname='{0}',cdesc='{1}' where id={2}", txtUpdateCname.Text.Trim(), txtUpdateCdesc.Text.Trim(), txtUpdateId.Text.Trim());
                //3创建命令对象
                using (SqlCommand cmd = new SqlCommand(sql, con))
                {
                    //cmd.Connection = con;
                    //cmd.CommandText = sql;
                    con.Open();//
                    int t = cmd.ExecuteNonQuery();//执行insert，delete ，update正合适
                    //它的返回值就是执行命令后影响数据表中记录的条数。（正整数0---n）

                    this.Response.Write("修改了" + t + "行。");
                }
            }
        }

}
}