private void TxtProdNom_TextChanged(object sender, EventArgs e)
{
// agregar estilos
DataTable datos = new DataTable();
datos = prod.estilo(TxtProdNom.Text);
CboEstilo.DataSource = datos;
CboEstilo.DisplayMember = "estilo";
CboEstilo.ValueMember = "id";
AutoCompleteStringCollection coleccionE = new AutoCompleteStringCollection();
foreach (DataRow row in datos.Rows)
{
coleccionE.Add(row["estilo"].ToString());
}
CboEstilo.AutoCompleteCustomSource = coleccionE;
CboEstilo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
CboEstilo.AutoCompleteSource = AutoCompleteSource.CustomSource;
// agregar tipo
datos = prod.tipo(TxtProdNom.Text);
CboTipo.DataSource = datos;
CboTipo.DisplayMember = "tipo";
CboTipo.ValueMember = "id";
AutoCompleteStringCollection coleccionT = new AutoCompleteStringCollection();
foreach (DataRow row in datos.Rows)
{
coleccionT.Add(row["tipo"].ToString());
}
CboTipo.AutoCompleteCustomSource = coleccionT;
CboTipo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
CboTipo.AutoCompleteSource = AutoCompleteSource.CustomSource;
//agregar color
datos = prod.color(TxtProdNom.Text);
CboColor.DataSource = datos;
CboColor.DisplayMember = "color";
CboColor.ValueMember = "id";
AutoCompleteStringCollection coleccionC = new AutoCompleteStringCollection();
foreach (DataRow row in datos.Rows)
{
coleccionC.Add(row["color"].ToString());
}
CboColor.AutoCompleteCustomSource = coleccionT;
CboColor.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
CboColor.AutoCompleteSource = AutoCompleteSource.CustomSource;
string talla = TxtTalla.Text;
TxtTalla.Text = talla;
}
