ASP.NET实现GridView删除功能

来源:互联网 发布:数据库百度百科 编辑:程序博客网 时间:2024/06/05 11:07
 public partial class _Default : System.Web.UI.Page    {        SqlDataAdapter sda = null;        private void Bind()        {            string strConnectionString = "server=localhost;database=register;uid=sa;pwd=tianshi520;";            SqlConnection conn = new SqlConnection(strConnectionString);            conn.Open();            string strSql = "select ID, Name as '留言者姓名', Content as '留言的信息', Time as '留言日期'" +                " from msgboard";            sda = new SqlDataAdapter(strSql, conn);            DataTable dt = new DataTable();            sda.Fill(dt);            conn.Close();            gvMsg.DataKeyNames = new System.String[] { "ID" };            gvMsg.DataSource = dt;            gvMsg.DataBind();        }        protected void Page_Load(object sender, EventArgs e)        {            Bind();        }        protected void sqlDS_Selecting(object sender, SqlDataSourceSelectingEventArgs e)        {        }        protected void gvMsg_RowDeleting(object sender, GridViewDeleteEventArgs e)        {            string strSql = "delete from msgboard where ID = " + gvMsg.DataKeys[e.RowIndex].Value.ToString();            string strConnectionString = "server=localhost;database=register;uid=sa;pwd=tianshi520;";            SqlConnection conn = new SqlConnection(strConnectionString);            conn.Open();            SqlCommand cmd = new SqlCommand(strSql, conn);            cmd.ExecuteNonQuery();            conn.Close();            Bind();        }        protected void gvMsg_RowCommand(object sender, GridViewCommandEventArgs e)        {                    }        protected void btnOk_Click(object sender, EventArgs e)        {            string strSql = string.Format("insert into msgboard(Name, Content, Time) values('{0}', '{1}', {2})",                txtName.Text.Trim(), txtContent.Text.Trim(), DateTime.Now.ToShortDateString());            //Response.Write(strSql);            string strConnectionString = "server=localhost;database=register;uid=sa;pwd=tianshi520;";            SqlConnection conn = new SqlConnection(strConnectionString);            conn.Open();            SqlCommand cmd = new SqlCommand(strSql, conn);            cmd.ExecuteNonQuery();            Bind();                   }        protected void gvMsg_RowEditing(object sender, GridViewEditEventArgs e)        {            gvMsg.EditIndex = e.NewEditIndex;        }

原创粉丝点击