how to insert data using text boxes into gridview

Question

how to insert data using text boxes into gridview with out saving.after i am enter some data into gridview after that i can create save button when i am click that button data will save into database this is my task plz help give me some reference how to do

Mageshwaran R · Answer

Hi Shiva, Can you check with the below link: https://stackoverflow.com/questions/12875643/how-to-insert-data-from-textboxes-into-gridview-on-button-click-in-asp-net

Rajanikant Hawaldar · Answer

Hi Shive, send data from textbox to gridview protected void Button1_Click( object sender, EventArgs e) { DataTable dt; //check if the datatable already exists in the viewstate, if not create a new datatable if (ViewState[ "myTable" ] == null ) { dt = new DataTable(); dt.Columns.AddRange( new DataColumn[2] { new DataColumn( "Name" , typeof ( string )), new DataColumn( "Age" , typeof ( decimal )) }); } else { //correct viewstate exists, cast back to a datatable dt = ViewState[ "myTable" ] as DataTable; } //add the new values dt.Rows.Add(TextBox1.Text, Convert.ToDecimal(TextBox2.Text)); //bind the datatable to the gridview GridView1.DataSource = dt; GridView1.DataBind(); //save the datatable into the viewstate ViewState[ "myTable" ] = dt; //clear the textboxes TextBox1.Text = "" ; TextBox2.Text = "" ; } Save to database protected void btn_insert_Click( object sender, EventArgs e) { foreach (GridViewRow g1 in GridView1.Rows) { SqlConnection con = new SqlConnection(connStr); //pass your connection string here com = new SqlCommand( "insert into student(sname,saddress) values ('" + g1.Cells[0].Text + "','" + g1.Cells[1].Text + "')" , con); con.Open(); com.ExecuteNonQuery(); con.Close(); } Label1.Text = "Records inserted successfully" ; }

Jignesh Kumar · Answer

Hi Shiva, You can create method to bind data in gridview. After insert query you can call bind method in your insert button click event. Please find link to do in better way, https://www.aspsnippets.com/Articles/Save-Insert-GridView-Rows-Data-to-Database-in-ASPNet-using-C-and-VBNet.aspx

Gajendra Jangid · Answer

hello Shiva, use following code: design: %@ Page Language = "C#" AutoEventWireup = "true" CodeFile = "Default.aspx.cs" Inherits = "_Default" % > > html xmlns = "http://www.w3.org/1999/xhtml" > head runat = "server" > title > title > head > body > form id = "form1" runat = "server" > div > Name: asp:TextBox ID = "TextBox2" runat = "server" > asp:TextBox > br /> Age: asp:TextBox ID = "TextBox1" runat = "server" > asp:TextBox > br /> asp:Button ID = "Button1" runat = "server" OnClick = "Button1_Click" Text = "Button" /> br /> div > asp:GridView ID = "GridView1" runat = "server" AutoGenerateColumns = "False" Width = "100%" Visible = "true" > Columns > asp:BoundField DataField = "Sno" HeaderText = "Sno" ItemStyle-Width = "100" /> asp:BoundField DataField = "Name" HeaderText = "Name" ItemStyle-Width = "100" /> asp:BoundField DataField = "Age" HeaderText = "Age" ItemStyle-Width = "100" /> Columns > asp:GridView > form > body > html > Cs: using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class _Default : System.Web.UI.Page { DataTable dt; protected void Page_Load( object sender, EventArgs e) { if (!IsPostBack) { if (Session[ "Datatable" ] != null ) { createtable(); } } } public void createtable() { dt = new DataTable(); dt.Columns.Add( "Sno" , typeof ( string )); dt.Columns.Add( "Name" , typeof ( string )); dt.Columns.Add( "Age" , typeof ( string )); Session[ "Datatable" ] = dt; } public void InsertData() { dt = (DataTable)Session[ "Datatable" ]; if (dt == null ) { createtable(); } dt.Rows.Add(dt.Rows.Count + 1, TextBox1.Text, TextBox2.Text); Session[ "Datatable" ] = dt; GridView1.DataSource = dt; GridView1.DataBind(); } protected void Button1_Click( object sender, EventArgs e) { InsertData(); } }

how to insert data using text boxes into gridview

Answers (4)