C# (CSharp) Enumeraties.sorteervolgorde Examples

Example #1

File: Cursus.cs Project: jandedeurwaerder-howest/storedProcedureDemo

 public static DataTable GetCursussen(string sorteerveld, Enumeraties.sorteervolgorde sortorder)
 {
     SqlParameter[] sp = new SqlParameter[2];
     sp[0] = new SqlParameter();
     sp[0].ParameterName = "@sorteerVeld";
     sp[0].Value         = sorteerveld;
     sp[1] = new SqlParameter();
     sp[1].ParameterName = "@sorteerVolgorde";
     if (sortorder == Enumeraties.sorteervolgorde.ASC)
     {
         sp[1].Value = "ASC";
     }
     else
     {
         sp[1].Value = "DESC";
     }
     return(DBGeneral.ExecuteSPWithDataTable("CursussenSelectAll", sp));
 }

Example #2

File: MainWindow.xaml.cs Project: jandedeurwaerder-howest/storedProcedureDemo

 private void vuldgrCursussen(string sorteerveld, Enumeraties.sorteervolgorde sortorder)
 {
     dgrCursussen.ItemsSource = Cursus.GetCursussen("cursusnaam", sortorder).DefaultView;
 }