I am using dynamic list to populate drop down..Below is the code I am using..

public static DataTable GetRoles() { //RoleCollection roles = new RoleCollection(); //roles.GetMulti(null); //return roles;

        ResultsetFields fields = new ResultsetFields(2);
        fields.DefineField(RoleFieldIndex.Id, 0, "Id", "Id");
        fields.DefineField(RoleFieldIndex.RoleDesc, 0, "RoleDesc", "RoleDesc");
        DataTable results = new DataTable();

        TypedListDAO dao = new TypedListDAO();
        //TypedListDAO();

        dao.GetMultiAsDataTable(fields, results, 0, null, null, null, true, null, null, 0, 0);


       // dao.GetMultiAsDataTable(fields, tlist, 0, null, null, null, false, null, null, 0, 0);

        //dao.GetMultiAsDataTable(fields, tlist, 0, null, null, null, false, null, null, 0, 0);
        return results;
    } 

I am getting Object reference not set to an instance of an object error..

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

Line 53: public bool GetMultiAsDataTable(IEntityFields fieldsToReturn, DataTable tableToFill, long maxNumberOfItemsToReturn, ISortExpression sortClauses, IPredicate selectFilter, IRelationCollection relations, bool allowDuplicates, IGroupByCollection groupByClause, ITransaction transactionToUse, int pageNumber, int pageSize) Line 54: { Line 55: return base.PerformGetMultiAsDataTableAction(fieldsToReturn, tableToFill, maxNumberOfItemsToReturn, sortClauses, selectFilter, relations, allowDuplicates, groupByClause, transactionToUse, pageNumber, pageSize); Line 56: } Line 57:

Source File: C:\Documents and Settings\My Documents\Visual Studio 2005\Projects\TestWebAppFramework\Library\DAL\Generated LLBlGen\DaoClasses\TypedListDAO.cs Line: 55

Stack Trace:

[NullReferenceException: Object reference not set to an instance of an object.] SD.LLBLGen.Pro.DQE.SqlServer.DynamicQueryEngine.CreateSelectDQ(IEntityFieldCore[] selectList, IFieldPersistenceInfo[] fieldsPersistenceInfo, IDbConnection connectionToUse, IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relationsToWalk, Boolean allowDuplicates, IGroupByCollection groupByClause, Boolean relationsSpecified, Boolean sortClausesSpecified) +384 SD.LLBLGen.Pro.ORMSupportClasses.DynamicQueryEngineBase.CreateSelectDQ(IEntityFieldCore[] selectList, IFieldPersistenceInfo[] fieldsPersistenceInfo, IDbConnection connectionToUse, IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relationsToWalk, Boolean allowDuplicates, IGroupByCollection groupByClause) +258 SD.LLBLGen.Pro.DQE.SqlServer.DynamicQueryEngine.CreatePagingSelectDQ(IEntityFieldCore[] selectList, IFieldPersistenceInfo[] fieldsPersistenceInfo, IDbConnection connectionToUse, IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relationsToWalk, Boolean allowDuplicates, IGroupByCollection groupByClause, Int32 pageNumber, Int32 pageSize) +118 SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.PerformGetMultiAsDataTableAction(IEntityFields fieldsToReturn, DataTable tableToFill, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IPredicate selectFilter, IRelationCollection relations, Boolean allowDuplicates, IGroupByCollection groupByClause, ITransaction transactionToUse, Int32 pageNumber, Int32 pageSize) +503 DHHS.Core.DAL.DaoClasses.TypedListDAO.GetMultiAsDataTable(IEntityFields fieldsToReturn, DataTable tableToFill, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IPredicate selectFilter, IRelationCollection relations, Boolean allowDuplicates, IGroupByCollection groupByClause, ITransaction transactionToUse, Int32 pageNumber, Int32 pageSize) in C:\Documents and Settings\VemulapalliS\My Documents\Visual Studio 2005\Projects\TestWebAppFramework\Library\DAL\Generated LLBlGen\DaoClasses\TypedListDAO.cs:55 TempSvc.BL.UserManager.GetRoles() in C:\WebProjects\TempSvc\TempSvc.BL\UserManager.cs:66 ASP.content_pages_userinfo_aspx.__DataBinding__control22(Object sender, EventArgs e) in c:\WebProjects\TempSvc\Web Site\Content Pages\UserInfo.aspx:39 System.Web.UI.Control.OnDataBinding(EventArgs e) +80 System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) +11 System.Web.UI.WebControls.ListControl.PerformSelect() +18 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +68 System.Web.UI.Control.DataBindChildren() +214 System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +208 System.Web.UI.Control.DataBind() +12 System.Web.UI.Control.DataBindChildren() +214 System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +208 System.Web.UI.Control.DataBind() +12 System.Web.UI.Control.DataBindChildren() +214 System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +208 System.Web.UI.Control.DataBind() +12 System.Web.UI.Control.DataBindChildren() +214 System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +208 System.Web.UI.Control.DataBind() +12 System.Web.UI.Control.DataBindChildren() +214 System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +208 System.Web.UI.Control.DataBind() +12 System.Web.UI.Control.DataBindChildren() +214 System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +208 System.Web.UI.Control.DataBind() +12 System.Web.UI.Control.DataBindChildren() +214 System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +208 System.Web.UI.Control.DataBind() +12 System.Web.UI.Control.DataBindChildren() +214 System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +208 System.Web.UI.Control.DataBind() +12 System.Web.UI.Control.DataBindChildren() +214 System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +208 System.Web.UI.Control.DataBind() +12 Telerik.WebControls.GridEditFormItem.SetupItem(Boolean dataBind, Object dataItem, GridColumn[] columns, ControlCollection rows) +62 Telerik.WebControls.GridTableView.x2ac21ef4afead272(IEnumerator x2f53dbd7a1295c54, Int32 xfd9017be40b261df, String x5cbad4927f8ababf, Boolean x1d6de969ca316e6c, GridColumn[] x36e1b76c73efe327, ControlCollection xe477cc01ecfef1fb) +3038 Telerik.WebControls.GridTableView.CreateControlHierarchy(Boolean useDataSource) +2471 Telerik.WebControls.GridTableView.CreateChildControls(IEnumerable dataSource, Boolean useDataSource) +99 System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) +59 System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) +101 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +25 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +139 Telerik.WebControls.GridTableView.PerformSelect() +5 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +68 Telerik.WebControls.GridTableView.DataBind() +257 Telerik.WebControls.GridTableView.Rebind() +55 Telerik.WebControls.GridCommandEventArgs.ExecuteCommand(Object source) +1061 Telerik.WebControls.RadGrid.OnBubbleEvent(Object source, EventArgs e) +25 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 Telerik.WebControls.GridItem.OnBubbleEvent(Object source, EventArgs e) +88 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +86 System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +156 System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +172 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4919

You defined a result set with 2 columns. Then, you defined a field for the first column and overwrote that field when you defined your second field by placing it in index 0. Thus, there was no field at index 1.

// Try this... fields.DefineField(RoleFieldIndex.RoleDesc, 1, "RoleDesc", "RoleDesc");

// Instead of your line... fields.DefineField(RoleFieldIndex.RoleDesc, 0, "RoleDesc", "RoleDesc");

Thank You. It worked.