public ActionResult GetData() { string Constr = System.Configuration.ConfigurationManager.ConnectionStrings["constr"].ConnectionString; var source = new List<mng_industrymodel>(); using (OdbcConnection conn = new OdbcConnection(Constr)) { using (OdbcCommand cmd = new OdbcCommand("call pegasus_industry_select")) { cmd.Connection = conn; conn.Open(); cmd.CommandType = CommandType.StoredProcedure; var dr = cmd.ExecuteReader(); while (dr.Read()) { var orderlists = new mng_industrymodel { industry_Id = dr[0].ToString(), industry_name = dr[1].ToString(), industry_status = dr[2].ToString() }; source.Add(orderlists); } return Json(new { data = source }, JsonRequestBehavior.AllowGet); } } }
$(document).ready(function () { $('#tbltable').DataTable({ "ajax": { "url": "/Management/GetData", "type": "GET", "datatype": "json" }, "columns": [ { "data": "industry_Id" }, { "data": "industry_name" }, { "data": "industry_status" }, { "data": "industry_Id", "render": function (data) { return "<a href='/Management/Edit/" + data + "' class='badge badge-success mb-1'><i class='far fa-edit p-1'></i> Edit</a><a href='' class='badge badge-danger' style='margin-left:5px' onclick=Delete('" + data + "')><i class='far fa-trash-alt p-1'></i> Delete</a>"; }, "orderable": false, "searchable": false, "width": "150px" } ] }); });
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)