Assign column values dynamically from DataTable row in ASP.Net using C#

paulrajm...

SOLVED CLOSED ACTIVE ANSWERED
User: paulrajmca
Posted: on Jul 01, 2021 10:59 PM
Forum: Data Controls
Answer: 1
Views: 6180

Hi Developers,

I have done the generate hyperlink column dynamically and working fine as get Column Names from 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 Values Dynamically.am using the following C# code

XmlNodeList DataClassWiseInventoryDetails = doc.GetElementsByTagName("GetClassWiseInventoryDetails");
DataTable dtDetails = Dynamic.ConvertXmlNodeListToDataTable(DataClassWiseInventoryDetails);
foreach (DataRow drDetails in dtDetails.Rows)
{
    // Current Output
    drDetails[dtDetails.Columns[0].ColumnName.ToString()] = "<a style='color:blue' href='#' onclick='return ViewBasicDetails(&quot;" + drDetails["Vehicle_Type"] + "," + drDetails["CLASS_ID"] + "," + 2 + "&quot;);' title='Click To View'>" + drDetails["Vehicle_Type"] + "</a>";
    drDetails[dtDetails.Columns[1].ColumnName.ToString()] = "<a style='color:blue' href='#' onclick='return ViewBasicDetails(&quot;" + drDetails["Total_Tags"] + "," + drDetails["CLASS_ID"] + "," + 2 + "&quot;);' title='Click To View'>" + drDetails["Total_Tags"] + "</a>";

    // Expected Output
    drDetails[dtDetails.Columns[0].ColumnName.ToString()] = "<a style='color:blue' href='#' onclick='return ViewBasicDetails(&quot;" + BindColumnNameValueDynamically + "," + BindColumnNameValueDynamically + "," + 6 + "&quot;);' title='Click To View'>" + BindColumnNameValueDynamically + "</a>";
    drDetails[dtDetails.Columns[1].ColumnName.ToString()] = "<a style='color:blue' href='#' onclick='return ViewBasicDetails(&quot;" + BindColumnNameValueDynamically + "," + BindColumnNameValueDynamically + "," + 1 + "&quot;);' title='Click To View'>" + BindColumnNameValueDynamically + "</a>";
}

If anyone of you know how to done this task, kindly suggest me to complete this.

Thanks and Regards,

Paul.S

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 2

Reply
ANSWER
User: dharmendr
Replied: on Jul 02, 2021 02:38 AM
Report

paulrajmca says:
    // Expected Output

    drDetails[dtDetails.Columns[0].ColumnName.ToString()] = "<a style='color:blue' href='#' onclick='return ViewBasicDetails("" + BindColumnNameValueDynamically + "," + BindColumnNameValueDynamically + "," + 6 + "");' title='Click To View'>" + BindColumnNameValueDynamically + "</a>";

    drDetails[dtDetails.Columns[1].ColumnName.ToString()] = "<a style='color:blue' href='#' onclick='return ViewBasicDetails("" + BindColumnNameValueDynamically + "," + BindColumnNameValueDynamically + "," + 1 + "");' title='Click To View'>" + BindColumnNameValueDynamically + "</a>";

The only way is to either pass ColumnName or ColumnIndex to fetch and set the value.

So you need to know the index or name of the columns.

drDetails[dtDetails.Columns[0].ColumnName.ToString()] = "<a style='color:blue' href='#' onclick='return ViewBasicDetails(&quot;" + drDetails[3].ToString() + "," + drDetails[1].ToString() + "," + 2 + "&quot;);' title='Click To View'>" + drDetails[3].ToString() + "</a>";
drDetails[dtDetails.Columns[1].ColumnName.ToString()] = "<a style='color:blue' href='#' onclick='return ViewBasicDetails(&quot;" + drDetails[4].ToString() + "," + drDetails[1].ToString() + "," + 2 + "&quot;);' title='Click To View'>" + drDetails[4].ToString() + "</a>";

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Assign column values dynamically from DataTable row in ASP.Net using C#

Company

Explore

Follow us

Contact Us