protected void btnSearch_Click(object sender, EventArgs e) { String Name; String Permit; String Address; Name = txtSearchName.Text; Name = Name.ToUpper(); Permit = txtSearchPermit.Text; Permit = Permit.ToUpper(); Address = txtSearchAddress.Text; Address = Address.ToUpper(); OleDbConnection conn; using (conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString)) { if (txtSearchName.Text != "") { try { string SqlQ = "SELECT * FROM Overview WHERE [Full_Name] =@Name"; OleDbCommand command = new OleDbCommand(SqlQ, conn); conn.Open(); command.Parameters.Add("@Name", OleDbType.VarChar).Value = txtSearchName.Text.Trim(); command.Parameters["@Name"].Value = Name; OleDbDataReader reader = command.ExecuteReader(); reader.Read(); txtPermit.Text = (reader["Permit_Number"].ToString()); txtCove.Text = reader["Cove"].ToString(); txtDockExp.Text = reader["Dock_Expiration"].ToString(); txtElectrical.Text = reader["Electrical"].ToString(); txtEexpiration.Text = reader["E_Expiration"].ToString(); txtEncroachment.Text = reader["Encroachment_Status"].ToString(); txtEType.Text = reader["E_Type"].ToString(); txtLandUse.Text = reader["Land_Use_Text"].ToString(); txtLexpiration.Text = reader["L_Expiration"].ToString(); txtLType.Text = reader["L_Type"].ToString(); txtMowing.Text = reader["Mowing_Text"].ToString(); txtName.Text = reader["Full_Name"].ToString(); txtWater.Text = reader["Water"].ToString(); txtWaterType.Text = reader["Water_Type"].ToString(); txtWExpiration.Text = reader["W_Expiration"].ToString(); txtwORB.Text = reader["W_ORB_Number"].ToString(); if (reader["Land_Use"].Equals(true)) { radLandUseYes.Checked = true; } else { radLandUseNo.Checked = true; } if (reader["Electrical"].Equals(true)) { radElectricalYes.Checked = true; } else { radElectricalNo.Checked = true; } if (reader["E_Affidavit"].Equals(true)) { radAffidavitYes.Checked = true; } else { radAffidavitNo.Checked = true; } if (reader["Mowing"].Equals(true)) { radMowingYes.Checked = true; } else { radMowingNo.Checked = true; } SqlQ = "SELECT * FROM Dock WHERE [Name] =@Name"; command = new OleDbCommand(SqlQ, conn); command.Parameters.Add("@Name", OleDbType.VarChar).Value = txtSearchName.Text.Trim(); command.Parameters["@Name"].Value = Name; reader = command.ExecuteReader(); reader.Read(); txtLastInspection.Text = reader["Last_Inspection"].ToString(); txtNumOfSlips.Text = reader["Number_of_Slips"].ToString(); txtNotes.Text = reader["Notes"].ToString(); txtSize.Text = reader["Craft_Size"].ToString(); txtDockType.Text = reader["Dock_Type"].ToString(); if (reader["Sundeck"].Equals(true)) { radSundeckYes.Checked = true; } else { radSundeckNo.Checked = true; } if (reader["Shoreline_Usage"].Equals(true)) { radShorelineUsageYes.Checked = true; } else { radShorelineUsageNo.Checked = true; } if (reader["Covered"].Equals(true)) { radCoveredYes.Checked = true; } else { radCoveredNo.Checked = true; } if (reader["Enclosed_Dock"].Equals(true)) { radEnclosedYes.Checked = true; } else { radEnclosedNo.Checked = true; } SqlQ = "SELECT * FROM Contact WHERE [Name] =@Name"; command = new OleDbCommand(SqlQ, conn); command.Parameters.Add("@Name", OleDbType.VarChar).Value = txtSearchName.Text.Trim(); command.Parameters["@Name"].Value = Name; reader = command.ExecuteReader(); reader.Read(); txtState.Text = reader["State"].ToString(); txtAltState.Text = reader["Alternate_State"].ToString(); txtAddress.Text = reader["Address"].ToString(); txtAltAddress.Text = reader["Alternate_Address"].ToString(); txtCity.Text = reader["City"].ToString(); txtAltCity.Text = reader["Alternate_City"].ToString(); txtZipCode.Text = reader["Zip_Code"].ToString(); txtAltZipCode.Text = reader["Alternate_Zip_Code"].ToString(); txtPhone.Text = reader["Phone"].ToString(); txtAltPhone.Text = reader["Alternate_Phone"].ToString(); txtEmail.Text = reader["Email"].ToString(); txtAltEmail.Text = reader["Alternate_Email"].ToString(); } catch (InvalidOperationException) { ClientScript.RegisterStartupScript(this.GetType(), "myalert", "Error: That name doesn't exist!"); } } else if (txtSearchAddress.Text != "") { try { string SqlQ = "SELECT * FROM Overview WHERE [Address] =@Address"; OleDbCommand command = new OleDbCommand(SqlQ, conn); conn.Open(); command.Parameters.Add("@Address", OleDbType.VarChar).Value = txtSearchAddress.Text.Trim(); command.Parameters["@Address"].Value = Address; OleDbDataReader reader = command.ExecuteReader(); reader.Read(); txtPermit.Text = (reader["Permit_Number"].ToString()); txtCove.Text = reader["Cove"].ToString(); txtDockExp.Text = reader["Dock_Expiration"].ToString(); txtElectrical.Text = reader["Electrical"].ToString(); txtEexpiration.Text = reader["E_Expiration"].ToString(); txtEncroachment.Text = reader["Encroachment_Status"].ToString(); txtEType.Text = reader["E_Type"].ToString(); txtLandUse.Text = reader["Land_Use_Text"].ToString(); txtLexpiration.Text = reader["L_Expiration"].ToString(); txtLType.Text = reader["L_Type"].ToString(); txtMowing.Text = reader["Mowing_Text"].ToString(); txtName.Text = reader["Full_Name"].ToString(); txtWater.Text = reader["Water"].ToString(); txtWaterType.Text = reader["Water_Type"].ToString(); txtWExpiration.Text = reader["W_Expiration"].ToString(); txtwORB.Text = reader["W_ORB_Number"].ToString(); if (reader["Land_Use"].Equals(true)) { radLandUseYes.Checked = true; } else { radLandUseNo.Checked = true; } if (reader["Electrical"].Equals(true)) { radElectricalYes.Checked = true; } else { radElectricalNo.Checked = true; } if (reader["E_Affidavit"].Equals(true)) { radAffidavitYes.Checked = true; } else { radAffidavitNo.Checked = true; } if (reader["Mowing"].Equals(true)) { radMowingYes.Checked = true; } else { radMowingNo.Checked = true; } SqlQ = "SELECT * FROM Dock WHERE [Address] =@Address"; command = new OleDbCommand(SqlQ, conn); command.Parameters.Add("@Address", OleDbType.VarChar).Value = txtSearchAddress.Text.Trim(); command.Parameters["@Address"].Value = Address; reader = command.ExecuteReader(); reader.Read(); txtLastInspection.Text = reader["Last_Inspection"].ToString(); txtNumOfSlips.Text = reader["Number_of_Slips"].ToString(); txtNotes.Text = reader["Notes"].ToString(); txtSize.Text = reader["Craft_Size"].ToString(); txtDockType.Text = reader["Dock_Type"].ToString(); if (reader["Sundeck"].Equals(true)) { radSundeckYes.Checked = true; } else { radSundeckNo.Checked = true; } if (reader["Shoreline_Usage"].Equals(true)) { radShorelineUsageYes.Checked = true; } else { radShorelineUsageNo.Checked = true; } if (reader["Covered"].Equals(true)) { radCoveredYes.Checked = true; } else { radCoveredNo.Checked = true; } if (reader["Enclosed_Dock"].Equals(true)) { radEnclosedYes.Checked = true; } else { radEnclosedNo.Checked = true; } SqlQ = "SELECT * FROM Contact WHERE [Address] =@Address"; command = new OleDbCommand(SqlQ, conn); command.Parameters.Add("@Address", OleDbType.VarChar).Value = txtSearchAddress.Text.Trim(); command.Parameters["@Address"].Value = Address; reader = command.ExecuteReader(); reader.Read(); txtState.Text = reader["State"].ToString(); txtAltState.Text = reader["Alternate_State"].ToString(); txtAddress.Text = reader["Address"].ToString(); txtAltAddress.Text = reader["Alternate_Address"].ToString(); txtCity.Text = reader["City"].ToString(); txtAltCity.Text = reader["Alternate_City"].ToString(); txtZipCode.Text = reader["Zip_Code"].ToString(); txtAltZipCode.Text = reader["Alternate_Zip_Code"].ToString(); txtPhone.Text = reader["Phone"].ToString(); txtAltPhone.Text = reader["Alternate_Phone"].ToString(); txtEmail.Text = reader["Email"].ToString(); txtAltEmail.Text = reader["Alternate_Email"].ToString(); } catch (InvalidOperationException) { ClientScript.RegisterStartupScript(this.GetType(), "myalert", "Error: That Address doesn't exist!"); } } else if (txtSearchPermit.Text != "") { try { string SqlQ = "SELECT * FROM Overview WHERE [Permit_Number] =@Permit"; OleDbCommand command = new OleDbCommand(SqlQ, conn); conn.Open(); command.Parameters.Add("@Permit", OleDbType.VarChar).Value = txtSearchPermit.Text.Trim(); command.Parameters["@Permit"].Value = Permit; OleDbDataReader reader = command.ExecuteReader(); reader.Read(); txtPermit.Text = (reader["Permit_Number"].ToString()); txtCove.Text = reader["Cove"].ToString(); txtDockExp.Text = reader["Dock_Expiration"].ToString(); txtElectrical.Text = reader["Electrical"].ToString(); txtEexpiration.Text = reader["E_Expiration"].ToString(); txtEncroachment.Text = reader["Encroachment_Status"].ToString(); txtEType.Text = reader["E_Type"].ToString(); txtLandUse.Text = reader["Land_Use_Text"].ToString(); txtLexpiration.Text = reader["L_Expiration"].ToString(); txtLType.Text = reader["L_Type"].ToString(); txtMowing.Text = reader["Mowing_Text"].ToString(); txtName.Text = reader["Full_Name"].ToString(); txtWater.Text = reader["Water"].ToString(); txtWaterType.Text = reader["Water_Type"].ToString(); txtWExpiration.Text = reader["W_Expiration"].ToString(); txtwORB.Text = reader["W_ORB_Number"].ToString(); if (reader["Land_Use"].Equals(true)) { radLandUseYes.Checked = true; } else { radLandUseNo.Checked = true; } if (reader["Electrical"].Equals(true)) { radElectricalYes.Checked = true; } else { radElectricalNo.Checked = true; } if (reader["E_Affidavit"].Equals(true)) { radAffidavitYes.Checked = true; } else { radAffidavitNo.Checked = true; } if (reader["Mowing"].Equals(true)) { radMowingYes.Checked = true; } else { radMowingNo.Checked = true; } SqlQ = "SELECT * FROM Dock WHERE [Permit_Number] =@Permit"; command = new OleDbCommand(SqlQ, conn); command.Parameters.Add("@Permit", OleDbType.VarChar).Value = txtSearchPermit.Text.Trim(); command.Parameters["@Permit"].Value = Permit; reader = command.ExecuteReader(); reader.Read(); txtLastInspection.Text = reader["Last_Inspection"].ToString(); txtNumOfSlips.Text = reader["Number_of_Slips"].ToString(); txtNotes.Text = reader["Notes"].ToString(); txtSize.Text = reader["Craft_Size"].ToString(); txtDockType.Text = reader["Dock_Type"].ToString(); if (reader["Sundeck"].Equals(true)) { radSundeckYes.Checked = true; } else { radSundeckNo.Checked = true; } if (reader["Shoreline_Usage"].Equals(true)) { radShorelineUsageYes.Checked = true; } else { radShorelineUsageNo.Checked = true; } if (reader["Covered"].Equals(true)) { radCoveredYes.Checked = true; } else { radCoveredNo.Checked = true; } if (reader["Enclosed_Dock"].Equals(true)) { radEnclosedYes.Checked = true; } else { radEnclosedNo.Checked = true; } SqlQ = "SELECT * FROM Contact WHERE [Permit_Number] =@Permit"; command = new OleDbCommand(SqlQ, conn); command.Parameters.Add("@Permit", OleDbType.VarChar).Value = txtSearchPermit.Text.Trim(); command.Parameters["@Permit"].Value = Permit; reader = command.ExecuteReader(); reader.Read(); txtState.Text = reader["State"].ToString(); txtAltState.Text = reader["Alternate_State"].ToString(); txtAddress.Text = reader["Address"].ToString(); txtAltAddress.Text = reader["Alternate_Address"].ToString(); txtCity.Text = reader["City"].ToString(); txtAltCity.Text = reader["Alternate_City"].ToString(); txtZipCode.Text = reader["Zip_Code"].ToString(); txtAltZipCode.Text = reader["Alternate_Zip_Code"].ToString(); txtPhone.Text = reader["Phone"].ToString(); txtAltPhone.Text = reader["Alternate_Phone"].ToString(); txtEmail.Text = reader["Email"].ToString(); txtAltEmail.Text = reader["Alternate_Email"].ToString(); } catch (InvalidOperationException) { ClientScript.RegisterStartupScript(this.GetType(), "myalert", "Error: That Permit Number doesn't exist!"); } } } }