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

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

Drop DownList (Limit the number of rows)

Posted By:      Posted Date: September 17, 2010    Points: 0   Category :ASP.Net
Hi All, I have a dropdown list. This is a bound to a column in Table which has around 200 entires.Now when a user clicks on the drop down list I want him to see not more than 10 rows. The rest he should navigate by using scroll bars.Please advise me on how to achieve this.Rg/-

View Complete Post

More Related Resource Links

How to apply color to selected number of items in check box list and drop downlist

Hi all,    I want to apply color to selected number of items in checkbox list and seleted number of items in drop downlist for e.g color red for few items and black (default). I have a bit value set in data base so if bit is set to 0 then red and if 1 then back. Please help me.  

Report Model--is there a limit on the number of rows?

Is there a limit on the number of rows that a report model will support? Our report model has tables that have millions of rows of data. When we regenerate the model it starting to take hours to regenerate. Is that expected? Is there a limit on the number of rows that can be used with a model?
Kim B.

Restricting number of rows in a set

Hi All, Is it possible to restrict the number of rows which may come in a set in MDX ? WITH SET set1 AS Order ( { Filter ( [DimContract].[Contract Acc].[Contract Acc].MEMBERS , (NOT IsEmpty([Measures].[Consumption])) OR (NOT IsEmpty([Measures].[SampleSize])) ) } ,[Measures].[Consumption] ,ASC ) Say if i have a set like above , then can we restirct the number of contracts which may come in this set ?

Dynamically Drop and Create tables, overcoming 4000 charachter limit

We have a Navision SQL-server database for 7 companies. Each table starts with the name of the company. Except for the CompanyName-part, the tables names are equal. I made a Foreach loop that dynamically transfers tables/data from the the Navision-database to a staging-database. I also want to Drop and re-Create the tables dynamically. However, if I try to do that via an expression in a SQL Task, SSIS complains about the 4000 character limit. What is a better way to do this? I want to execute SQL-commands and have SSIS replace part of the tablename with the contents of a variable (being the name of one the 7 companies). I have no access to the Management Studio or the DB so I need it to be done within the package. What is the best way to do that?

ASP.NET Events and Pageload not firing when Datagrid containing large number of rows of data

Hi All, I have a datagrid in aspx page.Inside of datagrid i am using around 15 controls such as Button,dropdownlist and text box controls.Once the datagrid binds then the events in the aspx page not firing.Issue occured when the number of rowsgreater than 500.The number of rows less then its works fine.If anybody knows the solution please let me know."Platform i am working on ASP.NET1.1"Regards Hareesh

GridView Pager not showing proper number of rows

I have created an out-of-the-box  (default everything) ASP.NET Dynamic Data Entities Web Site using VS2010, C# and the .NET Framework 4. Created an ADO.NET Entity Data Model based off a MS SQL 2008 R2 database and registered that EF data model for my dynamic data. Everything works great except for the one change I would like to make. By default, the GridViewPager.ascx file provides the values 5, 10, 15 and 20 in the dropdown for GridView's "Results per page" option. I would like to change that to 10, 20, 30 and 40 - with 40 being the default selected option. I went to the code behind file and modified it to have the values I am wanting. Those values now show in the dropdown, and work if I select them. Problem: when the page is first rendered only 10 rows will show. How can I change this? Any help would be greatly appreciated.   Thanks

pass number of rows of Gridview to a javascript function

using vb.net/asp.net 2005.I need to pass the number of rows of the Gridview to a javascript function does anyone know how to do this?  thanks

How can I limit the number of parameter selections?

HI I'm wondering if I can limit the number of parameter selections. For excample, user must  select 2 years in YEAR dropdownlist. Many thanks.

Creating a form with an unknown number of rows

Hi everyone, I'm pretty new at ASP .NET but not to ASP.  I've got a form I need to create where I don't know how many entries will be added.  It has the following format: "Age"             "Duration"      "Period of Duration"     "etc..." Last30Days 1-5 Months ago 6-11 Months ago Age Age Age etc. So the Age column always has the first 3 options and then an unknown number of Age values that can be inserted.  I've created a table that has the first four fields (Last30days, 1-5months, 6-11months, age)  and I was thinking I could just order by those 4 columns for display.  The problem I have is I'm not sure on how to proceed.  Does anyone have any good ideas on how to handle this situation?  Ideally data entry people could use the same form for both entering and displaying the data.  Thanks.

Max number of rows in a table

Hey I'm doing a bit of research on which database to use for a new project. And one of the factors I have to take into consideration, is that we will have some tables with a high amount of records. I originally intended to use mysql (because it's free), but I have found that it has a cap of 4.2 billion rows per table. And it is a possibility that we will exceed that number in a few of our tables. So far, from looking around here, and on the web, I've only be able to find, that is no such cap on tables in mssql, and that table sizes is only limited by available storage. The thing is, 99% of the info I found regarding tablesize limits in mysql, also stated that it was only limited by the storage size (4gb, not all available). I had to look very thouroughly to find that last 1% where someone mentioned the 4.2 bil. upper limit. I hope someone here can confirm that, there is indeed no limit on the number of records in a single table in mssql, no hidden cap, however unlikely to be an issue. I find, that there's a ton reasons to pick mssql over mysql. But this factor will be a big selling point, in convincing the higher-ups that mssql is the better choice for my project.

Restrict number of rows per page



As I deploy reports, based on the no of records in result set, I get a scroller on the right hand side. How can I disable the scroller? I guess I can disable the scroller by restricting the no of rows being displayed.. eg: show 10 records per page. Any idea how do I set no of rows per page?



Performance of a Stored procedure : Optimum number of rows to be handled in a batch


In a stored procedure is there anything called as optimum number of rows that need to be handled in a batch

as In, If there is a SP,

   that picks up data(via union operation) from various objects and puts them into a temp table after which the required data is moved to various tables,The above scenario is handled as a batch run where in 1 million rows are processed in a batch and the next 1 million rows in a next batch,so on and so forth.

   Is there any optimum number of rows that can be processed in the above case?

  When we increase rows processed per batch we have seen improvements in performance of the SP,but not sure when it will start deteriorating.




How to modify the drop-downlist in i top-meny

How can I modify the drop-down-list i the top-meny so that i shows all the lists, sites ang pages within that entering?

Count gives me the same answer regardless of the number of rows


I always get a result of zero from the following code sequence even as the row count changes and I just do not see what the error in my syntax is.




supercount As Integer

supercount = 0


Dim sqlkit As String

sqlkit =

Limit number of characters in the view field



I wonder if I can limit number of characters that are being displayed in the view.  For example, one of the columns sometimes has very long description.  I want people to see only 300 characters, and if they want to read more, they have to click on the link to go to details.

Is it possible?

Thank you.

Report, Change The Number Of Rows Per Page


I am fairly new to reporting services and recently created a simple tabular report.  There is one table which queries the database and I would like to change the table so there are more than 25 rows of data per page.  How do I do this? 

Also it would be advantageous to know how to set the report to only create a new page for every different item in a column.  For eg if I have various data for each date, I would like to only create a new page when the date changes so that all data for a specific date is on one page etc etc.

Many Thanks

SSAS Excel Drill Thru : Number of Rows Returned don't match up


Hi, I have created an excel report which connects to my cube and have created drill thru action. When I double click on data cell in excel, what I would expect is to give details for that cell. For example, I have a cell in excel that represents 1000 Sales made. When I double click on it, it should only show me thousand rows, however for some reason it gives me more than 1000 rows. So basically the cell counts don't tie with drill thru row counts.....

Any idea on how I can rectify this?

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