I am working with edmx and adding gridview data into data base it will work fine when I add its data type varchar then value insert successfully but when I change its data type decimal or int then value insert into data base but value should be empty means every time 0 value will be insert.
follwoing my code.
Js ………………………
function AddGridviewData() {
var AddRow = new Array();
$('[id*=gridview]').find('tr:has(td)').each(function () {
var NewRow = {};
NewRow.ID = $(this).find("td:eq(0)").html();
NewRow.Name = $(this).find("td:eq(1)").html();
NewRow.height = $(this).find("td:eq(2)").html();
AddRow.push(NewRow);
});
$.ajax({
type: 'POST',
url: "Default.aspx/AddDatabase",
data: '{AddRow: ' + JSON.stringify(AddRow) + '}',
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (response) {
alert("Data scessfully saved ");
window.location.reload();
return false;
}
});
return false;
};
///webmethod ///
public class Data
{
public int ID { get; set; }
public string Name { get; set; }
public decimal height { get; set; }
}
[System.Web.Services.WebMethod]
public static void AddDatabase (List<Data> AddRow)
{
using (var db = new MyEntities())
foreach (Data NewRow in AddRow)
{
db.StoredProcedure1(
NewRow.ID,
NewRow.Name,
NewRow.height
);
}
}
When I add its type varchar then it will work fine when it place decimal or int cann’t insert value only 0 insert every time please help me to solve it.