The issue here is to get data using a view VDbsBymachineEntity as in code below and bind it to a datagrid. I am using IPrefetchPath2 and getting data and in ascx i am binding the data.

should i use DataAccessAdapter , as i am getting an error when i run this

ERROR

+++++++++++++++++++++++++++++++ This DataAccessAdapter instance has already been disposed, you can't use it for further persistence activity Object name: 'DataAccessAdapterBase'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ObjectDisposedException: This DataAccessAdapter instance has already been disposed, you can't use it for further persistence activity Object name: 'DataAccessAdapterBase'. ++++++++++++++++++++++++++++++++++

This is the code and this binds to a datagrid on ascx page.

+++++++++++++++++++++++++++++++++++++++ protected void Page_Load(object sender, EventArgs e) { DataAccessAdapter ds = new DataAccessAdapter();

        GVAssignID2A.PageSize = 15;

        mList = new MachineEntity();
        ds.FetchEntity(mList);


        if (Filter == null)
        {
            IRelationPredicateBucket f;
            f = mList.GetRelationInfoSoftwareInstance();
            Filter = f;
        }

        IPrefetchPath2 p = new PrefetchPath2((int)EntityType.VDbsBymachineEntity);
        //p.Add(VDbsBymachineEntity.PrefetchPathAppAit);
        //p.Add(VDbsBymachineEntity.PrefetchPathApplication);

        ODSAssignID2A.PrefetchPathToUse = p;

        GVAssignID2A.DataBind();
    }

++++++++++++++++++++++++++++++++++++

ascx page is as below

========================================

<asp:GridView ID="GVAssignID2A" runat="server" AllowPaging="True" DataSourceID="ODSAssignID2A" PageSize="15" LivePersistence = "false" AutoGenerateColumns="False" DataKeyNames="MachineId" EnableViewState ="true" DataMember="DefaultView" ondatabound="GVAssignID2A_DataBound"> <Columns> <asp:TemplateField> <HeaderStyle Wrap="false" /> <HeaderTemplate> <asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="/Images/remove-item-red.gif" CausesValidation="true"/> </HeaderTemplate> <ItemStyle Wrap="false" /> <ItemTemplate> <asp:ImageButton ID="ImageButton2" runat="server" ImageUrl="/Images/select-item-red.gif" CommandName="Select"/> </ItemTemplate> </asp:TemplateField>

                                <asp:TemplateField>
                                    <HeaderStyle Wrap="false" />
                                    <HeaderTemplate>
                                        <asp:Literal runat="server" ID="LITMachineId" Text="Machine ID" />                                          
                                        <br />
                                        <asp:TextBox ID="TBMachineId" runat="server" AutoPostBack="True" Columns="10" />
                                    </HeaderTemplate>                               
                                    <ItemTemplate>
                                        <asp:Literal runat="server" ID="LMachineId" Text='<%# Eval("MachineId") %>' ></asp:Literal>                                                                                                                             
                                    </ItemTemplate>                                                                                                                 
                                </asp:TemplateField>

                                <asp:TemplateField>
                                    <HeaderTemplate>
                                    <asp:Literal ID="lblOsNm" runat="server" Text="Database Name"></asp:Literal>
                                    <br />
                                    <asp:TextBox ID="TBOsNm" runat="server" AutoPostBack="True" Columns="10" CssClass="textbox" />
                                    </HeaderTemplate>                               
                                    <ItemTemplate>
                                    <asp:Literal ID="LOsNm" runat="server" Text='<%# Eval("InstanceNm") %>'> </asp:Literal>                                                                                                                             
                                    </ItemTemplate>                                                                                                                 
                                </asp:TemplateField> 

                                <asp:TemplateField>
                                    <HeaderTemplate>
                                    <asp:Literal ID="lblOsNm" runat="server" Text="Product Name"></asp:Literal>
                                    <br />
                                    <asp:TextBox ID="TBOsNm" runat="server" AutoPostBack="True" Columns="10" CssClass="textbox" />
                                    </HeaderTemplate>                               
                                    <ItemTemplate>
                                    <asp:Literal ID="LOsNm" runat="server" Text='<%# Eval("product_nm") %>'> </asp:Literal>                                                                                                                             
                                    </ItemTemplate>                                                                                                                 
                                </asp:TemplateField>  

                                <asp:TemplateField>
                                    <HeaderTemplate>
                                    <asp:Literal ID="lblOsNm" runat="server" Text="Product Name"></asp:Literal>
                                    <br />
                                    <asp:TextBox ID="TBOsNm" runat="server" AutoPostBack="True" Columns="10" CssClass="textbox" />
                                    </HeaderTemplate>                               
                                    <ItemTemplate>
                                    <asp:Literal ID="LOsNm" runat="server" Text='<%# Eval("PhysDatabaseNm") %>'> </asp:Literal>                                                                                                                             
                                    </ItemTemplate>                                                                                                                 
                                </asp:TemplateField>    



                           </Columns> 
                            </asp:GridView>

=============================================================

WHY THIS ERROR OF DATAACESSADAPTER IS COMING, CAN I DO SOMETHING TO KILL THIS ERROR.

pLEASE HELP

Followed here: http://llblgen.com/TinyForum/Messages.aspx?ThreadID=14925 (please open only one thread per issue).