private void txt_Manufacturer_TextChanged(object sender, TextChangedEventArgs e)
 {
     connect = new CTUConnection();                      // refreshens the 'CTUConnection' class //
     connect.Selectparts();                              //*Selects the specified columns in the Patient table*//
     connect.SearchPartsManufact(txt_Manufacturer.Text); //Searches the customer's 'name' within the populated table//
     DGV_Parts.ItemsSource = connect.dataset;            //*All the selected fields are filtered inside the table and stored inside the grid-view*//
 }