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
<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///
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();
}
}