private void btnSearchCus_Click(object sender, EventArgs e) { DataTable tblCustomer = new DataTable(); tblCustomer = customer_bus.Display("Select * from Customer where CustomerName like +'%" + txtSearchCus.Text + "%'"); dataGridViewCustomer.DataSource = tblCustomer; }
private void CustomerManagement_Load(object sender, EventArgs e) { DataTable tblCustomer = new DataTable(); tblCustomer = customer_bus.Display("Select *from Customer"); dataGridViewCustomer.DataSource = tblCustomer; dataGridViewCustomer.AllowUserToAddRows = false; if (tblCustomer.Rows.Count == 0) { MessageBox.Show("There are no customers in list"); } else { txtCID.Text = dataGridViewCustomer.CurrentRow.Cells["CustomerID"].Value.ToString(); txtCName.Text = dataGridViewCustomer.CurrentRow.Cells["CustomerName"].Value.ToString(); txtCPhone.Text = dataGridViewCustomer.CurrentRow.Cells["PhoneNumber"].Value.ToString(); txtCEmail.Text = dataGridViewCustomer.CurrentRow.Cells["Email"].Value.ToString(); txtCAddress.Text = dataGridViewCustomer.CurrentRow.Cells["Address"].Value.ToString(); } }