Tag: type

I want to check the data type of each data of excel data. But when i check the excel data it shows all data as string type.

C#,oleDb

  //For validating Datatype         public List<string> ValidateDataType(DataRow row, List<DataExchangeDefinition> dataExchangeDefinitionList, List<string> dataColumnList)         {             //var dataColumnString = String.Join(", ", dataColumnList.ToArray());              Dictionary<string, Type> types = new Dictionary<string, Type>();             types.Add("int", typeof(System.Int32));             //types.Add("int", typeof(System.Int64));             types.Add("DateTime", typeof(System.DateTime));             types.Add("decimal", typeof(System.Decimal));             types.Add("float", typeof(System.Double));             types.Add("String", typeof(System.String));               List<string> dataTypeErrorList = new List<string>();             foreach (DataExchangeDefinition dt in dataExchangeDefinitionList)             {                 if (dataColumnList.Any(str => str == dt.FieldName))                 {                     if (!row.IsNull(dt.FieldName))                     {                         var dat = row[dt.FieldName];                         var t = row[dt.FieldName].GetType().Name;                                        var conObj = Convert.ChangeType(dat,types[t]);                          string error = (from e in row.ItemArray                                         where conObj.GetType().Name.Contains(dt.DataType) == false                                         select dt.FieldName).DefaultIfEmpty("").FirstOrDefault();                         if (error != "")                         {                             dataTypeErrorList.Add(error);                         }                     }                                                         }             }              return dataTypeErrorList;         } 

In result im passing it as a list. List contains error column names. The checking is done using Linq

Here is the excel data im imported

This is the data in the datatable. Here i added number 2 instead of a string. But it actually takes as string. But here i want detect as int, otherwise my validation will fail.