private void LoadCustomers() { clsSqlServer obj = new clsSqlServer(); DataSet objDataset = obj.getCustomers(); //bind the data to the UI dtgCustomers.DataSource = objDataset.Tables[0]; }
private void DisplayCustomer(string CustomerCode) { clsSqlServer obj = new clsSqlServer(); DataSet objDataset = obj.getCustomers(CustomerCode); //Select the records and display it on the screen string strCustomerName = objDataset.Tables[0].Rows[0][0].ToString(); string strCountryName = objDataset.Tables[0].Rows[0][1].ToString(); string strgender = objDataset.Tables[0].Rows[0][2].ToString(); string strhobbies = objDataset.Tables[0].Rows[0][3].ToString(); bool Married = false; if (objDataset.Tables[0].Rows[0][4] != DBNull.Value) { Married = Convert.ToBoolean(objDataset.Tables[0].Rows[0][4]); } txtCustomerName.Text = strCustomerName; cboCountry.Text = strCountryName; if ((strgender.Length == 0) || (strgender == "Male")) { rdoMale.Checked = true; } else { rdoFemale.Checked = true; } //hoobies boolean if ((strhobbies.Length == 0) || (strgender == "Sports")) { chkReading.Checked = true; } else { chkSports.Checked = true; } //status boolean if (Married) { rdoMarried.Checked = true; } else { rdoUnmarried.Checked = true; } }
private void btnSearch_Click(object sender, EventArgs e) { clsSqlServer objSql = new clsSqlServer(); DataSet objDataset = objSql.getCustomers(); datagridSearch.DataSource = objDataset.Tables[0]; }