How to add a column in datatable which datatype is array

Question

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

Sachin Singh · Answer

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 row.SetField(i, yourArray[i]);

Gajendra Jangid · Answer

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 { dtName.Columns.Add(colNameAndType[i, 0], PrimitiveTypes[colNameAndType[i, 1]]); } }

Srashti Jain · Answer

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.