课堂作业，急急！在ASP.net中使用GridView1控件进行删除，修改sql中的数据

Question

课堂作业，急急！在ASP.net中使用GridView1控件进行删除，修改sql中的数据

Answer 1

using System.Data.SqlClient;namespace 新闻发布后台管理系统.manager.news
{
    public partial class New_list : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=MySchool;Integrated Security=True");
            SqlCommand cmd = new SqlCommand("select NewsId,Title,PublishDate from News", conn);
            conn.Open();
            SqlDataReader sdr = cmd.ExecuteReader();                                   this.GridView1.DataSource = sdr;
            this.GridView1.DataBind();            sdr.Close();
            conn.Close();        }        protected void LinkButton1_Click(object sender, EventArgs e)
        {
            ClientScript.RegisterStartupScript(this.GetType(), "queren", "<script>alert('确定删除吗？')</script>");
        }        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            
         
        }
    }
}

Answer 2

你可以在前台的ItemTemplate添加
<asp:Button ID="btnDelete" runat="server" Text="删除" CommandName="DeleteByID" CommandArgument='<%# Eval("Id") %>' />然后在后台gridView1的事件
 protected void gridView1_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if(e.CommandName=="DeleteByID"){
                 string newID=e.CommandArgument.ToString();
                 bool deleteResult=new NewsManager().DeleteNewsByID(newID); 
       }
        }

Answer 3

要提示信息的话：<asp:Button ID="btnDelete" runat="server" Text="删除" CommandName="DeleteByID" CommandArgument='<%# Eval("Id") %>' OnClientClick="if(!confirm('确定要删除吗？'))  return false;"/>