ASP.NET Gridview Satır Verisi Silme

ASP.NET Gridview Satır Verisi Silme 




<asp:GridView CssClass="marginorta" ID="siparisGridView1" Width="100%" runat="server" BackColor="White" BorderColor="#336666" BorderStyle="Double" BorderWidth="3px" CellPadding="4"  GridLines="Horizontal" AutoGenerateColumns="False" OnRowDeleting="siparisGridView1_RowDeleting">
     <Columns>

             <asp:TemplateField HeaderText="RESİM" SortExpression="resimyolu">
                 <ItemTemplate>
                     <asp:Image Width="50" Height="60" ID="Image1" ImageUrl='<%# Bind("resimyolu") %>' runat="server" />
                 </ItemTemplate>
                 <HeaderStyle CssClass="tacenter" />
             </asp:TemplateField>

             
         <asp:TemplateField HeaderText="KOD" SortExpression="KOD">
                 <ItemTemplate>
                     <asp:Label ID="Label1" runat="server" Text='<%# Bind("KOD") %>'></asp:Label>
                 </ItemTemplate>
                 <HeaderStyle CssClass="tacenter" />
             </asp:TemplateField>

             <asp:BoundField DataField="AÇIKLAMA" HeaderText="AÇIKLAMA" SortExpression="AÇIKLAMA" >
             <HeaderStyle CssClass="tacenter" />
             </asp:BoundField>
             <asp:BoundField DataField="KDV_DAHİL_FİYAT" HeaderText="KDV DAHİL FİYAT" ReadOnly="True" SortExpression="KDV_DAHİL_FİYAT" >
             <HeaderStyle CssClass="tacenter" />
             </asp:BoundField>



             <asp:TemplateField HeaderText="MİKTAR" SortExpression="MİKTAR">
                 <ItemTemplate>
                     <asp:TextBox ID="TextBox1"  CssClass="form-control tacenter" Width="60" runat="server" Text='<%# Bind("sepetdurumu") %>'></asp:TextBox>
                 </ItemTemplate>
             
             </asp:TemplateField>
           
          

             <asp:TemplateField HeaderText="TOPLAM" SortExpression="TOPLAM">
                 <ItemTemplate>
                     <asp:Label ID="lblToplam" runat="server" Text=""></asp:Label>

                 </ItemTemplate>
                 <HeaderStyle CssClass="tacenter" />
                 <ItemStyle  CssClass="tacenter" />
                 
             </asp:TemplateField>

         <asp:TemplateField HeaderText=" " SortExpression=" ">
                 <ItemTemplate>
                     <asp:LinkButton ID="LinkButton1" runat="server" CommandName="Delete" ><img src="images/cart.png" /></asp:LinkButton>
                 </ItemTemplate>
                 <HeaderStyle CssClass="tacenter" />
                 <ItemStyle  CssClass="tacenter" />
                 
             </asp:TemplateField>
         
         </Columns>
         <FooterStyle BackColor="White" ForeColor="#333333" />
         <HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" />
         <PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" />
         <RowStyle BackColor="White" ForeColor="#333333" />
         <SelectedRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" />
         <SortedAscendingCellStyle BackColor="#F7F7F7" />
         <SortedAscendingHeaderStyle BackColor="#487575" />
         <SortedDescendingCellStyle BackColor="#E5E5E5" />
         <SortedDescendingHeaderStyle BackColor="#275353" />
          </asp:GridView>
 

Gridview YÜkleme
public void bindGrid()
    {
        string cs1 = ConfigurationManager.ConnectionStrings["musteriCS"].ConnectionString;
        SqlConnection conn = new SqlConnection(cs1);
        conn.Open();
        SqlCommand kmt = new SqlCommand();
        kmt.CommandText = "select distinct *from WEB_SEPET where TCNO_VERGİNO = '"+Session["tcno_vergino"].ToString()+"'";
        kmt.Connection = conn;

        SqlDataAdapter sda = new SqlDataAdapter(kmt);
        DataSet ds = new DataSet();
        sda.Fill(ds);
        siparisGridView1.DataSource = ds;
        siparisGridView1.DataBind();
        conn.Close();

        
    }


Silme İşlemi
protected void siparisGridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        Label lb = siparisGridView1.Rows[e.RowIndex].FindControl("Label1") as Label;
        string cs1 = ConfigurationManager.ConnectionStrings["musteriCS"].ConnectionString;
        SqlConnection sil = new SqlConnection(cs1);
        SqlCommand silcmd = new SqlCommand("Delete from sepet where kod_ref ='" + lb.Text.ToString() + "' ", sil);

        sil.Open();
        silcmd.ExecuteNonQuery();
        sil.Close();
        bindGrid();
        
        
    }