Loading

How to add a column in datatable which datatype is array

How to add a column in datatable which datatype is array

Sandeep Kumar

4y1.1kLearn iOS Programming

DataTable DttblNew = new DataTable();

DttblNew.Columns.Add("fld_capa_cd_desc_arr", typeof(System.Array));

drConvertedRaw["fld_capa_cd_desc_arr"] = [];//Error showing how to assign blank array

3 Replies

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

Sachin Singh4y ago
use this
string[] yourArray=new string[]{"str1","str2"};

DataTable dt = new DataTable();
foreach(string s in yourArray)
    dt.Columns.Add();

DataRow row = dt.Rows.Add();
for (int i = 0; i < YourList.Length; i++)
    row.SetField(i, yourArray[i]);
Gajendra Jangid4y ago
Hi you can try this code:
public static Dictionary<string, Type> PrimitiveTypes = new Dictionary<string, Type>
      {
         {"int",typeof(int)},
         {"string",typeof(string)}
      };

    public static void Main(string[] args)
    {
        DataTable dtColorList = new DataTable();

        string[,] values = new string[,] { { "ID", "int" }, { "Name", "string" } };
        AddDataTableColWithType(dtColorList, values);

        Console.ReadLine();
    }

    public static void AddDataTableColWithType(DataTable dtName, string[,] colNameAndType)
    {
        for (int i = 0; i < colNameAndType.Length / 2; i++)
        {
            dtName.Columns.Add(colNameAndType[i, 0], PrimitiveTypes[colNameAndType[i, 1]]);
        }
    }
Srashti Jain4y ago
You will have to write the full name of a Type then you can find it using GetType the method. If you want to get int32 the type you will have to specify like this System.Int32

string[,] values = new string[,] { { "ID", "System.Int32" }, { "Name", "System.String" }, { "ColorID", "System.Int16" } };

To know more information in detail, you should have learned Dot Net Training.