try { cn.Open(); AutoCompleteStringCollection acs = new AutoCompleteStringCollection(); OleDbCommand cm = new OleDbCommand("select itemname from purchaseitem", cn); OleDbDataAdapter da = new OleDbDataAdapter(cm); OleDbDataReader dr = cm.ExecuteReader(); if (dr.HasRows == true) { while (dr.Read()) acs.Add(dr["itemname"].ToString()); } txt_itemname.AutoCompleteCustomSource = acs; dr.Close(); cn.Close(); } catch (Exception ex) { throw ex; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)