| Author: Santhi 04 Dec 2008 | Member Level: Gold | Rating:  Points: 5 |
Hi,
Use this code
public System.Data.DataSet getCSVData(string fn, bool HDRused)
{
string myConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
+ System.IO.Path.GetDirectoryName(fn)
+ ";Extended Properties=\"text;";
if (HDRused)
{
myConnectionString += "HDR=YES;";
}
else
{
myConnectionString += "HDR=NO;";
}
myConnectionString += "FMT=Delimited(,);";
myConnectionString += "\"";
System.Data.OleDb.OleDbConnection myConnection = new System.Data.OleDb.OleDbConnection();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
string myCommand = "SELECT * FROM " + System.IO.Path.GetFileName(fn);
System.IO.Path.GetFileName(fn).Replace(".", "#");
System.Data.OleDb.OleDbDataAdapter myDataAdapter = new System.Data.OleDb.OleDbDataAdapter(myCommand, myConnection);
System.Data.DataSet myData = new System.Data.DataSet();
myDataAdapter.Fill(myData);
if (myConnection.State != System.Data.ConnectionState.Closed)
{
myConnection.Close();
}
return(myData);
}
Hope this code helps you.
|