Hi Developers,
I have done the generate hyperlink column dynamically and working fine as get from Column names database.
However suppose someone change the naming convention on database sp it will not work or throw error.
So now am need to bind the respective column names dynamically.
I am using the following C# code
if (responseCode == 0)
{
var obj = JObject.Parse(JsonConvert.SerializeXmlNode(doc));
GetClassWiseInventoryDetails = obj["Response"]["GetClassWiseInventoryDetails"].ToString();
// Get Class Wise Inventory Details
XmlNodeList DataClassWiseInventoryDetails = doc.GetElementsByTagName("GetClassWiseInventoryDetails");
DataTable dtClassWiseInventoryDetails = Dynamic.ConvertXmlNodeListToDataTable(DataClassWiseInventoryDetails);
if (dtClassWiseInventoryDetails.Columns.Contains("CLASS_ID"))
{
foreach (DataRow drClassWiseInventoryDetails in dtClassWiseInventoryDetails.Rows)
{
// Get Basic Details Hyper Link
foreach (DataColumn column in dtClassWiseInventoryDetails.Columns)
{
// Current ouput
drClassWiseInventoryDetails["Vehicle_Type"] = "<a style='color:blue' href='#' onclick='return ViewBasicDetails("" + drClassWiseInventoryDetails["AgentId"] + "," + drClassWiseInventoryDetails["CLASS_ID"] + "," + 2 + "");' title='Click To View'>" + drClassWiseInventoryDetails["Vehicle_Type"] + "</a>";
drClassWiseInventoryDetails["Total_Tags"] = "<a style='color:blue' href='#' onclick='return ViewBasicDetails("" + drClassWiseInventoryDetails["AgentId"] + "," + drClassWiseInventoryDetails["CLASS_ID"] + "," + 2 + "");' title='Click To View'>" + drClassWiseInventoryDetails["Total_Tags"] + "</a>";
//Expected Output
drClassWiseInventoryDetails[BindCoumnNameDynamically] = "<a style='color:blue' href='#' onclick='return ViewBasicDetails("" + drClassWiseInventoryDetails["AgentId"] + "," + drClassWiseInventoryDetails[BindCoumnNameDynamically] + "," + 2 + "");' title='Click To View'>" + drClassWiseInventoryDetails[BindCoumnNameDynamically] + "</a>";
drClassWiseInventoryDetails[BindCoumnNameDynamically] = "<a style='color:blue' href='#' onclick='return ViewBasicDetails("" + drClassWiseInventoryDetails["AgentId"] + "," + drClassWiseInventoryDetails[BindCoumnNameDynamically] + "," + 2 + "");' title='Click To View'>" + drClassWiseInventoryDetails[BindCoumnNameDynamically] + "</a>";
}
}
}
}
If anyone know how to complete this kindly help me to done this task.
Thanks and Regards,
Paul.