asp.net做crud

来源：互联网发布：excel多列重复数据筛选编辑：程序博客网时间：2024/06/05 01:54
//前面在cs下弄了个crud，现在在bs下也搞一个，先弄个最简单的拖控件的，数据校验没做，请见谅
修改成功后的该条信息：
using System;using System.Web.UI.WebControls;using System.Data;using System.Data.SqlClient;namespace WebApplication1{    public partial class Main : System.Web.UI.Page    {        protected void Page_Load(object sender, EventArgs e)        {            if (!IsPostBack)            {                GridView1.DataSource = BindList();                GridView1.DataBind();            }               }        public static string connStr = "server=.;database=test1;integrated security=true";        //绑定数据列表        public DataTable BindList()        {            string sql = "select * from login";            using (SqlConnection conn=new SqlConnection(connStr))            {                conn.Open();                using (SqlCommand cmd=conn.CreateCommand())                {                    cmd.CommandText = sql;                    SqlDataAdapter sda = new SqlDataAdapter(cmd);                    DataSet ds = new DataSet();                    sda.Fill(ds, "aa");                    return ds.Tables["aa"];                }                            }                }        //删除        protected void Button1_Click(object sender, EventArgs e)        {            Button btn = sender as Button;            string id = btn.CommandArgument;            SqlParameter pms = new SqlParameter("@a",id);            using (SqlConnection conn=new SqlConnection(connStr))            {                conn.Open();                using (SqlCommand cmd=conn.CreateCommand())                {                    cmd.CommandText = "delete from login where id=@a";                    cmd.Parameters.Add(pms);                    int row = cmd.ExecuteNonQuery();                    if (row>0)                    {                        Response.Write("<script>alert('删除成功！')</script>");                        BindList();                    }                    else                    {                        Response.Write("<script>alert('删除失败！')</script>");                    }                }            }        }        //修改：将信息遍历到下面的框中        protected void Button2_Click(object sender, EventArgs e)        {            Label1.Text = "修改信息";            string id = ((Button)sender as Button).CommandArgument;            HiddenField1.Value = id;            using (SqlConnection conn=new SqlConnection(connStr))            {                conn.Open();                using (SqlCommand cmd=conn.CreateCommand())                {                    cmd.CommandText = "select * from login where id=@a";                    SqlParameter pm = new SqlParameter("@a",id);                    cmd.Parameters.Add(pm);                    SqlDataReader sdr = cmd.ExecuteReader();                    if (sdr.Read())                    {                                            TextBox1.Text = sdr["name"].ToString();                    TextBox2.TextMode = TextBoxMode.SingleLine;                    TextBox2.Text = sdr["pwd"].ToString();                    TextBox3.Text = sdr["remark"].ToString();                    }                }            }        }        //新增        protected void Button3_Click(object sender, EventArgs e)        {            using (SqlConnection conn=new SqlConnection(connStr))            {                conn.Open();                using (SqlCommand cmd=conn.CreateCommand())                {                    cmd.CommandText = "insert into login values(@name,@pwd,@remark)";                    SqlParameter[] pms = new SqlParameter[3];                    pms[0] = new SqlParameter("@name", TextBox1.Text.Trim());                    pms[1] = new SqlParameter("@pwd", TextBox2.Text.Trim());                    pms[2] = new SqlParameter("@remark", TextBox3.Text.Trim());                    cmd.Parameters.AddRange(pms);                    int row = cmd.ExecuteNonQuery();                    if (row>0)                    {                        Response.Write("<script>alert('新增成功！')</script>");                        BindList();                    }                    else                    {                        Response.Write("<script>alert(''新增失败！)</script>");                    }                }            }        }        //提交修改        protected void Button4_Click(object sender, EventArgs e)        {            using (SqlConnection conn=new SqlConnection(connStr))            {                conn.Open();                using (SqlCommand cmd=conn.CreateCommand())                {                    cmd.CommandText = "update login set name=@a,pwd=@b,remark=@c where id=@id";                    SqlParameter[] pms = new SqlParameter[4];                    pms[0] = new SqlParameter("@a", TextBox1.Text.Trim());                    pms[1] = new SqlParameter("@b", TextBox2.Text.Trim());                    pms[2] = new SqlParameter("@c", TextBox3.Text.Trim());                    pms[3] = new SqlParameter("@id", HiddenField1.Value);                    cmd.Parameters.AddRange(pms);                    int row = cmd.ExecuteNonQuery();                    if (row>0)                    {                        Response.Write("<script>alert('修改成功！')</script>");                        BindList();                    }                    else                    {                        Response.Write("<script>alert('修改失败！')</script>");                    }                }            }        }    }}
1 0