예제 #1
0
 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);
     }
 }
예제 #2
0
        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();
            }
        }