private void llena_grid(string sql)
{
Grid_Articulos.DataSource = conn1.GetTable(sql);
if (Grid_Articulos.RowCount < 2)
{
Grid_Articulos.Visible = false;
return;
}
Grid_Articulos.AutoResizeColumns();
}
private void txtnombre_TextChanged(object sender, EventArgs e)
{
if (txtnombre.TextLength > 3 && txtid.Text == "")
{
Grid_Articulos.Visible = true;
//grid1.DataSource = conn.GetTable("select id,nombre_corto,nombre_largo from catarticulos");
Grid_Articulos.DataSource = conn1.GetTable("select id as Id_Producto,nombre_corto as Nombre," +
" nombre_largo as Descripcion from catarticulos where nombre_corto like '%" + txtnombre.Text + "%' order by nombre_corto limit 20");
if (Grid_Articulos.RowCount < 2)
{
Grid_Articulos.Visible = false;
return;
}
Grid_Articulos.AutoResizeColumns();
}
}
