Click here to Skip to main content
15,897,371 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
my problem is that to add gridview data into data base using jquery. i have code which add textbox value into gridview without using data base but still problem to add theses gridview value into data base.some one help me please

my jquery function and textbox and gridview


XML
<form id="form1" runat="server">
    <div>
        <table border="0" cellpadding="0" cellspacing="0">
            <tr>
                <td>
                    Id
                </td>
                <td>
                    <asp:TextBox ID="txtId" runat="server" />
                </td>
            </tr>
            <tr>
                <td>
                    Name
                </td>
                <td>
                    <asp:TextBox ID="txtName" runat="server" />
                </td>
            </tr>
            <tr>
                <td>
                    Country
                </td>
                <td>
                    <asp:TextBox ID="txtCountry" runat="server" />
                </td>
            </tr>
        </table>
        <br />
        <asp:Button ID="btnAddRow" Text="Add Row" runat="server" />
        <br />
        <br />
        <asp:GridView ID="GridView1" HeaderStyle-BackColor="#3AC0F2" HeaderStyle-ForeColor="White"
            runat="server" AutoGenerateColumns="false">
            <Columns>
                <asp:BoundField DataField="Id" HeaderText="Id" ItemStyle-Width="30" />
                <asp:BoundField DataField="Name" HeaderText="Name" ItemStyle-Width="150" />
                <asp:BoundField DataField="Country" HeaderText="Country" ItemStyle-Width="150" />
            </Columns>
        </asp:GridView>
    </div>
    </form>
jQuery


<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js" type="text/javascript"> </script>
<script type="text/javascript">
    $(function () {
        $("[id*=btnAddRow]").click(function () {
            var id = $("[id*=txtId]").val();
            var name = $("[id*=txtName]").val();
            var country = $("[id*=txtCountry]").val();
            if (id != "" && name != "" && country != "") {
                var row = $("[id*=GridView1] tr:last").clone();
                $("td:nth-child(1)", row).html(id);
                $("td:nth-child(2)", row).html(name);
                $("td:nth-child(3)", row).html(country);
                $("[id*=GridView1] tbody").append(row);
            }
            $("[id*=txtId]").val('');
            $("[id*=txtName]").val('');
            $("[id*=txtCountry]").val('');
            return false;
        });
    });
</script>

////// C# code///
C#
using System.Data;



protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        DataTable dt = new DataTable();
        dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Id", typeof(int)),
                        new DataColumn("Name", typeof(string)),
                        new DataColumn("Country",typeof(string)) });
        dt.Rows.Add(1, "John Hammond", "United States");
        dt.Rows.Add(2, "Mudassar Khan", "India");
        dt.Rows.Add(3, "Suzanne Mathews", "France");
        dt.Rows.Add(4, "Robert Schidner", "Russia");
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
}
Posted
Updated 24-Jan-15 7:08am
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900