private void FormUser_Load(object sender, EventArgs e) { //string conn = ConfigurationManager.ConnectionStrings["Test"].ConnectionString; //con = new SqlConnection(conn); //con.Open(); connect.SetConnection(); try { sql = "select StaffID,StaffName From tbStaff order by StaffID"; SqlCommand cd = new SqlCommand(sql, connect.con); SqlDataReader d = cd.ExecuteReader(); DataTable tbc = new DataTable(); tbc.Load(d); cboStaffID.DisplayMember = "StaffID"; cboStaffID.ValueMember = "StaffName"; cboStaffID.DataSource = tbc; sql = "select * from tbUser order by UserID"; SqlCommand cmd = new SqlCommand(sql, connect.con); SqlDataReader dr = cmd.ExecuteReader(); DataTable tb = new DataTable(); tb.Load(dr); dgvUser.DataSource = tb; dgvUser.Columns[0].Visible = false; dgvUser.Columns[1].HeaderText = "USER NAME"; dgvUser.Columns[2].HeaderText = "PASSWORD"; dgvUser.Columns[3].HeaderText = "STAFF'S ID"; txtUserID.Enabled = false; txtUserID.Text = "Auto Number"; status = "New"; cboStaffID.Focus(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void FrmInStock_Load(object sender, EventArgs e) { //SqlConnection con = new SqlConnection("Server=D8JZPCQ2;Database=dbPhoneShop;User ID=sa;Password=123"); //con.Open(); ConectionString con = new ConectionString(); con.SetConnection(); //Add date to combobox try { string sql = "Select * from tbProduct Order By ProductID"; SqlCommand cmd = new SqlCommand("spRunSQL", con.con); cmd.Parameters.AddWithValue("@sql", sql); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader dr = cmd.ExecuteReader(); DataTable tb = new DataTable(); tb.Load(dr); dgvProduct.DataSource = tb; // con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void FrmPayment_Load(object sender, EventArgs e) { conn.SetConnection(); txtTotalPrice.Cursor.Dispose(); txtPayment.Focus(); txtTotalPrice.ReadOnly = true; //SaleProduct sp = new SaleProduct(); //txtTotalPrice.Text = TotalPrice.ToString(); }
private void FrmSale_Load(object sender, EventArgs e) { conn.SetConnection(); //lbUserID.Text = sale.userID.ToString(); //sql = "select CustomerID from tbCustomer order by CustomerID"; //SqlCommand cmd = new SqlCommand(sql, conn.con); //SqlDataReader dr = cmd.ExecuteReader(); //DataTable tb = new DataTable(); //tb.Load(dr); //cboCustomerID.DisplayMember = "CustomerID"; //cboCustomerID.DataSource = tb; //cboCustomerID.SelectedItem = null; dgvSale.Columns.Add("ProductID", "PRODUCT No"); dgvSale.Columns.Add("ProductName", "PRODUCT'S NAME"); dgvSale.Columns.Add("SaleQty", "QTY"); // dgvSale.Columns.Add("CustomerID", "CUSTOMER'S ID"); dgvSale.Columns.Add("Unit_Price", "UNIT PRICE"); dgvSale.Columns.Add("Total", "TOTAL"); // dgvSale.Columns.Add("UserID", "USER'S ID"); // dgvSale.Columns.Add("Discount", "DISCOUNT"); dgvSale.Columns[0].Width = 100; dgvSale.Columns[1].Width = 150; dgvSale.Columns[2].Width = 100; dgvSale.Columns[3].Width = 140; dgvSale.Columns[4].Width = 140; //dgvSale.Columns[5].Width = 125; rdbtnUs.Checked = true; dgvSale.Enabled = false; dgvSale.Columns[0].Visible = false; lbDate.Text = DateTime.Now.ToString("dd MMMM, yyyy"); lbTime.BackColor = Color.Blue; lbTime.ForeColor = Color.White; lbDate.ForeColor = Color.Blue; }