Cant able to load the table in ajax success function mvc

Sneha K

Hi all i cant able to load the table values in ajax success function. I tried to load the values of the table in ajax success function.But it not loading the values properly

My Controller

public JsonResult GetData(int ID=3, int PID=1001)

{

try

{

List

grplist= new List

();

var Par = new Parameters();

par.Add("ID",ID);

par.Add("PID",PID);

var grptable = StroredProc..GetDataTable(spGetDetails",par);

for(int i=0;i

{

DetailModel grp= new DetailModel();

grp.name = grptable.Rows[i]["name"];

grp.Relation= grptable.Rows[i]["Relation"];

grplist.Add(grp);

}

return Json( grplist, JsonRequestBehavior.AllowGet);

}

catch (Exception ex)

{

Common.AddModel_Log4Net();

throw new Exception(ex.ToString());

}

My View

@if (Model != null)

{

foreach (var item in Model)

{

}

Name	Relation
@item.name	@item.Relation

My Script

Above is my code.Now i want to load the table values in ajax success function on year change event but it is not working any one check and help me to resolve this issue .Thanks.

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Anish Ansari5y ago
May be you should use $('prebody').empty().html so that each time it loads display the new records.
Ruchi Sharavat5y ago
Instead of :

$('prebody').html( $('prebody').html() + ''+data[i].name+'' +
''+data[i].Relation+'');

try:

$('#prebody').append( ''+data[i].name+'' +
''+data[i].Relation+'');
Sachin Singh5y ago
put a debugger in the success function and inspect whether you are getting values in data or not?
if only the old values are there, it means data must be null.
Sneha K5y ago
Before calling ajax function in table i have one row .Afterthat i call the ajax function i will add some values in db and tried to bind that list again to table in ajax success function . But it only showing the previous value only .That is the issue
Sachin Singh5y ago
it will only show you the values that you are getting from controller, which means for Id=3 always.
Sneha K5y ago
@sachin Singh this code not shwing the new values it showing only the old values i want both
Sneha K5y ago
Sure I will check and tell you
Sachin Singh5y ago
Test this
success: function (data) {
$(data).each(function(){
var row= document.createElement("tr");
$(row).append(""+data.name+"").append(""+data.Relation+"");
$("#prebody").append(row);

});
}
});