private void txtSearch_TextChanged(object sender, EventArgs e) { try { if (txtSearch.Text == String.Empty) { return; } else { cn.Open(); cm = new SqlCommand("select * from tblProduct where barcode like '" + txtSearch.Text + "'", cn); dr = cm.ExecuteReader(); dr.Read(); if (dr.HasRows) { formQty frm = new formQty(this); frm.ProductDetails(dr["pcode"].ToString(), double.Parse(dr["price"].ToString()), lblTransaction.Text); dr.Close(); cn.Close(); frm.ShowDialog(); } else { dr.Close(); cn.Close(); } } } catch (Exception ex) { cn.Close(); MessageBox.Show(ex.Message, stitle, MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { string colName = dataGridView1.Columns[e.ColumnIndex].Name; if (colName == "Select") { formQty frm = new formQty(fpos); frm.ProductDetails(dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString(), Double.Parse(dataGridView1.Rows[e.RowIndex].Cells[6].Value.ToString()), fpos.lblTransaction.Text); frm.ShowDialog(); } }