ASP.NET

if (_fileexten == ".csv")
            {
                string str = Path.GetFileName(_filename);
                OdbcConnection conn = new OdbcConnection("Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + _fpath + "\\;Extensions=asc,csv,tab,txt;Extended Properties=\"HDR=YES;IMEX=1;\";Persist Security Info=False");
                conn.Open();

                string sql_select = "select * from [" + str + "]";
                OdbcDataAdapter myCommand = new OdbcDataAdapter(sql_select, conn);

                myCommand.Fill(myDataSet, "csv");
                dt = myDataSet.Tables[0];

                conn.Close();
                myCommand.Dispose();

            }