public DataSet ExecuteDataSetQuery(string dbQuerry)
{
DataSet ds = new DataSet();
string tableName = new FileInfo(FilePath).Name;
string table = tableName.Split('.')[0];
if (dbQuerry.Contains(table))
{
dbQuerry = dbQuerry.Replace(table,tableName);
}
using (OleDbConnection cn = new OleDbConnection(conStrFrCsv))
{
//,new FileInfo(fileName).Name
//"select *from NewData.csv"
using (OleDbCommand cmd = new OleDbCommand(string.Format(dbQuerry), cn))
{
try
{
cn.Open();
using (OleDbDataAdapter adapter = new OleDbDataAdapter(cmd))
{
adapter.Fill(ds);
}
}
catch (Exception ex)
{
throw;
}
finally
{
cn.Close();
}
return ds;
}
}
}