private void roadSarchButton_Click(object sender, EventArgs e) { string lisenceNumber; lisenceNumber = searchLisenceTextBox.Text; roadPermitClass roadObj=null; string connectionString = @"server=DUET-559FE4FA51\SQLEXPRESS;integrated security = SSPI; database = VehicleInformationDB;"; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); string queryString = "SELECT * FROM roadInformationTable WHERE CarlisenceNumber='" + lisenceNumber + "'"; SqlCommand command = new SqlCommand(queryString, connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { roadObj = new roadPermitClass(); roadObj.TypeOfCar = (reader["typeOfCar"]).ToString(); typeOfCarComboBox.Text = (reader["typeOfCar"]).ToString(); roadObj.CarId = (reader["carId"]).ToString(); carIdTextBox.Text = (reader["carId"]).ToString(); roadObj.CarLisenceNumber = (reader["carLisenceNumber"]).ToString(); carLisenceNumbertextBox.Text = (reader["carLisenceNumber"]).ToString(); roadObj.RoadPermit = (reader["roadPermit"]).ToString(); carRoadPermitTextBox.Text = (reader["roadPermit"]).ToString(); } MessageBox.Show("typeOfCar="+roadObj.TypeOfCar+"\n carId="+roadObj.CarId+"\n carLisenceNumber="+roadObj.CarLisenceNumber+"\n \n roadPermit:"+roadObj.RoadPermit); connection.Close(); }
private void roadSaveButton_Click(object sender, EventArgs e) { roadPermitClass roadPermitObj = new roadPermitClass(); roadPermitObj.TypeOfCar = typeOfCarComboBox.Text; roadPermitObj.CarId = carIdTextBox.Text; roadPermitObj.CarLisenceNumber = carLisenceNumbertextBox.Text; roadPermitObj.RoadPermit = carRoadPermitTextBox.Text; roadInformationGetway getway = new roadInformationGetway(); getway.saveRoadInformation(roadPermitObj); MessageBox.Show("inforMation Save"); }