Hi rakeshkuma,
Check this example. Now please take its reference and correct your code.
HTML
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.2/css/bootstrap.min.css" />
<script type="text/javascript">
function addRow(tableID) {
var table = document.getElementById(tableID);
var rowCount = table.rows.length;
var row = table.insertRow(rowCount);
var colCount = table.rows[0].cells.length;
for (var i = 0; i < colCount; i++) {
var newcell = row.insertCell(i);
newcell.innerHTML = table.rows[0].cells[i].innerHTML;
switch (newcell.childNodes[0].type) {
case "text":
newcell.childNodes[0].value = "";
break;
case "checkbox":
newcell.childNodes[0].checked = false;
break;
case "select-one":
newcell.childNodes[0].selectedIndex = 0;
break;
}
}
}
function deleteRow(tableID) {
try {
var table = document.getElementById(tableID);
var rowCount = table.rows.length;
for (var i = 0; i < rowCount; i++) {
var row = table.rows[i];
var chkbox = row.cells[0].childNodes[1];
if (chkbox != null && chkbox.checked == true) {
if (rowCount <= 1) {
alert("Cannot delete all the rows.");
break;
}
table.deleteRow(i);
rowCount--;
i--;
}
}
} catch (e) {
alert(e);
}
}
</script>
<form id="form1" runat="server" enctype="multipart/form-data" method="post">
<section class="container-fluid block location-block">
<div class="container">
<div class="row">
<div class="card card-body" style="margin-top: -20px">
<div class="row">
<div class="col-sm-3">
<table id="dataTable1" class="table-bordered table-hover table-striped table">
<tr>
<td>
<input type="checkbox" name="chk" />
</td>
<td>
<asp:TextBox ID="item" runat="server"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="dsca" runat="server"></asp:TextBox>
</td>
</tr>
</table>
</div>
</div>
<div class="row">
<div class="col-sm-3">
<input type="button" class="btn btn-primary btn-xs" value="ADD" onclick="addRow('dataTable1')" />
<input type="button" class="btn btn-primary btn-xs" value="DELETE" onclick="deleteRow('dataTable1')" />
<asp:Button ID="btnsubmit" runat="server" Text="SUBMIT" CssClass="btn btn-primary btn-xs" OnClick="btnsubmit_Click" />
</div>
</div>
</div>
</div>
</div>
</section>
</form>
</asp:Content>
Namespaces
C#
using System.Configuration;
using System.Data.SqlClient;
VB.Net
Imports System.Configuration
Imports System.Data.SqlClient
Code
C#
protected void btnsubmit_Click(object sender, EventArgs e)
{
string[] item = Request.Form.GetValues(this.item.UniqueID);
string[] dsca = Request.Form.GetValues(this.dsca.UniqueID);
int len = 0;
if (item.Length > len)
{
len = item.Length;
}
if (dsca.Length > len)
{
len = dsca.Length;
}
for (int i = 0; i <= len - 1; i++)
{
string constr = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand("INSERT INTO rak_tblitem(item,dsca)values(@item,@dsca)", con);
cmd.Parameters.AddWithValue("@item", item[i]);
cmd.Parameters.AddWithValue("@dsca", dsca[i]);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
VB.Net
Protected Sub btnsubmit_Click(ByVal sender As Object, ByVal e As EventArgs)
Dim item As String() = Request.Form.GetValues(Me.item.UniqueID)
Dim dsca As String() = Request.Form.GetValues(Me.dsca.UniqueID)
Dim len As Integer = 0
If item.Length > len Then
len = item.Length
End If
If dsca.Length > len Then
len = dsca.Length
End If
For i As Integer = 0 To len - 1
Dim constr As String = ConfigurationManager.ConnectionStrings("conString").ConnectionString
Dim con As SqlConnection = New SqlConnection(constr)
Dim cmd As SqlCommand = New SqlCommand("INSERT INTO rak_tblitem(item,dsca)values(@item,@dsca)", con)
cmd.Parameters.AddWithValue("@item", item(i))
cmd.Parameters.AddWithValue("@dsca", dsca(i))
con.Open()
cmd.ExecuteNonQuery()
con.Close()
Next
End Sub