Loading

Internal Server Error

Internal Server Error

Guest User

8y717Web Development

$(document).ready(function () {
//getting Error in this line
var oTable = $('#myTable').DataTable({
ajax: {
type: 'Post',
url:'@Url.Action("ClientProductList", "ClientMaster")',
contentType: "application/json; charset=utf-8",
datatype: 'json',
},
columns: [
{ data: 'CLProductId', autowidth: true },
{ data: 'ProductId', autowidth: true },
{ data: 'ProductName', autowidth: true },
{ data: 'ClientProductDetail', autowidth: true },
{ data: 'ParentProductId', autowidth: true },
{ data: 'Act_Date',autowidth: true },
{ data: 'Exp_Date', autowidth: true },
{
"data": "CLProductId", 'bSortable': false,
'aTargets': -1, "width": "50px", "render": function (data) {
return ' + data + '">Edit';
}
},
{
"data": "CLProductId", 'bSortable': false,
'aTargets': -1, "width": "50px", "render": function (data) {
return ' + data + '">Delete';
}
}
]
});
})

2 Replies

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

Guest User8y ago
1. [HttpGet]
2. public ActionResult ClientProductList(string id)
3. {
5. return View();
6. }
8. [HttpPost]
9. [ActionName("ClientProductList")]
10. public ActionResult ClientProductList1(string id)
11. {
12. using (MySqlConnection con = new MySqlConnection())
13. {
14. con.ConnectionString = constr;
15. MySqlDataAdapter da = new MySqlDataAdapter("SELECT cm.ClientId,cm.ClientName, pa.ProductName,cp.ClProductId,cp.ProductId,"
16. +"cp.ParentProductId,cp.Act_Date,cp.Exp_Date,cp.ClientProductDetail "
17. + "FROM ClientMaster cm inner join ClientProduct cp on cm.ClientId = cp.ClientID "
18. + "inner join ProductMaster pa ON pa.ProductId = cp.ProductId where cm.ClientId='" + id + "'", con);
19. DataSet ds = new DataSet();
20. da.Fill(ds);
21. foreach (DataRow dr in ds.Tables[0].Rows)
22. {
23. CMS.Add(new ClientMaster()
24. {
25. ClientID = dr[0].ToString(),
26. ClientName = dr[1].ToString(),
27. CLProductId = dr[2].ToString(),
28. ProductId = dr[3].ToString(),
29. ProductName = dr[4].ToString(),
30. ClientProductDetail = dr[5].ToString(),
31. ParentProductId = dr[6].ToString(),
32. Act_Date = dr[7].ToString(),
33. Exp_Date = dr[8].ToString(),
35. });
36. }
37. return View(CMS.AsEnumerable());
38. }
39. }

Sankara Krishnan Venugopal

Sankara Krishnan Venugopal8y ago

HI,

Could you give the more details about error?

Thanks.