Hi
I dont know your exact requirement. But assuming you need to bring a known schema csv data to a datatable. If so, check below is a simple method which reads text file and converts to a datatable:
DataTable dt = new DataTable();
dt.Columns.Add("Col1");
dt.Columns.Add("Col2");
dt.Columns.Add("Col3");
StreamReader sr = new StreamReader(@"d:\test.txt
string input;
while ((input = sr.ReadLine()) != null)
{
string[] s = input.Split(new char[] { ',' });
dt.Rows.Add(s);
}
sr.Close();
return dt;
Thanks
Main Topics
Browse All Topics
by: gauthampjPosted on 2007-09-06 at 00:03:32ID: 19838103
try this
http://www.codeproject.com
or
string strConnString=
"Driver={Microsoft Text Driver (*.txt;*.csv)};
Dbq="+txtCSVFolderPath.Tex
Extensions=asc,csv,tab,txt
Persist Security Info=False";
string sql_select;
System.Data.Odbc.OdbcConne
//Create connection to CSV file
conn = new System.Data.Odbc.OdbcConne
strConnString.Trim ());
// For creating a connection using DSN, use following line
//conn = new System.Data.Odbc.OdbcConne
//Open the connection
conn.Open ();
//Fetch records from CSV
sql_select="select * from ["+ filetable +"]";
obj_oledb_da=new System.Data.Odbc.OdbcDataA
sql_select,conn);
//Fill dataset with the records from CSV file
obj_oledb_da.Fill(ds,"Stoc
//Set the datagrid properties
dGridCSVdata.DataSource=ds
dGridCSVdata.DataMember="S
//Close Connection to CSV file
conn.Close ();