dynamically Add Linkbutton To Delete row in Gridview

Sign in to answer this question.

• 

  Jignesh Kumar6y agoPosted Jan 5, 2020, 9:15 AM

  Accepted answer

  Hello,

   

  You need to bind your gridview and need to assign datatable to gridview.datasource after dt.acceptchange();

   

  1. if (e.CommandName == "Delete")    
  2.        {    
  3.            GridViewRow gvr = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);    
  4.            int RemoveAt = gvr.RowIndex;    
  5.            DataTable dt = new DataTable();    
  6.            dt = (DataTable)ViewState["Records"];    
  7.            dt.Rows.RemoveAt(RemoveAt);    
  8.            dt.AcceptChanges();   
  9.            GVShowdata.DataSource = dt;
  10.            GVShowdata.DataBind();
  11.    
  12.        }    

   
• DK

  dhoni kholi6y agoPosted Jan 7, 2020, 4:23 AM

  1. DataTable dt = new DataTable();  
  2.   
  3.        string g5 = "0", g12 = "0", g18 = "0", g28 = "0", cgamt, sgamt, tot;  
  4.   
  5.        protected void Page_Load(object sender, EventArgs e)  
  6.        {  
  7.            txtBdate.Text = DateTime.Now.ToString("dd-MM-yyyy  hh:mm tt");  
  8.            txtFdis.Visible = false;  
  9.            lbldis.Visible = false;  
  10.            lbltax.Visible = false;  
  11.            txttax.Visible = false;  
  12.   
  13.            //---------- Bill Number Generation  
  14.            int a;  
  15.            string query = "select max(Billno) from Bill";  
  16.            con.Open();  
  17.            cmd = new SqlCommand(query, con);  
  18.            SqlDataReader dr;  
  19.            dr = cmd.ExecuteReader();  
  20.   
  21.            if (dr.Read())  
  22.            {  
  23.                string val = dr[0].ToString();  
  24.                if (val == "")  
  25.                {  
  26.                    Bno = 1;  
  27.                    HfBno.Value = Bno.ToString();  
  28.                }  
  29.                else  
  30.                {  
  31.                    a = Convert.ToInt32(dr[0].ToString());  
  32.                    a = a + 1;  
  33.                    Bno = a;  
  34.                    HfBno.Value = Bno.ToString();  
  35.                }  
  36.                con.Close();  
  37.            }  
  38.   
  39.            if (!Page.IsPostBack)  
  40.            {  
  41.                if (ViewState["Records"] == null)  
  42.                {  
  43.                    dt.Columns.Add("ID");  
  44.                    dt.Columns.Add("Qno");  
  45.                    dt.Columns.Add("Name");  
  46.                    dt.Columns.Add("Mobile");  
  47.                    dt.Columns.Add("Mail");  
  48.                    dt.Columns.Add("Gst");  
  49.                    dt.Columns.Add("City");  
  50.                    dt.Columns.Add("Address");  
  51.                    dt.Columns.Add("Btype");  
  52.                    dt.Columns.Add("Bdate");  
  53.                    dt.Columns.Add("Item Description");  
  54.                    dt.Columns.Add("Code");   //----H * W  
  55.                    dt.Columns.Add("HSN");  
  56.                    dt.Columns.Add("Quantity");  
  57.                    dt.Columns.Add("Price");  
  58.                    dt.Columns.Add("TAX %");  
  59.                    dt.Columns.Add("Tax Amount");  
  60.                    dt.Columns.Add("Discount");  
  61.                    dt.Columns.Add("Dis Amount");  
  62.                    dt.Columns.Add("GST 5");  
  63.                    dt.Columns.Add("GST 12");  
  64.                    dt.Columns.Add("GST 18");  
  65.                    dt.Columns.Add("GST 28");  
  66.                    dt.Columns.Add("CGST Amt");  
  67.                    dt.Columns.Add("SGST Amt");  
  68.                    dt.Columns.Add("Amount");  
  69.                    dt.Columns.Add("Paid");  
  70.                    dt.Columns.Add("Bal");  
  71.                    dt.Columns.Add("Notes");  
  72.                    dt.Columns.Add("Action");  
  73.                    ViewState["Records"] = dt;  
  74.                }  
  75.            }  
  76.        }  
  77.   
  78.        protected void ShowMob(object sender, EventArgs e)  
  79.        {  
  80.            //string title = "Greetings";  
  81.            //string body = "Welcome to ASPSnippets.com";  
  82.            ClientScript.RegisterStartupScript(this.GetType(), "Popup", "ShowMob();", true);  
  83.        }  
  84.   
  85.        protected void txtpcode_TextChanged(object sender, EventArgs e)  
  86.        {  
  87.            try  
  88.            {  
  89.                con.Open();  
  90.                string query = "SELECT * FROM offset WHERE subhead = '" + txtpcode.Text + "'";  
  91.                cmd = new SqlCommand(query, con);  
  92.                SqlDataReader sdr = cmd.ExecuteReader();  
  93.                if (sdr.Read())  
  94.                {  
  95.                    txtpname.Text = sdr[1].ToString();  
  96.                    txtamt.Text = sdr[7].ToString();  
  97.                    txthsn.Text = sdr[9].ToString();  
  98.                    txttax.Text = sdr[10].ToString();  
  99.                      
  100.                    sdr.Close();  
  101.                }  
  102.                con.Close();  
  103.            }  
  104.            catch  
  105.            {  
  106.                Response.Write(" alert('Error....') ");  
  107.            }  
  108.   
  109.            code = txtpcode.Text;  
  110.            type = code.Substring(0, 1);  
  111.            if (type == "G")  
  112.            {  
  113.                lbltax.Visible = true;  
  114.                txttax.Visible = true;  
  115.            }  
  116.            ClientScript.RegisterStartupScript(this.GetType(), "Popup", "ShowMob();", true);  
  117.        }  
  118.   
  119.        protected void btnFSave_Click(object sender, EventArgs e)  
  120.        {  
  121.            decimal tax, price, disamt, cal, tcal, qty;  
  122.            tax = Convert.ToDecimal(txttax.Text);  
  123.            price = Convert.ToDecimal(txtamt.Text);  
  124.            qty = Convert.ToDecimal(txtqty.Text); //-------Quantity  
  125.   
  126.            code = txtpcode.Text;  
  127.            type = code.Substring(0, 1);  
  128.            if (txtName.Text != "" && txtmobile.Text != "")  
  129.            {  
  130.                if (type == "G")  
  131.                {  
  132.                    //-------- Tax Amount Calculation   
  133.                    if (tax == 5)  
  134.                    {  
  135.                        cal = (tax / 100);  
  136.                        tcal = price * cal;  
  137.                        g5 = tcal.ToString();  
  138.                    }  
  139.                    else if (tax == 12)  
  140.                    {  
  141.                        cal = (tax / 100);  
  142.                        tcal = price * cal;  
  143.                        g12 = tcal.ToString();  
  144.                    }  
  145.                    else if (tax == 18)  
  146.                    {  
  147.                        cal = (tax / 100);  
  148.                        tcal = price * cal;  
  149.                        g18 = tcal.ToString();  
  150.                    }  
  151.                    else if (tax == 28)  
  152.                    {  
  153.                        cal = (tax / 100);  
  154.                        tcal = price * cal;  
  155.                        g28 = tcal.ToString();  
  156.                    }  
  157.   
  158.                    disamt = DiscAmt();        //-----Discount Amount  
  159.   
  160.                    //----CGST And SGST Calculation-----  
  161.                    cal = (tax / 100);  
  162.                    tcal = (price * cal) / 2;  
  163.                    cgamt = tcal.ToString();  
  164.                    sgamt = cgamt;  
  165.                    //---------Total Calculation--------  
  166.                    cal = (qty * price);  
  167.                    tcal = (cal + (Convert.ToDecimal(cgamt) + Convert.ToDecimal(sgamt))) - disamt;  
  168.                    tot = tcal.ToString();  
  169.   
  170.                    dt = (DataTable)ViewState["Records"];  
  171.                    dt.Rows.Add("1", HfBno.Value, txtName.Text, txtmobile.Text, "-", "0", txtcity.Text, "-", "0", txtBdate.Text, txtpname.Text, txtpcode.Text, txthsn.Text, qty, price, tax, Famtcal(), Convert.ToString(string.IsNullOrEmpty(txtFdis.Text) ? "0" : txtFdis.Text), disamt, g5, g12, g18, g28, cgamt, sgamt, tot, "0", tot, Convert.ToString(string.IsNullOrEmpty(txtFnote.Text) ? "-" : txtFnote.Text));  
  172.   
  173.                    GVShowdata.DataSource = dt;  
  174.                    GVShowdata.DataBind();  
  175.                    Flex_clear();  
  176.   
  177.                }  
  178.                else if (type == "N")  
  179.                {  
  180.                    disamt = DiscAmt();  
  181.                    tot = (Famtcal() - disamt).ToString();  
  182.   
  183.                    dt = (DataTable)ViewState["Records"];  
  184.                    dt.Rows.Add("1", HfBno.Value, txtName.Text, txtmobile.Text, "-", "0", txtcity.Text, "-", "0", txtBdate.Text, txtpname.Text, txtpcode.Text, txthsn.Text, qty, price, "0", Famtcal(), Convert.ToString(string.IsNullOrEmpty(txtFdis.Text) ? "0" : txtFdis.Text), disamt, "0", "0", "0", "0", "0", "0", tot, "0", tot, Convert.ToString(string.IsNullOrEmpty(txtFnote.Text) ? "-" : txtFnote.Text));  
  185.   
  186.                    GVShowdata.DataSource = dt;  
  187.                    GVShowdata.DataBind();  
  188.                    Flex_clear();  
  189.                }  
  190.                else  
  191.                {  
  192.                    Response.Write(" alert('Please Enter Valid Details.....') ");  
  193.                    Flex_clear();  
  194.                }  
  195.            }  
  196.            else   
  197.            {  
  198.                Response.Write(" alert('Please Enter Name & Mobile No.....') ");  
  199.            }  
  200.        }  
  201.        
  202.        private decimal Famtcal()  
  203.        {  
  204.            decimal qty, price, tcal;  
  205.            qty = Convert.ToDecimal(txtqty.Text);  
  206.            price = Convert.ToDecimal(txtamt.Text);  
  207.            tcal = price * qty;  
  208.            return tcal;  
  209.        }  
  210.        private decimal DiscAmt()  
  211.        {  
  212.            decimal dis, price, Disamt = 0;  
  213.            if (txtFdis.Text != "")  
  214.            {  
  215.                dis = Convert.ToDecimal(txtFdis.Text);  
  216.                price = Convert.ToDecimal(txtamt.Text);  
  217.                Disamt = (price * (dis / 100));  
  218.                return Disamt;  
  219.            }  
  220.            else  
  221.            {  
  222.                return Disamt;  
  223.            }  
  224.        }  
  225.        private void Flex_clear()  
  226.        {  
  227.            txtpname.Text = "";  
  228.            txthsn.Text = "";  
  229.            txtFnote.Text = "";  
  230.            txtpcode.Text = "";  
  231.            txtFdis.Text = "";  
  232.            txtamt.Text = "";  
  233.            txtqty.Text = "";  
  234.            txttax.Text = "";  
  235.        }  
  236.   
  237.        protected void GVShowdata_RowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)  
  238.        {  
  239.            e.Row.Cells[0].Visible = false;  
  240.            e.Row.Cells[1].Visible = false;  
  241.            e.Row.Cells[2].Visible = false;  
  242.            e.Row.Cells[3].Visible = false;  
  243.            e.Row.Cells[4].Visible = false;  
  244.            e.Row.Cells[5].Visible = false;  
  245.            e.Row.Cells[6].Visible = false;  
  246.            e.Row.Cells[7].Visible = false;  
  247.            e.Row.Cells[8].Visible = false;  
  248.            e.Row.Cells[9].Visible = false;  
  249.            e.Row.Cells[16].Visible = false;  
  250.            e.Row.Cells[17].Visible = false;  
  251.            e.Row.Cells[18].Visible = false;  
  252.            e.Row.Cells[19].Visible = false;  
  253.            e.Row.Cells[20].Visible = false;  
  254.            e.Row.Cells[21].Visible = false;  
  255.            e.Row.Cells[22].Visible = false;  
  256.            e.Row.Cells[26].Visible = false;  
  257.            e.Row.Cells[27].Visible = false;  
  258.            
  259.            e.Row.Cells[10].Attributes["width"] = "150px";  
  260.            e.Row.Cells[11].Attributes["width"] = "75px";  
  261.            e.Row.Cells[12].Attributes["width"] = "75px";  
  262.            e.Row.Cells[13].Attributes["width"] = "75px";  
  263.            e.Row.Cells[14].Attributes["width"] = "50px";  
  264.            e.Row.Cells[15].Attributes["width"] = "50px";  
  265.            e.Row.Cells[23].Attributes["width"] = "75px";  
  266.            e.Row.Cells[24].Attributes["width"] = "75px";  
  267.            e.Row.Cells[25].Attributes["width"] = "75px";  
  268.            e.Row.Cells[28].Attributes["width"] = "150px";  
  269.   
  270.              
  271.   
  272.            if (e.Row.DataItem != null)  
  273.            {  
  274.                LinkButton lb = new LinkButton();  
  275.                lb.CommandArgument = e.Row.Cells[29].Text;  
  276.                lb.CommandName = "Delete";  
  277.                lb.Text = "Delete";  
  278.                e.Row.Cells[29].Controls.Add((Control)lb);  
  279.            }  
  280.   
  281.        }  
  282.   
  283.        protected void GVShowdata_RowCommand(object sender, GridViewCommandEventArgs e)  
  284.        {  
  285.   
  286.            if (e.CommandName == "Delete")  
  287.            {  
  288.                GridViewRow gvr = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);  
  289.                int RemoveAt = gvr.RowIndex;  
  290.                DataTable dt = new DataTable();  
  291.                dt = (DataTable)ViewState["Records"];  
  292.                dt.Rows.RemoveAt(RemoveAt);  
  293.                dt.AcceptChanges();  
  294.                GVShowdata.DataSource = dt;  
  295.                GVShowdata.DataBind();  
  296.            }  
  297.        }  
  298.   
  299.        protected void GVShowdata_RowDeleting(object sender, GridViewDeleteEventArgs e)  
  300.        {  
  301.            int index = Convert.ToInt32(e.RowIndex);  
  302.            DataTable dt = ViewState["dt"] as DataTable;  
  303.            dt.Rows[index].Delete();  
  304.            ViewState["dt"] = dt;  
  305.            GVShowdata.DataBind();  
  306.        }  
  307.   
  308.        protected void btnBill_Click(object sender, EventArgs e)  
  309.        {  
  310.            try  
  311.            {  
  312.              foreach(GridViewRow gr in GVShowdata.Rows)  
  313.               {  
  314.                  SqlCommand cmd1 = new SqlCommand("Insert into Bill(Cusid,Billno,Name,Mobile,Mail,City,Address,Gst,Btype,Bdate,Pname,H_W,Hsn,Qty,Price,Tax,TaxAmt,Dis,Disamt,Gst_5,Gst_12,Gst_18,Gst_28,CGAmt,SGAmt,Total,Paid,Bal,Notes) Values(@Cusid,@Billno,@Name,@Mobile,@Mail,@City,@Address,@Gst,@Btype,@Bdate,@Pname,@H_W,@Hsn,@Qty,@Price,@Tax,@TaxAmt,@Dis,@Disamt,@Gst_5,@Gst_12,@Gst_18,@Gst_28,@CGAmt,@SGAmt,@Total,@Paid,@Bal,@Notes)", con);  
  315.                  con.Open();  
  316.                cmd1.Parameters.AddWithValue("Cusid",gr.Cells[0].Text);  
  317.                cmd1.Parameters.AddWithValue("Billno", gr.Cells[1].Text);  
  318.                cmd1.Parameters.AddWithValue("Name", gr.Cells[2].Text);  
  319.                cmd1.Parameters.AddWithValue("Mobile", gr.Cells[3].Text);  
  320.                cmd1.Parameters.AddWithValue("Mail", gr.Cells[4].Text);  
  321.                cmd1.Parameters.AddWithValue("Gst", gr.Cells[5].Text);  
  322.                cmd1.Parameters.AddWithValue("City", gr.Cells[6].Text);  
  323.                cmd1.Parameters.AddWithValue("Address", gr.Cells[7].Text);  
  324.                cmd1.Parameters.AddWithValue("Btype", gr.Cells[8].Text);  
  325.                cmd1.Parameters.AddWithValue("Bdate", DateTime.Parse(gr.Cells[9].Text));  
  326.                cmd1.Parameters.AddWithValue("Pname", gr.Cells[10].Text);  
  327.                cmd1.Parameters.AddWithValue("H_W", gr.Cells[11].Text);  
  328.                cmd1.Parameters.AddWithValue("Hsn", gr.Cells[12].Text);  
  329.                cmd1.Parameters.AddWithValue("Qty", gr.Cells[13].Text);  
  330.                cmd1.Parameters.AddWithValue("Price", gr.Cells[14].Text);  
  331.                cmd1.Parameters.AddWithValue("Tax", gr.Cells[15].Text);  
  332.                cmd1.Parameters.AddWithValue("TaxAmt", gr.Cells[16].Text);  
  333.                cmd1.Parameters.AddWithValue("Dis", gr.Cells[17].Text);  
  334.                cmd1.Parameters.AddWithValue("Disamt", gr.Cells[18].Text);  
  335.                cmd1.Parameters.AddWithValue("Gst_5", gr.Cells[19].Text);  
  336.                cmd1.Parameters.AddWithValue("Gst_12", gr.Cells[20].Text);  
  337.                cmd1.Parameters.AddWithValue("Gst_18", gr.Cells[21].Text);  
  338.                cmd1.Parameters.AddWithValue("Gst_28", gr.Cells[22].Text);  
  339.                cmd1.Parameters.AddWithValue("CGAmt", gr.Cells[23].Text);  
  340.                cmd1.Parameters.AddWithValue("SGAmt", gr.Cells[24].Text);  
  341.                cmd1.Parameters.AddWithValue("Total", gr.Cells[25].Text);  
  342.                cmd1.Parameters.AddWithValue("Paid", gr.Cells[26].Text);  
  343.                cmd1.Parameters.AddWithValue("Bal", gr.Cells[27].Text);  
  344.                cmd1.Parameters.AddWithValue("Notes", gr.Cells[28].Text);  
  345.   
  346.                 int x = cmd1.ExecuteNonQuery();  
  347.                 cmd1.Parameters.Clear();  
  348.                 con.Close();  
  349.               }  
  350.            }  
  351.            catch  
  352.            {  
  353.                Response.Write(" alert('invalid input....') ");  
  354.            }  
  355.   
  356.            Response.Redirect("frmGbill.aspx?Id=" + HfBno.Value);  
  357.        }  
  358.   
  359.        protected void btnExit_Click(object sender, EventArgs e)  
  360.        {  
  361.            Response.Redirect("frmBlank.aspx");  
  362.        }  

  This is My Entire coding Page
• 

  Jignesh Kumar6y agoPosted Jan 7, 2020, 4:11 AM

  please share your pageload event as well and method from where you are binding data in gridview
• DK

  dhoni kholi6y agoPosted Jan 7, 2020, 12:22 AM

  Please Help me to solve this issue That Cell only delete how delete row
• DK

  dhoni kholi6y agoPosted Jan 6, 2020, 8:50 AM

  @Jignesh Kumar  Sir i Change my Code But same problem happen That Row Cannot Delete
• 

  Ashutosh Gupta6y agoPosted Jan 5, 2020, 10:10 PM

  try with assigning GVShowData.EditIndex = -1 before marking GVShowdata.DataBind().

   

  may be you are not calling DataBing at right place, moving to right event may hlep some time.