title: How to read values from datarows. OleDB
body: <p>I am reading dbf file through <code>oledb</code>. I am getting fieldsname and their types but issue is that i am not getting any value in rows. </p>
  
  <p>My code is as follows:</p>
  
  <pre><code>string mySQL = "select * from line75.dbf";  // dbf table name
                  OleDbCommand MyQuery = new OleDbCommand(mySQL, yourConnectionHandler);
                  OleDbDataAdapter DA = new OleDbDataAdapter(MyQuery);
  
                  DA.Fill(YourResultSet);
  
                  for (int i = 0; i &lt; YourResultSet.Columns.Count; i++)
                  {
                      FieldInfo field = new FieldInfo();
                      field.fieldname = YourResultSet.Columns[i].ColumnName;
                      field.fieldtype = YourResultSet.Columns[i].DataType.FullName;
  
                      tableFields.Add(field);
                  }
                  dataGridView1.DataSource = YourResultSet;
  </code></pre>
  
  <p>when i view at <code>datagridview</code>, then i am getting just <code>fieldnames</code> but i am not getting any value.</p>
  
  <p>I have tried many dbf files, but the result is the same.</p>
  
  <p>What i am doing wrong here? I am very confused as i am simply opening connection and trying to get all data.</p>