title: getting index after compare or search
body: <p>I want to ask how to get the index</p>
  
  <pre><code>public void cari()
          {
              SqlDataAdapter adapter = new SqlDataAdapter(command.CommandText, myConnection);
              try
              {
                  ds.Tables.Clear();
  
                  command.Connection = myConnection;
                  command.CommandText = "select * from General.genre WHERE genre Like  '%"+textEdit1.Text.ToString()+"%' or code like '%"+textEdit1.Text+"%'";
                  myConnection.Open();
                  //  adapter.Fill(dt);
  
                  var  buka = command.ExecuteReader();
  
  
                  if (buka.Read())
                  {
  
                      var x1 = buka[1].ToString();
                      textEdit2.Text = x1;
                      MessageBox.Show("asdas" + textEdit2.Text + ";");
  
  
                  }
                  else
                  {
                      MessageBox.Show("type genre");
                  }
  </code></pre>
  
  <p>The above code only shows the string, but I want to know how to get the index. Maybe code inside after <code>if (buka.read())</code>?</p>
  
  <p><a href="https://i.stack.imgur.com/xOLjd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xOLjd.png" alt="enter image description here"></a></p>