how to add a row at a runtime by clicking a linkbutton in asp.net using c#

Hi Selvi,

what is your requirement here?

do you have several textbox outside the grid and after filling all the value click on control should add into grid?

or

you have a link called "Add row" outside the grid and click on that should enable the textbox in the every column of grid?

please clarify your requirement.

Hi Selvi,


Try this...


<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication13._Default" %>





   


   

   

   
               
                   
                   
               
               
                   
                   
               
               
                   
                   
               
               
                   
                   
               
               
                   
                   
               
           
              
        

           
            Add To Table
        

   

           
                
           
   

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace WebApplication13
{
    public partial class _Default : System.Web.UI.Page
    {
        string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        SqlCommand com;
        static DataTable dt;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                dt = new DataTable("student");
                dt.Columns.Add("sid", typeof(string));
                dt.Columns.Add("sname", typeof(string));
                dt.Columns.Add("smarks", typeof(string));
                dt.Columns.Add("saddress", typeof(string));
            }

        }
        public void BindData()
        {
            GridView1.DataSource = dt;
            GridView1.DataBind();
        }

         protected void lnkBtnAddToTable_Click(object sender, EventArgs e)
        {
            dt.Rows.Add(txtid.Text, txtname.Text, txtmarks.Text, txtaddress.Text);
            BindData();
        }

        protected void BtnSendToDatabase_Click(object sender, EventArgs e)
        {
            foreach (GridViewRow g1 in GridView1.Rows)
            {
                SqlConnection con = new SqlConnection(connStr);
                com = new SqlCommand("insert into student(sid,sname,smarks,saddress) values ('" + g1.Cells[0].Text + "','" + g1.Cells[1].Text + "','" + g1.Cells[2].Text + "','" + g1.Cells[3].Text + "')", con);
                con.Open();
                com.ExecuteNonQuery();
                con.Close();
            }
            Response.Write("Records inserted successfully");
        }

       
    }
}






Thanks

There is more than one way of doing this. You could add a footer row to the gridview and have it visible when you want to a a new row. 

take a look at the below link for step-by-step tutorial on how to add a new row at runtime to the gridview

http://technico.qnownow.com/2012/03/29/how-to-insert-update-delete-rows-in-asp-net-gridview-control/