Render Id in anchor tag click datatable

Render Id in anchor tag click datatable.

Here is the code:

'columnDefs': [
{
targets: 2,
render: function (data, type, row, meta) {
if (type === 'display') {
data = ' + data["Id"] + '">' + data + '';
}
return data;
}
}
],

How do i pass the row value on id.

i.e. pass like @itm.Title on anchor tag click.

how do i get the id??

Here is the total code of datatable:

$(document).ready(function ()
{
debugger
$('#TableId').DataTable(
{
//"columnDefs": [
// { "width": "5%", "targets": [0] },
// {
// "className": "text-center custom-middle-align",
// "targets": [0, 1, 2, 3, 4, 5, 6]
// },
//],
'columnDefs': [{
'targets': 0,
'searchable': false,
'orderable': false,
'width': '1%',
'className': 'dt-body-center',
'render': function (data, type, full, meta) {
return '';
}
}
,
{
targets: 2,
render: function (data, type, row, meta) {
if (type === 'display') {
data = ' + data["Id"] + '">' + data + '';
}
return data;
}
}
],
"language":
{
"processing": "

"processing": true,

"serverSide": true,

"ajax":

{

"url": "/TicketTemplate/GetData",

"type": "POST",

"dataType": "JSON"

"columns": [

{ "data": '' },

{ "data": "CreatedDate" },

{ "data": "Title" },

//{

// //"data": "title",

// "render": function (data, type, row, meta) {

// //return '' + title + '';

// return '' + data + '';

// }

//},

//{

// //"data": "title",

// "render": function (data, type, row, meta) {

// //return '' + title + '';

// return "" + row.Title + " ";

// }

//},

{ "data": "Name" },

{ "data": "Email" },

{ "data": "AssignTo" },

{ "data": "Status" }

]

});

in the of the table i am using.look at the top of my question i have mention the table.

public ActionResult GetData()
{
// Initialization.
JsonResult result = new JsonResult();
try
{
// Initialization.
string search = Request.Form.GetValues("search[value]")[0];
string draw = Request.Form.GetValues("draw")[0];
string order = Request.Form.GetValues("order[0][column]")[0];
//string ordColumnName = Request.Form.GetValues("order[0][columnname]")[0];
string orderDir = Request.Form.GetValues("order[0][dir]")[0];
int startRec = Convert.ToInt32(Request.Form.GetValues("start")[0]);
// int pageSize = Convert.ToInt32(Request.Form.GetValues("length")[0]);
var start = Request.Form.GetValues("start").FirstOrDefault();
var length = Request.Form.GetValues("length").FirstOrDefault();
int pageSize = length != null ? Convert.ToInt32(length) : 0;
int recordStatr = start != null ? Convert.ToInt32(start) : 0;
recordStatr = recordStatr == 0 ? 1 : recordStatr;
var pageIndex = (recordStatr / pageSize) + 1;
int recordsTotal = 0;
// Loading.
List data = this.LoadData();
// Total record count.
int totalRecords = data.Count;
// Verification.
//if (!string.IsNullOrEmpty(search) &&
// !string.IsNullOrWhiteSpace(search))
//{
// // Apply search
// data = data.Where(p => p.Title.ToString().ToLower().Contains(search.ToLower()) ||
// p.Name.ToLower().Contains(search.ToLower()) ||
// p.Email.ToString().ToLower().Contains(search.ToLower())).ToList();
// //p.ProductName.ToLower().Contains(search.ToLower()) ||
// //p.SpecialOffer.ToLower().Contains(search.ToLower()) ||
// //p.UnitPrice.ToString().ToLower().Contains(search.ToLower()) ||
// //p.UnitPriceDiscount.ToString().ToLower().Contains(search.ToLower())).ToList();
//}
// Sorting.
data = this.SortByColumnWithOrder(order, orderDir, data);
// Filter record count.
int recFilter = data.Count;
// Apply pagination.
// data = data.Skip(startRec).Take(pageSize).ToList();
// Loading drop down lists.
// result = this.Json(new { draw = Convert.ToInt32(draw), recordsTotal = totalRecords, recordsFiltered = recFilter, data = data }, JsonRequestBehavior.AllowGet);
// Apply pagination.
//Find Order Column
//var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault();
//var sortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault();
var client = new HttpClient();
client.BaseAddress = new Uri("http://localhost:1849");
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
// string _url = _apiTicket + ".Get?UserId=" + 10 + "&PageIndex=" + pageIndex + "&PageSize=" + pageSize;
//var response = client.GetAsync(_url).Result;
//var response1 = client.GetAsync("/Areas/Ticket/Api/Get/10,10,10").Result;
//if (response1.IsSuccessStatusCode)
//{
// string responseString = response.Content.ReadAsStringAsync().Result;
//}
// string apiUrl = "http://localhost:1849/Api/Ticket?UserId=10";
//string _url = _apiTicket + "Get1/10?searchstr=Monaj&PageIndex=" + pageIndex + "&PageSize=" + pageSize;
// string apiUrl = "http://localhost:1849/Api/Ticket?UserId=" + 10 ;
//string apiUrl = "http://localhost:1849/Api/Ticket?UserId=10&start=1&length=10";
string apiUrl = "http://localhost:1849/Api/Ticket?UserId=10&start="+ start + "&length="+ length +"&searchstr="+search +"&orders="+order+"&orderDir="+orderDir+ "";
//string apiUrl = "../Areas/Api/Ticket/1?searchstr=Monaj&start=0&length=10";
var response = client.GetAsync(apiUrl).Result;
var result1 = response.Content.ReadAsStringAsync().Result;
var settings = new JsonSerializerSettings();
settings.MetadataPropertyHandling = MetadataPropertyHandling.Ignore;
var obj = JsonConvert.DeserializeObject(result1, settings);
// HttpResponseMessage response = await client.GetAsync(_url);
// HttpResponseMessage response = client.GetAsync(_url).Result;
//var response = client.GetAsync(_url).Result;
// var result1 = response.Content.ReadAsStringAsync().Result;
JsonResult jsonresult = Json(result1, JsonRequestBehavior.AllowGet);
// var friends = new JavaScriptSerializer().Deserialize>(jsonresult.Data.ToString());
//var responseResult = JsonConvert.DeserializeObject>
// (response.Content.ReadAsStringAsync().Result);
//JToken root = JObject.Parse(jsonresult.Data.ToString());
//JToken user = root["data"];
//User deserializedUser = JsonConvert.DeserializeObject(user.ToString());
//var settings = new JsonSerializerSettings() { Culture = System.Globalization.CultureInfo.InvariantCulture };
//var dataOut = JsonConvert.DeserializeObject>(jsonresult.Data.ToString(), settings);
////welsh culture, case I think that is what you are using, but for me is working
//Dictionary dictionary = JsonConvert.DeserializeObject>(jsonresult.Data.ToString());
GetSSASAcademyBookedCoursesModel _contacts = new GetSSASAcademyBookedCoursesModel();
_contacts = JsonConvert.DeserializeObject(jsonresult.Data.ToString());
recordsTotal = _contacts.totalRecords;
// var summoners =Jsovar friends = new JavaScriptSerializer().Deserialize>(theJsonString);nConvert.DeserializeObject>(jsonresult.Data.ToString());
// result = this.Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = _contacts.listcourses }, JsonRequestBehavior.AllowGet);
// result = this.Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = _contacts }, JsonRequestBehavior.AllowGet);
result = this.Json(new { draw = Convert.ToInt32(draw), recordsFiltered = totalRecords, recordsTotal = recordsTotal, data = _contacts.listcourses }, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
// Info
Console.Write(ex);
}
// Return info.
return result;
}

9 Replies

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

Manoj Maharana9y ago
in the of the table i am using.look at the top of my question i have mention the table.
public ActionResult GetData()
       {
           // Initialization.
           JsonResult result = new JsonResult();

           try
           {
               // Initialization.
               string search = Request.Form.GetValues("search[value]")[0];
               string draw = Request.Form.GetValues("draw")[0];
               string order = Request.Form.GetValues("order[0][column]")[0];
               //string ordColumnName = Request.Form.GetValues("order[0][columnname]")[0];
               string orderDir = Request.Form.GetValues("order[0][dir]")[0];
               int startRec = Convert.ToInt32(Request.Form.GetValues("start")[0]);
               //  int pageSize = Convert.ToInt32(Request.Form.GetValues("length")[0]);


               var start = Request.Form.GetValues("start").FirstOrDefault();
               var length = Request.Form.GetValues("length").FirstOrDefault();
               int pageSize = length != null ? Convert.ToInt32(length) : 0;
               int recordStatr = start != null ? Convert.ToInt32(start) : 0;
               recordStatr = recordStatr == 0 ? 1 : recordStatr;
               var pageIndex = (recordStatr / pageSize) + 1;
               int recordsTotal = 0;







               // Loading.
               List data = this.LoadData();

               // Total record count.
               int totalRecords = data.Count;

               // Verification.
               //if (!string.IsNullOrEmpty(search) &&
               //    !string.IsNullOrWhiteSpace(search))
               //{
               //    // Apply search
               //    data = data.Where(p => p.Title.ToString().ToLower().Contains(search.ToLower()) ||
               //                           p.Name.ToLower().Contains(search.ToLower()) ||
               //                           p.Email.ToString().ToLower().Contains(search.ToLower())).ToList();
               //    //p.ProductName.ToLower().Contains(search.ToLower()) ||
               //    //p.SpecialOffer.ToLower().Contains(search.ToLower()) ||
               //    //p.UnitPrice.ToString().ToLower().Contains(search.ToLower()) ||
               //    //p.UnitPriceDiscount.ToString().ToLower().Contains(search.ToLower())).ToList();
               //}

               // Sorting.
               data = this.SortByColumnWithOrder(order, orderDir, data);

               // Filter record count.
               int recFilter = data.Count;

               // Apply pagination.
               // data = data.Skip(startRec).Take(pageSize).ToList();

               // Loading drop down lists.
               // result = this.Json(new { draw = Convert.ToInt32(draw), recordsTotal = totalRecords, recordsFiltered = recFilter, data = data }, JsonRequestBehavior.AllowGet);




               // Apply pagination.




               //Find Order Column
               //var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault();
               //var sortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault();




               var client = new HttpClient();


               client.BaseAddress = new Uri("http://localhost:1849");
               client.DefaultRequestHeaders.Accept.Clear();
               client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));

               // string _url = _apiTicket + ".Get?UserId=" + 10 + "&PageIndex=" + pageIndex + "&PageSize=" + pageSize;
               //var response = client.GetAsync(_url).Result;
               //var response1 = client.GetAsync("/Areas/Ticket/Api/Get/10,10,10").Result;
               //if (response1.IsSuccessStatusCode)
               //{
               //    string responseString = response.Content.ReadAsStringAsync().Result;
               //}
               // string apiUrl = "http://localhost:1849/Api/Ticket?UserId=10";
               //string _url = _apiTicket + "Get1/10?searchstr=Monaj&PageIndex=" + pageIndex + "&PageSize=" + pageSize;
               // string apiUrl = "http://localhost:1849/Api/Ticket?UserId=" + 10  ;
               //string apiUrl = "http://localhost:1849/Api/Ticket?UserId=10&start=1&length=10";
               string apiUrl = "http://localhost:1849/Api/Ticket?UserId=10&start="+ start + "&length="+ length +"&searchstr="+search +"&orders="+order+"&orderDir="+orderDir+ "";
               //string apiUrl = "../Areas/Api/Ticket/1?searchstr=Monaj&start=0&length=10";
               var response = client.GetAsync(apiUrl).Result;

               var result1 = response.Content.ReadAsStringAsync().Result;

               var settings = new JsonSerializerSettings();
               settings.MetadataPropertyHandling = MetadataPropertyHandling.Ignore;

               var obj = JsonConvert.DeserializeObject(result1, settings);


               // HttpResponseMessage response = await client.GetAsync(_url);
               //  HttpResponseMessage response = client.GetAsync(_url).Result;
               //var response = client.GetAsync(_url).Result;
               // var result1 = response.Content.ReadAsStringAsync().Result;

               JsonResult jsonresult = Json(result1, JsonRequestBehavior.AllowGet);
              // var friends = new JavaScriptSerializer().Deserialize>(jsonresult.Data.ToString());
               //var responseResult = JsonConvert.DeserializeObject>
               //    (response.Content.ReadAsStringAsync().Result);
               //JToken root = JObject.Parse(jsonresult.Data.ToString());
               //JToken user = root["data"];
               //User deserializedUser = JsonConvert.DeserializeObject(user.ToString());

               //var settings = new JsonSerializerSettings() { Culture = System.Globalization.CultureInfo.InvariantCulture };
               //var dataOut = JsonConvert.DeserializeObject>(jsonresult.Data.ToString(), settings);
               ////welsh culture, case I think that is what you are using, but for me is working

               //Dictionary dictionary = JsonConvert.DeserializeObject>(jsonresult.Data.ToString());


               GetSSASAcademyBookedCoursesModel _contacts = new GetSSASAcademyBookedCoursesModel();

               _contacts = JsonConvert.DeserializeObject(jsonresult.Data.ToString());
              recordsTotal = _contacts.totalRecords;

               // var summoners =Jsovar friends = new JavaScriptSerializer().Deserialize>(theJsonString);nConvert.DeserializeObject>(jsonresult.Data.ToString());
               // result = this.Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = _contacts.listcourses }, JsonRequestBehavior.AllowGet);
               // result = this.Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = _contacts }, JsonRequestBehavior.AllowGet);
               result = this.Json(new { draw = Convert.ToInt32(draw), recordsFiltered = totalRecords, recordsTotal = recordsTotal, data = _contacts.listcourses }, JsonRequestBehavior.AllowGet);




           }
           catch (Exception ex)
           {
               // Info
               Console.Write(ex);
           }

           // Return info.
           return result;
       }
Ramesh Palanivel9y ago
Hi Manoj,

May I know where the datatable you wrote?

Can you share this entire source
Manoj Maharana9y ago
The best way is, Pass the encrypted email id to javascript fucntion.

Then write the ajax in that function and post your value to controller and get the value in controller and pass it to decryption class and store the value.
???

i am using datatable server side.
write down the code to pass the encrypted email id to javascript function??
Ramesh Palanivel9y ago
Hi Manoj,

The best way is, Pass the encrypted email id to javascript fucntion.

Then write the ajax in that function and post your value to controller and get the value in controller and pass it to decryption class and store the value.
Manoj Maharana9y ago
no how?? can you tell me??
Ramesh Palanivel9y ago
Hi Manoj,

Have wrote this encryption and Decryption in javascript?
Manoj Maharana9y ago
i want to use a class in email because the email is decryped format.

so for encrpted i am using a class AESCryptography.AES256_Decrypt .

so where should i write this class in email decryption in datatable??
Ramesh Palanivel9y ago
Hi Manoj,

Just try this code,
$('#TableId').DataTable(
    {
        //"columnDefs": [
        //    { "width": "5%", "targets": [0] },
        //    {
        //        "className": "text-center custom-middle-align",

        //        "targets": [0, 1, 2, 3, 4, 5, 6]
        //    },
        //],
        'columnDefs': [{
            'targets': 0,
            'searchable': false,
            'orderable': false,
            'width': '1%',
            'className': 'dt-body-center',
            'render': function (data, type, full, meta) {
                return '';
            }
        }
        ,
          {
              targets: 2,
              render: function (data, type, row, meta) {
                  if (type === 'display') {
                      data = '#'    onclick=PassValueToController('" + data["Id"] + "') >" >' + data + '';
                  }

                  return data;
              }
          }
        ],
        "language":
            {
                "processing": "
"
},
"processing": true,
"serverSide": true,
"ajax":
{
"url": "/TicketTemplate/GetData",
"type": "POST",
"dataType": "JSON"
},
"columns": [
{ "data": '' },
{ "data": "CreatedDate" },
{ "data": "Title" },
//{
// //"data": "title",
// "render": function (data, type, row, meta) {
// //return '' + title + '';
// return '' + data + '';
// }
//},
//{
// //"data": "title",
// "render": function (data, type, row, meta) {
// //return '' + title + '';
// return "" + row.Title + " ";
// }
//},
{ "data": "Name" },
{ "data": "Email" },
{ "data": "AssignTo" },
{ "data": "Status" }
]
});
function PassValueToController()
{
//write your ajax call to pass the values to controller
}