How to Get and Assign a column name dynamically from datatable using c

Paul Rajs

Hi Developers,

I have done the generate hyperlink column dynamically and working fine as get from Column names database.

However suppose some one change the naming convension on database sp it will not work or throw error.

So now am need to bind the respective column names dynamically.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"] = "" + drClassWiseInventoryDetails["Vehicle_Type"] + "";
                drClassWiseInventoryDetails["Total_Tags"] = "" + drClassWiseInventoryDetails["Total_Tags"] + "";

                //Expected Output
                drClassWiseInventoryDetails[BindCoumnNameDynamically] = "" + drClassWiseInventoryDetails[BindCoumnNameDynamically] + "";
                drClassWiseInventoryDetails[BindCoumnNameDynamically] = "" + drClassWiseInventoryDetails[BindCoumnNameDynamically] + "";
            }
        }
    }
}

If anyone know how to complete this kindly help me to done this task.

Thanks and Regards,

Paul.S

2 Replies

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

Sachin Singh5y ago
Accepted answer
you can create a mapper for this, where you need to pass the select query to get column values from the database
public DataTable ReadTable(string sql, params object[] parameters) {


    using (var cmd = CreateCommand(sql, parameters))
        {
            var reader = cmd.ExecuteReader();
            if (reader == null)
            {
                return null;
            }

            var schemaTable = reader.GetSchemaTable();
                            DataTable dt = GetTable(schemaTable);

            while (reader.Read())
            {
                var values = new object[reader.FieldCount];
                reader.GetValues(values);
                                    dt.Rows.Add(values);

            }
        }
}

private DataTable GetTable(DataTable schemaTable) {
        if (schemaTable == null || schemaTable.Rows.Count == 0)
        {
            return null;
        }

        var dt = new DataTable();
        foreach (DataRow schemaRow in schemaTable.Rows)
        {
            var col = new DataColumn
            {
                ColumnName = schemaRow["ColumnName"].ToString(),
                                    DataType = schemaRow["DataType"]

            };
                            dt.Columns.Add(col);
        }
        return dt;

}
+2
Paul Rajs5y ago
Thanks mr.Sachin your are right , but i have done the following code,

Thanking you

if (dtDetails.Rows.Count > 0)
{
foreach (DataRow drDetails in dtDetails.Rows)
{
string AgentID = drDetails[0].ToString();
string ClassId = drDetails[1].ToString();
drDetails[dtDetails.Columns[2].ColumnName.ToString()] = "" + drDetails[2].ToString() + "";
}
}
+1