title: Creating Auto complete textbox
body: <p>here's the method created, I am getting an Error that i don't seem to understand how it's coming about please help!! The <strong>Error</strong> is <strong>The best Overloaded method match for 'System.Data.Common.DbDataReader.GetString(int)' has some invalid arguments</strong> </p>
  
  <pre><code>void AutoCompleteText()
      {
          search_txt.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
          search_txt.AutoCompleteSource = AutoCompleteSource.CustomSource;
          AutoCompleteStringCollection coll = new AutoCompleteStringCollection();
  
          OleDbCommand command = new OleDbCommand();
          command.Connection = conDB;
          command.CommandText = "select CCSpn_CODE,CCLname,CCFname,CCMname,CCDOB,CCgender,CCSchool,CaClass,CCVillage,CCSiblings,CCGuardian,CCContact,CCcurrentDt,CCImage from abaanaCC";
         // OleDbDataReader myreader;
          conDB.Open();
  
  
          OleDbDataReader myreader = command.ExecuteReader()
  
  
              while (myreader.Read())
              {
                  //tring sName = myreader["CCLname"].ToString();
                  string sName = myreader.GetString(1);
                  //string sName = Convert.ToString(myreader.("CCLname"));
                  coll.Add(sName);
              }
  
              search_txt.AutoCompleteCustomSource = coll;
              myreader.Close();
  
  
          conDB.Close();
  
      }
  </code></pre>