public void listarpordbusq()
{
AutoCompleteStringCollection coleccion = new AutoCompleteStringCollection();
DataTable datos = new DataTable();
datos = prod.Prodbusque(CboNom.Text);
CboNom.DataSource = datos;
CboNom.DisplayMember = "Nombre";
CboNom.ValueMember = "id_prod";
foreach (DataRow row in datos.Rows)
{
coleccion.Add(row["Nombre"].ToString());
}
CboNom.AutoCompleteMode = AutoCompleteMode.Suggest;
CboNom.AutoCompleteSource = AutoCompleteSource.CustomSource;
CboNom.AutoCompleteCustomSource = coleccion;
}