private void btnDelete_Click(object sender, EventArgs e) { Int32 intPerson_ID = Convert.ToInt32(lblPerson_ID.Text); //Get the ID from the Label //Create a EBook so we can use the delete method PersonV2 temp = new PersonV2(); //Use the EBook ID and pass it to the delete function // and get the number of records deleted lblFeedback.Text = temp.DeleteOnePerson(intPerson_ID); }
private void btnSearch_Click(object sender, EventArgs e) { //Get Data PersonV2 temp = new PersonV2(); //Perform the search we created in EBook class and store the returned dataset DataSet ds = temp.SearchPersons(txtFName.Text, txtMName.Text, txtLName.Text, txtStreet1.Text, txtStreet2.Text, txtCity.Text, txtState.Text, txtZipcode.Text, txtPhone.Text, txtEmail.Text, txtCellphone.Text, txtInstagram.Text); //Display data (dataset) dgvResults.DataSource = ds; //point datagrid to dataset dgvResults.DataMember = ds.Tables["Persons_Temp"].ToString(); // What table in the dataset? }
public Form1(int intPerson_ID) { InitializeComponent(); btnSubmit.Visible = false; //Gather info about this one person and store it in a datareader PersonV2 temp = new PersonV2(); SqlDataReader dr = temp.FindOnePerson(intPerson_ID); //Use that info to fill out the form //Loop thru the records stored in the reader 1 record at a time // Note that since this is based on one person's ID, then we // should only have one record while (dr.Read()) { //Take the Name(s) from the datareader and copy them // into the appropriate text fields txtfName.Text = dr["FirstName"].ToString(); txtmName.Text = dr["MiddleName"].ToString(); txtlName.Text = dr["LastName"].ToString(); txtStreet.Text = dr["Street1"].ToString(); txtStreet2.Text = dr["Street2"].ToString(); txtcity.Text = dr["City"].ToString(); txtstate.Text = dr["State"].ToString(); txtzipcode.Text = dr["Zipcode"].ToString(); txtphone.Text = dr["Phone"].ToString(); txtemail.Text = dr["Email"].ToString(); txtcellphone.Text = dr["Cellphone"].ToString(); txtinstaURL.Text = dr["Instagram"].ToString(); lblPerson_ID.Text = dr["Person_ID"].ToString(); //We added this one to store the ID in a new label lblPerson_ID.Text = dr["Person_ID"].ToString(); } }