how to insert data using text boxes into gridview

Kumar

7y1.4k.NET

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
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 Hawaldar7y ago
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 Kumar7y ago
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 Jangid7y ago
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();
    }
}