title: getting a column value from table using vb6
body: <p>I'm trying to read a particular column value from a SQL result table. I know we use RowCount in c#. But I don’t know how it is done in vb6.0
  For example a c# program code:</p>
  
  <pre><code>    adapter.Fill(ds); 
      adapter.Dispose(); 
      con.Close();
      rowCount = ds.Tables[0].Rows.Count;// ds is dataset and I read that record set is used instead of dataset
      if (rowCount &gt; 1)
      {
       ab = ds.Tables[0].Rows[0][3].ToString();
       ad = ds.Tables[0].Rows[0][8].ToString();                  
      }
  </code></pre>