private void btnSelect_Click(object sender, EventArgs e) { if (browseCustomer == null || browseCustomer.IsDisposed) { browseCustomer = new BrowseListing(1, this, true); } browseCustomer.Show(); }
//show listing to select show private void btnSelectShow_Click(object sender, EventArgs e) { if (showListing == null || showListing.IsDisposed) { showListing = new BrowseListing(3, this); } showListing.Show(); showListing.BringToFront(); }
//select customer from listing private void btnSelectCustomer_Click(object sender, EventArgs e) { if (browseCustomer == null || browseCustomer.IsDisposed) { browseCustomer = new BrowseListing(1, this); } browseCustomer.Show(); browseCustomer.BringToFront(); }
private void btnBrowse_Click(object sender, EventArgs e) { if (listings == null || listings.IsDisposed) { listings = new BrowseListing(0, this); } listings.Show(); listings.BringToFront(); }
private void btnSelectCustomer_Click(object sender, EventArgs e) { if (browseCustomer == null || browseCustomer.IsDisposed) { browseCustomer = new BrowseListing(1, this); } browseCustomer.Show(); browseCustomer.BringToFront(); //string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\\PineSpringsPottery.accdb"; //OleDbConnection connection = new OleDbConnection(connectionString); ////Open connection if not already //if (connection.State == ConnectionState.Closed) //{ // connection.Open(); //} //try //{ // string selectStatement = "SELECT StreetAddress, City, State,Zip" + " FROM CUSTOMER WHERE FirstName='" + firstNametextBox3.Text + "' AND LastName='" + lastNameTextBox.Text + "';"; // OleDbCommand subSelectCmd = new OleDbCommand(selectStatement, connection); // reader = subSelectCmd.ExecuteReader(); // while (reader.Read()) // { // string addressOutput = reader["StreetAddress"].ToString(); // string cityOutput = reader["City"].ToString(); // string State = reader["StreetAddress"].ToString(); // string Zip = reader["Zip"].ToString(); // listBox1.Items.Add(firstNametextBox3.Text); // listBox1.Items.Add(lastNameTextBox.Text); // listBox1.Items.Add(addressOutput); // listBox1.Items.Add(cityOutput); // listBox1.Items.Add(State); // listBox1.Items.Add(Zip); // listBox1.Items.Add(""); // } //} //catch //{ // MessageBox.Show("There must be text entered into both textboxes in order to work"); //} }