private void BusquedaProductos()
{
DataTable dt = new DataTable();
try
{
P.Marca = txtBuscarProducto.Text;
dt = P.BusquedaProductos(P.Marca);
dataGridView1.Rows.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
dataGridView1.Rows.Add(dt.Rows[i][0]);
dataGridView1.Rows[i].Cells[0].Value = dt.Rows[i][0].ToString();
dataGridView1.Rows[i].Cells[1].Value = dt.Rows[i][1].ToString();
dataGridView1.Rows[i].Cells[2].Value = dt.Rows[i][2].ToString();
dataGridView1.Rows[i].Cells[3].Value = dt.Rows[i][3].ToString();
dataGridView1.Rows[i].Cells[4].Value = dt.Rows[i][4].ToString();
dataGridView1.Rows[i].Cells[5].Value = dt.Rows[i][5].ToString();
dataGridView1.Rows[i].Cells[6].Value = dt.Rows[i][6].ToString();
dataGridView1.Rows[i].Cells[7].Value = Convert.ToDateTime(dt.Rows[i][7].ToString()).ToShortDateString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
dataGridView1.ClearSelection();
}
private void txtBuscarProducto_TextChanged(object sender, EventArgs e)
{
if (txtBuscarProducto.TextLength > 0)
{
DataTable dt = new DataTable();
P.Producto = txtBuscarProducto.Text;
dt = P.BusquedaProductos(P.Producto);
try
{
dataGridView1.Rows.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
dataGridView1.Rows.Add(dt.Rows[i][0]);
dataGridView1.Rows[i].Cells[0].Value = dt.Rows[i][0].ToString();
dataGridView1.Rows[i].Cells[1].Value = dt.Rows[i][1].ToString();
dataGridView1.Rows[i].Cells[2].Value = dt.Rows[i][2].ToString();
dataGridView1.Rows[i].Cells[3].Value = dt.Rows[i][3].ToString();
dataGridView1.Rows[i].Cells[4].Value = dt.Rows[i][4].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
dataGridView1.ClearSelection();
}
else
{
CargarListado();
}
}