Render Id in anchor tag click datatable

Question

Render Id in anchor tag click datatable.

Here is the code:

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

How do i pass the row value on id.

i.e. pass like <a href="/TicketTemplate/AppDetails/@itm.Id">@itm.Title</a> 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 '<input type="checkbox">';
}
}
,
{
targets: 2,
render: function (data, type, row, meta) {
if (type === 'display') {
data = '<a href="/TicketTemplate/AppDetails/' + data["Id"] + '">' + data + '</a>';
}
return data;
}
}
],
"language":
{
"processing": "<div class='overlay custom-loader-background'><i class='fa fa-cog fa-spin custom-loader-color'></i></div>"
},
"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 '<a href=\"' + title + '\">' + title + '</a>';
// return '<a href="' + title + '">' + data + '</a>';
// }
//},
//{
// //"data": "title",
// "render": function (data, type, row, meta) {
// //return '<a href=\"' + title + '\">' + title + '</a>';
// return "<a href=" + row.myURL + "/" + row.id + " id=" + row.id + ">" + row.Title + " </a>";
// }
//},
{ "data": "Name" },
{ "data": "Email" },
{ "data": "AssignTo" },
{ "data": "Status" }
]
});
});

Manoj Maharana · Answer

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/101010).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 Palanivel · Answer

Hi Manoj May I know where the datatable you wrote? Can you share this entire source

Manoj Maharana · Answer

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 Palanivel · Answer

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 Maharana · Answer

no how?? can you tell me??

Ramesh Palanivel · Answer

Hi Manoj Have wrote this encryption and Decryption in javascript?

Manoj Maharana · Answer

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 Palanivel · Answer

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 }

Vignesh Mani · Answer

tr = tr +  View Update ;