title: How can I create schema.ini file? I need to export my .csv file to datagridview
body: <p>I want to export a <a href="http://en.wikipedia.org/wiki/Comma-separated_values" rel="nofollow">CSV</a> file to a datagridview. I need to create the file <code>schema.ini</code>. But I don't know, how can I create it?</p>
  
  <p>There is my code:</p>
  
  <pre><code>    public DataTable exceldenAl(string excelFile)
      {
          try
          {
              string fileName = Path.GetFileName(excelFile);
              string pathOnly = Path.GetDirectoryName(excelFile);
              string cmd = "Select * From [" + fileName + "$]";
  
              string cnstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + pathOnly + "\\;Extended Properties=\"Text;HDR=Yes;FORMAT=Delimited\"";
              OleDbConnection ocn = new OleDbConnection(cnstr);
              ocn.Open();
              OleDbCommand command = new OleDbCommand(cmd,ocn);
              OleDbDataAdapter adap = new OleDbDataAdapter(command);
  
              DataTable dt = new DataTable();
              dt.Locale = CultureInfo.CurrentCulture;
              adap.Fill(dt);
              return dt;
          }
          finally {
          }
      }
  
  
      private void btnExcelReader_Click(object sender, EventArgs e)
      {
          string dosya;
          string cevap;
          openFileDialog1.ShowDialog();
          dosya = openFileDialog1.FileName.ToString();
          ClsExcelReader er = new ClsExcelReader();
          cevap = er.exceldenAl(dosya).ToString();
          dataGridView1.DataSource = cevap;
          //listViewExcelOku.DataBindings =
      }
  }
  </code></pre>