public void BicycleMode() { TBikeDAL MyDAL = new TBikeDAL(); DetermineItemStatus(); DataTable ResultTable = MyDAL.SelectAllBicycleByDynamic(TBBicycleID.Text, TBBikeName2.Text, TBCurrentRenter.Text, TBBikeColor.Text, TBBikeStatus.Text, TBBikeType2.Text); Column1.Header = "Bicycle ID"; Column1.Binding = new Binding("BicycleID"); Column2.Header = "Bicycle Name"; Column2.Binding = new Binding("BicycleName"); Column3.Header = "Bicycle Type"; Column3.Binding = new Binding("BicycleType"); Column4.Header = "Bicycle Status"; Column4.Binding = new Binding("BicycleStatusInFull"); Column5.Header = "Current Renter"; Column5.Binding = new Binding("CurrentRenter"); Column6.Header = "Color"; Column6.Binding = new Binding("Color"); Column7.Header = "Total Rents"; Column7.Binding = new Binding("TotalRents"); Column8.Header = "Price (RM)"; Column8.Binding = new Binding("Price"); Column9.Header = "Condition"; Column9.Binding = new Binding("Condition"); Column10.Header = "CreatedBy"; Column10.Binding = new Binding("CreatedBy"); TBIkeUtility.TranslateRecordStatusDescription(new List <string> { "BicycleStatus" }, ref ResultTable); dataGrid1.ItemsSource = ResultTable.DefaultView; dataGrid1.IsReadOnly = true; dataGrid1.AutoGenerateColumns = false; }