.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

How can I limit the number of parameter selections?

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
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.

View Complete Post

More Related Resource Links

Drop DownList (Limit the number of rows)

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/-

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.

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.

What is the max limit for number of characters in multiline text in Sharepoint?



In Sharepoint list, i have a column define as multiline text.  I want to know, what is the max character limit in multiline text, and how can I increase it to unlimited text?

Thanks any help.

Abhijit Sil

Is there anz [OperationContract] number limit?




I have a WCF I write in Visual Studio 2010 in c#. Everything worked fine till now. Now I add a new [OperationContract] but it does not work. I does not get a result. I started to debug the problem and found taht in my webservice in the "result" variable the result is there. However in my client there is nothing returned. Tried to debug and turned on the debugging but nothing found. Finally I tried to add a new very simple [OperationContract] which just return a string. Nothing... If I add new [OperationContract] to my code they won't return enything. In the return result; code snippet I found that the result virable is correct but nothing returning to the client while all my previously written [OperationContract] works just fine.

Is there any limitation how many [OperationContract] can I write to my WCF program? Is there anybody who found similar problem?




I'm not a development! I'm an infrastructure engineer! Please be patient on the development forums! :)

The number of calls to the Changed event for a single update in the data exceeded the maximum limit.


Dear All,

We have hit the big limit of 16 change events per single update.  Is there any way to extend this to say 25, we are not using infinate loops or anything.

Alternatively, is it possible to disable some change events when values are updated?


William Man

Limit number of Users accessing the WebService


I am having WSE webservice and i want to limit the users accessing the webservice for example, at a time only 50 users can use that service.

The problem here is the users can vary. We cannot predictate the users. Means, we cannot give authendication for users.

Please help

Is there a limit in the number of digital signatures?


Is there a limit to the number of different digital signature lines/sections you can add to a form? They would like 8 different signature lines/sections  for various reasons and on the last few I can't seem to add any more. They all wind up using the same digital signature data to sign, if i change one they all change..

Thanks for any help...


perevent limit number of items in contentquery webpart




I want to perevent limit items from content query webpart .

there is a check box in the editor called "Limit the number of items to display". How Can I uncheck this check box by code ?


Is cube limit the number of calculation member?



I develop new application and user can create new calculation member. So some one can tell me "how many Calculation member a cube can contain?"


Much thanks.

Convert English to Arabic number without changing any regional settings in .net

Well, most applications that I worked with was multilingual that supports English UI and Arabic UI.

And one of the major issue that we have faced is displaying Arabic numbers without the need of changing the regional settings of the PC.

So the code below will help you to display Arabic number without changing any regional settings.

Enterprize library 4.1 getting output parameter after adding record in db, plz guide



I need to get output parameter (flag) from db after saving record in database. I am using Microsoft Enterprise Library 4.1 for DB. I am inserting record using I Data reader.

Please guide


dynamically adding sql server columns based on number of files in fileuploader


I want to create a new table to sql database at runtime.  The column names would be "Name", "Date", "Event".  I would also like to have one more column name "Image" but the problem is that since the amount of images will vary, I want the application to count the amount of files in the Multiple fileuploader and then add a image column to the table for the respected amount of files. 

For example if i am uploading 3 files in the multiple fileuploader, the names should be "Name", "Date", "Event", "Image1", "image2", Image3"

I also would like that table name to be name dynamically from the textbox Name when the user enters the information.


I have the following code to make a new table, but I dont know how to name the fields at runtime like previously asked please help!!!


Dim objConn As New SqlConnection("Server=<servername>;uid=<userid>;pwd=<password>;database=master")


Embeb a variable number of videos


I need to provide some alternate content for my non-Flash users.

I have a directory of video files that is scanned using the DirectoryInfo() function, and I want to use the results to embed all files ending in ".mov" in QuickTime players on a web form.

How would you approach this? Right now I am using the count on the array of videos to determine how many times to repeat the embed code.  But this seems inelegant.

Is there a way to have a single QuickTime player.ascx control that gets duplicated according to the number of videos available for display?

Use a column as parameter for a sds in another column; gridview


Hola, I have a gridview which is bound to a sds which returns 7 columns and I added two columns from the GUI.  What I want is to fill up the 9th column with DDLs and these  DDLS will get their data from a different sds which is using a stored procedure with a single parameter.  I created the 9th row, used template field, made the sds for 9th row, the stored_procedure, threw a DDL in Item template and all  I need now is to pass a parameter in the first column to the sds in the 9th column.  I can code this but i'm getting tired of aspx.cs :) and would like to do it from the GUI.

Article commenting by line number


I'm wondering what's the best way to approach an online article system that allows users to comment by clicking on the line they are commenting about? Essentially the same way Adobe Acrobat works with comments where you can click anywhere and the text is saved for that location.

I'm assuming a mix of jQuery would be the crux of the interface. The system would need to save comments so that when another user logs in, they will also see the other comments but they can´t edit them - only add their own.

Any suggestions would be great.

The number of members in the conceptual type ... does not match with the number of members on the ob



I've added a scalar property to an entity and now ASP.NET Dynamic Data scaffolding throws this error:

The number of members in the conceptual type 'TrainingModel.Users' does not match with the number of members on the object side type 'TrainingModel.Users'. Make sure the number of members are the same.

This happens at the following line in global.asax:
model.RegisterContext(typeof(TrainingModel.TrainingEntities), new ContextConfiguration() { ScaffoldAllTables = true });

Please help!

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