public void searchProductInventory()
{
try
{
dataGridStockAdjustment.Rows.Clear();
int i = 0;
using (MySqlDataReader reader = pos.SearchProductsAdjustment(txtSearch.text))
{
while (reader.Read())
{
i++;
dataGridStockAdjustment.Rows.Add(i, reader["products_id"].ToString(),
reader["barcode"].ToString(),
reader["brand_name"].ToString(),
reader["category_name"].ToString(),
reader["description"].ToString(),
reader["price"].ToString(),
reader["quantity"].ToString());
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
