User-807418713 posted
Hello
I used this code in my page in local it works perfect
Aspx.cs:
[WebMethod]
public static void Insert_Data(List<MyModel> myModels)
{
foreach (var item in myModels)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["constr527"].ConnectionString);
conn.Open();
SqlCommand cmd = new SqlCommand("Insert into Personal_Details (ItemName,Rate,Quantity) values(@ItemName,@Rate,@Quantity)", conn);
cmd.Parameters.AddWithValue("@ItemName", item.ItemName);
cmd.Parameters.AddWithValue("@Rate", item.Rate);
cmd.Parameters.AddWithValue("@Quantity", item.Quantity);
cmd.ExecuteNonQuery();
conn.Close();
}
}
public class MyModel
{
public string ItemName { get; set; }
public string Rate { get; set; }
public string Quantity { get; set; }
}
Aspx:
<script type="text/javascript">
var data = [];
$(document).ready(function () {
$('#txtQuantity').blur(function (e) {
var ItemName = $('#txtName').val();
var Rate = $('#txtRate').val();
var Quantity = $('#txtQuantity').val
var item = {
ItemName: $('#txtName').val(),
Rate: $('#txtRate').val(),
Quantity: $('#txtQuantity').val(),
};
data.push(item);
item.index = data.length -1;
$("#GridView1 tbody").append("<tr data-index='" + (data.length-1) + "'><td>" + $('#txtName option:selected').text() + "</td><td>" + $('#txtRate').val() + "</td><td>" + $('#txtQuantity').val() + "</td>" + "<td><input type='button' value='Delete' /></td>" + "</tr>")
$("#GridView1 tbody tr:last input").click(function () {
$(this).parent("td").parent("tr").remove();
var index = $(this).parent("td").parent("tr").data("index");
data = data.filter(function (ele) {
if (ele.index == index) {
return false;
}
return true;
})
})
$('#txtName option:first').prop("selected",true);
$('#txtRate').val("");
$('#txtQuantity').val("");
});
$("#Button1").click(function () {
$.ajax({
type: 'POST',
contentType: "application/json; charset=utf-8",
url: 'WebForm5555.aspx/Insert_Data',
data: JSON.stringify({myModels:data}),
success: function (e) {
alert("success")
}
});
})
});
</script>
<div>
<asp:DropDownList ID="txtName" runat="server" AppendDataBoundItems="True" DataSourceID="SqlDataSource2" DataTextField="Item_Name" DataValueField="Price">
<asp:ListItem>--select item--</asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:CaseTestConnectionString %>" SelectCommand="SELECT [Id], [Item_Name], [Price] FROM [Test3]"></asp:SqlDataSource>
<asp:TextBox ID="txtRate" runat="server" ClientIDMode="Static"> </asp:TextBox>
<asp:TextBox ID="txtQuantity" runat="server" ClientIDMode="Static"> </asp:TextBox>
<hr />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="ItemName" HeaderText="ItemName" SortExpression="ItemName" />
<asp:BoundField DataField="Rate" HeaderText="Rate" SortExpression="Rate" />
<asp:BoundField DataField="Quantity" HeaderText="Quantity" SortExpression="Quantity" />
<asp:CommandField ShowDeleteButton="True" HeaderText="Delete" ButtonType="Button" />
</Columns>
</asp:GridView>
<input type="button" id="Button1" value="Save" />
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:CaseTestConnectionString %>" SelectCommand="SELECT [ItemName], [Rate], [Quantity] FROM [Personal_Details]"></asp:SqlDataSource>
</div>
But after i hosted in severit shows alert perfect but data not inserting into database why..?
