private void btnDelete_Click(object sender, EventArgs e) { clsSqlServer obj = new clsSqlServer(); obj.DeleteCustomer(txtCustomerName.Text); LoadCustomers(); }
private void loadCustomers() { clsSqlServer custObj = new clsSqlServer(); GridCustomers.DataSource = custObj.getCustomers(); // DATA SOURCE set GridCustomers.DataBind(); // bind data to grid }
private void btnSearch_Click(object sender, EventArgs e) { clsSqlServer objSql = new clsSqlServer(); DataSet objDataset = objSql.getCustomers(); datagridSearch.DataSource = objDataset.Tables[0]; }
private void LoadCustomers() { clsSqlServer obj = new clsSqlServer(); DataSet objDataset = obj.getCustomers(); //bind the data to the UI dtgCustomers.DataSource = objDataset.Tables[0]; }
// Then create public set and get properties public void save() { // we will make a call to Data Access Layer to Insert //these value to SQL Server clsSqlServer obj = new clsSqlServer(); obj.InsertCustomer(_CustomerName, _CountryName, _Gender, _Hobbies, _Email, _IsMarried); }
protected void btnDelete_Click(object sender, EventArgs e) { // Here the delete logic will go clsSqlServer obj = new clsSqlServer(); obj.DeleteCustomer(txtCustomerName.Text); ClearData(); // Clear the selected customer data loadCustomers(); // Loading the grid again }
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; } }
public void save() { clsSqlServer objSave = new clsSqlServer(); objSave.InsertCustomer(_CustomerName, _CountryName, _Gender, _Hobbies, _IsMarried, _Email); }
public void update() { clsSqlServer objUpdate = new clsSqlServer(); objUpdate.UpdateCustomer(_CustomerName, _CountryName, _Gender, _Hobbies, _IsMarried, _Email); }
private void displayCustomer(string custname) { clsSqlServer custObj = new clsSqlServer(); DataSet objDataset = custObj.getCustomers(custname); // 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 strGenderName = objDataset.Tables[0].Rows[0][2].ToString(); string strHobbiesName = objDataset.Tables[0].Rows[0][3].ToString(); string strEmail = objDataset.Tables[0].Rows[0][4].ToString(); bool StatusName = false; if (objDataset.Tables[0].Rows[0][5] != DBNull.Value) // use bdnull instead of null when we use ado.net, dataset { StatusName = Convert.ToBoolean(objDataset.Tables[0].Rows[0][5].ToString()); } txtCustomerName.Text = strCustomerName; ddlCountries.Text = strCountryName; txtEmail.Text = strEmail; // Gender //string strGenderName = objDataset.Tables[0].Rows[0][2].ToString(); if (strGenderName == "Male") { male.Checked = true; } else { Female.Checked = true; } // Hobbies if (strHobbiesName == "Reading") { Reading.Checked = true; } else { Painting.Checked = true; } // Married if (StatusName) { Married.Checked = true; } else { Unmarried.Checked = true; } // Close the connection //objConnection.Close(); }
public bool isValid() { clsSqlServer obj = new clsSqlServer(); if (obj.getUser(userName, password).Tables[0].Rows.Count == 0) { return(false); } else { return(true); } }
public bool isValid() { clsSqlServer obj = new clsSqlServer(); // if we have not found username, and password // if this dataset return by the getUser function is not having any rows if (obj.getUser(userName, passWord).Tables[0].Rows.Count == 0) { return(false); } else { return(true); } }
private void btnUpdate_Click(object sender, EventArgs e) { //UPDATING edited records. //COMMAND INSERT FIRE string gender = ""; string hobbies = ""; string status = ""; if (rdoMale.Checked) { gender = "Male"; } else { gender = "Female"; } if (chkReading.Checked) { hobbies = "Reading"; } else { hobbies = "Sports"; } if (rdoMarried.Checked) { status = "1"; } else { status = "0"; } clsSqlServer objUpdate = new clsSqlServer(); objUpdate.UpdateCustomer(txtCustomerName.Text, cboCountry.Text, gender, hobbies, status); ClearData(); LoadCustomers(); }
protected void btnAdd_Click(object sender, EventArgs e) { // Create a preview Form Object string sex = ""; string hobbies = ""; string email = ""; bool status = false; //Gender selection grab value if (male.Checked) { sex = "Male"; } else { sex = "Female"; } // Hobbies selection grab value if (Painting.Checked) { hobbies = "Painting"; } else { hobbies = "Reading"; } //Status selection grab value if (Married.Checked) { status = true; } else { status = false; } // ADO.net code which will insert data to sql server email = txtEmail.Text; clsSqlServer insertObj = new clsSqlServer(); insertObj.InsertCustomer(txtCustomerName.Text, ddlCountries.Text, sex, hobbies, txtEmail.Text, status); loadCustomers(); ClearData(); }
protected void btnEdit_Click(object sender, EventArgs e) { // Here the update logic will go // Lets do some code for update operation string email = ""; string sex = ""; string hobbies = ""; bool status = false; //Gender selection grab value if (male.Checked) { sex = "Male"; } else { sex = "Female"; } // Hobbies selection grab value if (Painting.Checked) { hobbies = "Painting"; } else { hobbies = "Reading"; } //Status selection grab value if (Married.Checked) { status = true; } else { status = false; } // ADO.net code which will insert to sql server clsSqlServer obj = new clsSqlServer(); //obj.UpdateCustomer(txtCustomerName.Text, ddlcoun.Text, sex, hobbies, status); email = txtEmail.Text; obj.UpdateCustomer(txtCustomerName.Text, ddlCountries.Text, sex, hobbies, email, status); loadCustomers(); }
private void btnAdd_Click(object sender, EventArgs e) { string gender = ""; string hobbies = ""; string status = ""; if (rdoMale.Checked) { gender = "Male"; } else { gender = "Female"; } if (chkReading.Checked) { hobbies = "Reading"; } else { hobbies = "Sports"; } if (rdoMarried.Checked) { status = "1"; } else { status = "0"; } clsSqlServer objInsert = new clsSqlServer(); objInsert.InsertCustomer(txtCustomerName.Text, cboCountry.Text, gender, hobbies, status); ClearData(); LoadCustomers(); }
public DataSet LoadCustomer(string CustomerName) { clsSqlServer obj = new clsSqlServer(); return(obj.getCustomers(CustomerName)); }
public DataSet loadCustomer(string strCustomerName) { clsSqlServer objSql = new clsSqlServer(); return(objSql.getCustomer(strCustomerName)); }
public DataSet getCountries() { clsSqlServer obj = new clsSqlServer(); return(obj.getCountries()); }
public DataSet loadCustomer() { clsSqlServer objSql = new clsSqlServer(); return(objSql.getCustomer()); }
public void DeleteCustomer(string CustomerName) { clsSqlServer obj = new clsSqlServer(); obj.DeleteCustomer(CustomerName); }
public void delete(string strCustomerName) { clsSqlServer objDelete = new clsSqlServer(); objDelete.DeleteCustomer(strCustomerName); }
public void UpdateCustomer(string CustomerName, string CountryName, string Gender, string Hobbies, string Email, bool IsMarried) { clsSqlServer obj = new clsSqlServer(); obj.UpdateCustomer(CustomerName, CountryName, Gender, Hobbies, Email, IsMarried); }
public DataSet getCustomers() { clsSqlServer obj = new clsSqlServer(); return(obj.getCustomers()); }