private void Customer_Load(object sender, EventArgs e) { FormBorderStyle = FormBorderStyle.None; WindowState = FormWindowState.Maximized; TopMost = false; dataGridView1.ColumnHeadersDefaultCellStyle.Font = new Font("Arial", 10); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; customerdb cdb = new customerdb(); dataGridView1.DataSource = cdb.selectall(); }
private void dataGridView1_SelectionChanged(object sender, EventArgs e) { try { int id = (int)dataGridView1.SelectedRows[0].Cells[0].Value; customerdb c = new customerdb(); DataTable dt = c.get(id); textBox1.Text = dt.Rows[0]["ID"].ToString().Trim(); textBox2.Text = dt.Rows[0]["Name"].ToString().Trim(); textBox3.Text = dt.Rows[0]["Phone"].ToString().Trim(); textBox5.Text = dt.Rows[0]["Address"].ToString().Trim(); } catch (Exception e1) { //MessageBox.Show(e1.Message); } }
private void Sales_Load(object sender, EventArgs e) { FormBorderStyle = FormBorderStyle.None; WindowState = FormWindowState.Maximized; TopMost = false; dataGridView2.ColumnHeadersDefaultCellStyle.Font = new Font("Arial", 10); dataGridView2.SelectionMode = DataGridViewSelectionMode.FullRowSelect; Salesdb sdb = new Salesdb(); dataGridView2.DataSource = sdb.selectall(); customerdb c = new customerdb(); comboBox2.DataSource = c.getForDropDown(); comboBox2.DisplayMember = "Name"; comboBox2.ValueMember = "ID"; comboBox2.AutoCompleteMode = AutoCompleteMode.Suggest; }