private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
string ColName = dataGridView1.Columns[e.ColumnIndex].Name;
if (ColName == "Select")
{
QtyForm qf = new QtyForm(posform);
qf.ProductDetails(dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString(), Double.Parse(dataGridView1.Rows[e.RowIndex].Cells[7].Value.ToString()), posform.TransNoLbl.Text, int.Parse(dataGridView1.Rows[e.RowIndex].Cells[8].Value.ToString()));
qf.ShowDialog();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void SearchTb_TextChanged(object sender, EventArgs e)
{
try
{
if (SearchTb.Text == String.Empty)
{
return;
}
else
{
connect.Open();
command = new MySqlCommand("SELECT * FROM producttbl WHERE barcode like '" + SearchTb.Text + "'", connect);
DataReader = command.ExecuteReader();
DataReader.Read();
if (DataReader.HasRows)
{
qty = int.Parse(DataReader["qty"].ToString());
QtyForm qf = new QtyForm(this);
qf.ProductDetails(DataReader["pcode"].ToString(), double.Parse(DataReader["price"].ToString()), TransNoLbl.Text, qty);
DataReader.Close();
connect.Close();
qf.ShowDialog();
}
else
{
DataReader.Close();
connect.Close();
}
}
}
catch (Exception ex)
{
connect.Close();
MessageBox.Show(ex.Message, stitle, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}