示例#1
0
 private Infragistics.WebUI.UltraWebGrid.ValueList EmployeeRoles()
 {
     Infragistics.WebUI.UltraWebGrid.ValueList vList = new Infragistics.WebUI.UltraWebGrid.ValueList();
     // Add Items
     vList.ValueListItems.Add("Engineer", "Engineer");
     vList.ValueListItems.Add("Project Manager", "Project Manager");
     //
     return vList;
 }
示例#2
0
 private Infragistics.WebUI.UltraWebGrid.ValueList EmployeeTypes()
 {
     Infragistics.WebUI.UltraWebGrid.ValueList vList = new Infragistics.WebUI.UltraWebGrid.ValueList();
     // Add Blank Row
     vList.ValueListItems.Add(0, "");
     // Get rest of items
     string strSQL = null;
     strSQL = "SELECT ID, EmployeeType ";
     strSQL += "FROM tblEmployeeTypes ";
     strSQL += "WHERE EmployeeType <> 'Admin'";
     SqlConnection conn = new SqlConnection(strConn);
     SqlCommand cmd = new SqlCommand(strSQL, conn);
     conn.Open();
     SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
     while (dr.Read())
     {
         vList.ValueListItems.Add(dr.GetValueOrDefault<int>("ID"), dr.GetValueOrDefault<string>("EmployeeType"));
     }
     dr.Close();
     conn = null;
     cmd = null;
     dr = null;
     //
     return vList;
 }