private void txt_Brand_TextChanged(object sender, TextChangedEventArgs e)
 {
     connect = new CTUConnection();            // refreshens the 'CTUConnection' class //
     connect.Selectparts();                    //*Selects the specified columns in the Patient table*//
     connect.SearchPartsBrand(txt_Brand.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*//
 }