HI friends,

 

i am calling an action method through ajax and returning a list as json from the controllers action method and now trying to bind the data of list to html table,

i have tried below code, someone please help.

 

 

public JsonResult ShowAttendance(int empid, int branchid, int departmentid, int designationid, string seletedmonth)
{
DataTable Attendance = new DataTable();
List attendance = new List();
using (SqlConnection connection = DLConnection.getConnectionInstance())
{
SqlParameter[] parameter = new SqlParameter[5];
parameter[0] = new SqlParameter("@employeeid",empid);
parameter[1] = new SqlParameter("@BranchId", branchid);
parameter[2] = new SqlParameter("@DepartmentId", departmentid);
parameter[3] = new SqlParameter("@DesignationId", designationid);
parameter[4] = new SqlParameter("@NameOfTheMonth", seletedmonth);
SqlDataReader dr;
dr = SqlHelper.ExecuteReader(connection, CommandType.StoredProcedure, "Usp_getattendance",parameter);
Attendance.Load(dr);
AttendanceData record = new AttendanceData();
for (int i = 0; i < Attendance.Rows.Count; i++)
{
AttendanceData data = new AttendanceData();
data.Date = Attendance.Rows[i]["Dates"].ToString();
data.Day = Attendance.Rows[i]["Day"].ToString();
data.Intime = Attendance.Rows[i]["intime"].ToString();
data.Outtime = Attendance.Rows[i]["Outtime"].ToString();
data.Firsthalf = Attendance.Rows[i]["First_half"].ToString();
data.Secondhalf = Attendance.Rows[i]["Second_half"].ToString();
data.Remark = Attendance.Rows[i]["Remarks"].ToString();
attendance.Add(data);
}
}

 

 

 

@{

Layout = "~/Areas/Payroll_Management/Views/Shared/AdminSite.cshtml";
}