.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

the list.aspx bad behaviour

Posted By:      Posted Date: August 25, 2010    Points: 0   Category :ASP.Net

I have two tables : table1 (primary) and table2 with one to many relation .

table 1 has more than 130 000 records , table2 has near to 200 000 records .


when i am trying to list table2 , the table2/list.aspx will build filter depending on the relation.; this operation slows down the page (drop down list with 130 000 record)

 I disabled the filter by using the attribute AutoGenerateFilter = False .


now the problem is that table2/list.aspx?key=value will list all the recoreds in table 2 .


why is the page not using the query that is related to the parmeter passed to it ?


List.aspx (or list.aspx?key=value) will always get all the recorders from the table2  after disabling the key relation filter .

I want my table2/list.aspx?key=value  to query the table2 depending on the passed key which is the expected behaviour .

please advice .













View Complete Post

More Related Resource Links

Delete not working on List.aspx - out of box



I'am trying to use Dynamic data web site on my project. I have Visual Studio 2010 enf Framework 4.0. I create the default project with the wizard. I add my own Entity Data Model.

When I try to use the "delete" autogenerated button on List.aspx, on the table ServerSetting (see image below), I receive a null exception.  I have no custom code involved in this operation and cannot seem to determine what is Null.

Any help would be appreciated!



[NullReferenceException: Object reference not set to an instance of an object.]
   System.Data.Objects.Internal.ForeignKeyFactory.CreateConceptualNullKey(EntityKey originalKey) +30
   System.Data.Objects.DataClasses.EntityReference.NullAllForeignKeys() +722
   System.Data.Objects.EntityEntry.NullAllForeignKeys() +235
   System.Data.Objects.EntityEntry.Delete(Boolean doFixup) +77
   System.Data.Objects.EntityEntry.Delete() +9
   System.Data.Objects.ObjectContext.DeleteObject(Object entity, EntitySet expectedEntitySet) +169

How to use a drop down list to edit in the standard Edit.aspx with DD?


Hey All,

I'm brand new to Dynamic Data and to ASP.NET.  I've been able to fumble around and get the calendar extender up and running and a few other customization options implemented, but I can't seem to get this drop down list to work - even after reading tons of online info.  The good news is that my web page/application is VERY simple, so hopefully you guys can help me out.  I'm working in VB btw.

I have a list of road projects submitted to me by local governments.  One of the fields is SponsoringAgency, which has a limited number of possible entries (the names of member governments).  Thus, when they submit a new project, or edit an existing one, I want to limit the input into the field "SponsoringAgency." I'm trying to use a dropdownlist because I'm familiar with it from Access, but it may not be the best approach.  Imagine you just setup a brand new, standard DD website, how would you get this to work?

Methods tried and failed (probably because I don't understand them fully):

UIHint - The closest I can get with this is an error saying that since SponsoringAgency isn't a Foreign Key, I'm out of luck.

Creating a SponsoringAgency Table - In my data layer, I created a second table with a list of government names.  I then tried se

Getting user control in NewForm.aspx of the list


I have designed a user control where i have placed some custom fields as per my requirement now my next step is as soon as user clicks 'Create' under Site Settings it should take him to my user control page instead of Newform.aspx default page of the list.Just let me know your suggestions to achieve this as it would help me a lot

Thanks & Regards,


how to hide/display controls in NewForm.aspx based on dropdown value in SharePoint list



I have 1 dropdown in my sharepoint list with other columns. If dropdown value equal to 'xyz' i need to display some other controls, otherwise these controls should be hidden.

I know we can achieve this with javascript. If any one can provide code or sample then it will be appreciated. or is there any other alternative methods to do this ........

Thanks & Regards, Neerubee

Submit a aspx form to a sharepoint list?

Hi,I have a wizard control form in visual studio 2008.. I need to submit this form to a sharepoint list? Is this possible?thanks!

Show total items for GridView in List.aspx or GridViewPager

Hi, Is there a solution to show total items in Grid View in List.aspx or GridViewPager Eg. Record: 1 - 20 of 231 

change focus on controls in sharepoint list newform.aspx

hi all. i have newform.aspx where i hav required fields . when i say ok to enter the values the required field valiedates and shows error messages. but the problem is that the focus where it is suppose to get placed is promting in differnet place. can i change the focus of the controls inside newform.aspx or editform.aspx?jayaraja

Need help when selecting an item from one dropdown list it populates the 2nd dropdown on aspx page

Does anyone know how to do this so when I select something the 1st dropdown and the 2nd one becomes visible and populates list from a Select statement. I really need help on how to do in an aspx and not on the code behind page.

usageDetails.aspx data to a custom list?

any suggestions on how to get the data from _layouts/usageDetails.aspx to a custom list? trying to save a massive amount of time by identify users that haven't accessed a site in a given period of time.       

How to provision custom list and import custom aspx pages automatically in sharepoint?

What is best way to create custom list (Document library) and import custom .Net pages automatically. The goal is to avoid create the list and upload those .net page to the list manually. Any code snippet that would be great help. thanks

Reg passing info from aspx page to New form.aspx page of list in sharepoint



Initially i have Newform.aspx in the list.In that when i am clicking an icon that is available in Rich Text Box Editor it is taking me to another aspx page.In that page i have custom web part with One Field Control to upload  and one Button to upload the files.Now my requirement is as soon as after uploading these file from web part i should display the file names in the Rich Text Box.Please share your ideas of capturing file names in the web part and getting those file names in the rich text box in the newform.aspx of the list please let me know

Thanks & Regards,


Viewselector is not working in a custom ASPX list view nor does the custom view display in the list


I created a custom ASPX page to display data from a linked datasource in SharePoint designer. (Let's call it NewView)   After creating the new page I inserted a web part zone then inserted a data view into the zone and attached the default master to the page.   From the linked data source, I added the columns I wanted to display in the data view and added additional columns from the 2nd linked list as a subview.

I copied the following code just after the </WebPartPages:SPProxyWebPartManager> tag and just before the <WebPartPages:WebPartZone tag:

  <table class="ms-menutoolbar" cellpadding="2" cellspacing="0" border="0" width="100%">
    <td class="ms-toolbar" nowrap="">
     <SharePoint:NewMenu runat="server"></SharePoint:NewMenu>
    <td class="ms-toolbar">|</td>
    <td class="ms-toolbar" nowrap="">
     <SharePoint:ActionsMenu runat="server"></SharePoint:ActionsMenu>

How to display the List "NewForm.aspx" without masterpage



   I want to add the new item to the list, the name of the list called "Mylist". I have the link in the another sharepoint site page.The requirment is when the user click on the link, the popup window will come and inside that "NewForm.aspx" of myList will display. normally if we display masterpage also get display i dont want to display the masterpage. Just i want to display "NewForm.aspx" in side the POPUP window. How to display like this?

Disable child links in list.aspx : gridView based on some row condations


In the list.aspx page , Datagridview


I want to disable the links to the child table based on condition ,

let say if filed OrderDate is empty at row in table Orders I want to disable link to OrderDetailes for that specific row

Custom Page Template (List.aspx) - one to many relationship


Hi, I have two tables which is Customer and Customer Details table, with one to many details.

Is there possible to show Child table's column in (done in one GridView) Customers/Lisp.aspx?

SharePoint Designer 2007 - Customize List View - Error when saving view ASPX page


We have a custom list definition that includes custom site columns.  When we try to open one of the list view aspx pages in SharePoint to update the view query we get an error when trying to save the page in SharePoint Designer 2007.  We receive a warning that the operation will customize the page from the site definition, which is fine.  And then get a general "Server error: ServiceRequestorID" alert.  ServiceRequestorID is a custom site column used by the list definition.

ServiceRequestorID field definition:

<Field ID="{FA39D24D-AB40-4b1d-BD80-94ABE34A7578}" Name="ServiceRequestorID" DisplayName="Service Requestor ID" StaticName="

can not attach custom aspx list item form to the list




I'm need make custom aspx list item form for tasks of my workflow. I'm use code from this book: SharePoint 2010 as a Development Platform


my Elements.xml file

<?xml version="1.0" encoding="utf-8"?>

<Elements xmlns="http://schemas.microsoft.com/sharepoint/">

  <ContentType ID="0x010801005c12bbf6e6e548569e8100f1ad953859"

               Name="?????? ???????? ???????? ?????????? ???????????"

               Group="Custom Content Types"

               Description="My Content Type"



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend