如何从asp.net中的Datalist中删除项目或数据 [英] How to delete items or Data from Datalist in asp.net

问题描述

hii

首先感谢您的帮助...



我想知道如何从datalist中删除项目或数据在asp.net??

hii
First Of all thanks for your help...

I want to know how to delete items or data from datalist in asp.net??

推荐答案

ASPX

ASPX

<form id="form1"  runat="server">
    <div>
       <asp:datalist id="dlList" runat="server" repeatlayout="Table" repeatcolumns="1" xmlns:asp="#unknown">
            ondeletecommand="dlList_DeleteCommand" >
            <itemtemplate>
                <table cellpadding="1" cellspacing="0" style="width: 500px; height: 100px; background-color: #C2D69B">
                    <tr>
                        <td>
                            <%#Eval("empid")%>
                        </td>
                          <td>
                            <%#Eval("empname")%>
                        </td>
                          <td>
                            <%#Eval("deptid")%>
                        </td>
                        <td>
                           <asp:button id="btndelete" text="Delete" commandname="Delete" runat="server"></asp:button>
                        
                        </td>
                    </tr>
                </table>
            </itemtemplate>
        </asp:datalist>
    </div>
    </form>

< br $>


C＃

C#

protected void Page_Load(object sender, EventArgs e)
      {
          if (!this.IsPostBack)
          {
              this.BindDataList();
              this.Bind();
          }
      }

      private void BindDataList()
      {

          using (SqlConnection con = new SqlConnection(ur connection string))
          {
              using (SqlCommand cmd = new SqlCommand("SELECT  empid,empname,deptid FROM emp "))
              {
                  using (SqlDataAdapter sda = new SqlDataAdapter())
                  {
                      cmd.Connection = con;
                      sda.SelectCommand = cmd;

                      using (DataTable dt = new DataTable())
                      {
                          sda.Fill(dt);
                          ViewState["dt"] = dt;
                      }
                  }
              }
          }
      }

      protected void Bind()
      {
          dlList.DataSource = ViewState["dt"] as DataTable;
          dlList.DataBind();
      }

      protected void dlList_DeleteCommand(object source, DataListCommandEventArgs e)
      {
          int index = Convert.ToInt32(e.Item.ItemIndex);
          DataTable dt = ViewState["dt"] as DataTable;

          dt.Rows[index].Delete();
          dt.AcceptChanges();

          ViewState["dt"] = dt;

          dlList.EditItemIndex = -1;
          Bind();
      }

这篇关于如何从asp.net中的Datalist中删除项目或数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！