read csv in dataset with String dataType of all columns

Question

Hi friends I am facing problem while reading file .csv into datatable. if first value of coulumn is numeric it treats the column datatype as neumeric and doesn't read coulmns value further if in string type. It reads only neumeric values.

Saillesh Pawar · Answer

try doing using dataset DataSet dsdata = ConvertCSVFile1(FileName fileinfo.Name MyNewTable 	); if (dsdata.Tables[MyNewTable].Rows.Count > 0) { //perform your statements for (int i = 0; i { class property = Convert.ToString(dsdata.Tables[MyNewTable].Rows[i][column]).Trim(); //statements } private DataSet ConvertCSVFile1(string target1 string fileName string TableName string delimiter) { System.Data.DataSet result = new DataSet(); StreamReader s = new StreamReader(target1); string[] columns = s.ReadLine().Split(''); result.Tables.Add(TableName); foreach (string col in columns) { bool added = false; string next = ; int i = 0; while (!added) { string columnname = col + next; columnname = columnname.Replace(# ); columnname = columnname.Replace(' ); columnname = columnname.Replace(& ); if (!result.Tables[TableName].Columns.Contains(columnname)) { result.Tables[TableName].Columns.Add(columnname); added = true; } { i++; next = _ + i.ToString(); } } } try { string AllData = s.ReadToEnd().Replace( ).Replace(|| |); string[] rows = AllData.Split(
.ToCharArray()); foreach (string r in rows) { string[] items = r.Split(''); result.Tables[TableName].Rows.Add(items); } } catch (Exception ex) { System.Diagnostics.StackTrace trace = new System.Diagnostics.StackTrace(ex true); lblMsg.Text = Line:  + trace.GetFrame(0).GetFileLineNumber(); } s.Close(); return result; }