Allow Users To Enter A Variable Length List Of Items In Form?
Jun 15, 2010
I need to let my users enter a variable length list of items into something that looks like a grid view (or a series of standard text boxes stacked vertically). Each item could be a few characters or a few hundred characters long, and I just want them to enter a "sentence", and then tab to the next row, and always having another blank one ready to go at the bottom of the list.
I don't want to save any data to my SQL Server DB until they enter the entire list and then click on a "save all" button. When they hit the "save all" button they will be given a preview screen where the data will be presented as standard HTML ordered list. If they confirm/save, then each row of the grid will then be saved as a separate row into my SQL Server database (with an index to remember the order).What ASP.Net (or Jquery/javascript) UI control would be the best to use in this situation? (i.e. just for the data entry part - the rest I got covered).
I have a few applications/websites running with LINQ to SQL and the other day I decided to go ahead and optimize some of the queries, etc and I found that the size for variable length data types is derived from the parameter value instead of the column actual size? for example a column is defined as nvarchar(30). when I use linq to query that column with a value that's 5 characters long the parameter in sp_executesql will be defined as nvarchar(5)...this causes a major procedure cache bloat even for a small utility site that has a lot of queries is there a way to optimize this?
In my application, if I do not input the value into the textfield, it will show error message: "The value '' is invalid."
However, is it possible to check one more thing: the length of the textfield? For example, it will show the error message if I input more than 10 chars? And is it possible to change the message "The value '' is invalid." to "Missing Value"?
I have a text box and users are entering na rather than supplying the specified data. How can explicitly not allow them to enter na in the field? I want to use an asp regularexpressionvalidator.
I'm creating an "edit-your-profile-page" and I need to know how to keep the values that the users has enter between page loads. Error controls and stuff like that.
RegularExpresssoinValidator. I want to use it in a field where users enter URLs. I not only want to make sure that it's a valid URL but I also want to make sure that it's only those sites that are allowed.Let's say, I want my users to enter only YouTube or CNN URLs. How do I use the RegularExpressionValidator for this?
I am having trouble with something, my client wants to be able to hit <enter> as well as click the button on this page:-
[URL]
If you look at the Blue "Postcode search" and try searching for a nursery byb clicking the button you will see how it works. However then try doing the same but hitting <enter> and see what happens..
The front end html is as follows:-
PHP Code:
[code]....
I tried adding javascript so it would recognize the button and allow users to hit enter but this did not work.
I want to create a seach textbox for users to enter a few keywords in ,..and then my sql query will display the results......( basically a little search engine for my website)Ok so im thinking of using the Containstable with ranking on how close these keywords are to eachother... so the closer the keywords are to each other... the higher their ranking will be.... but I also want to seach for these keywords in 4 columns in one Datatable how can I do this
User will be entering % data in textbox. I am now using filter textbox extender to allow only numbers and .(ie decimal values). I also want the user to enter values from say 1 to 100 only.. How can i do this? If user wants to enter 0.5%?
I have used Login Control + Change Password + Create User Wizard in my project. Everything is working fine. I want to know that how to get the List of Users and also to Update/Delete users.
I want to extract list of parameters with data type and length.For example i give name of sp and i can able to find the list of parameters thet the sp expact with datatype and length of parameter.
I have a situation where in I need to allow the users to enter email address of yahoo only in a free textbox.Can any one let me know how do I achieve this?For E.g: If the user supplies the email id as "xxxx@yahoo.com or xxx_xx@yahoo.com, or xxx.xx@yahoo.co.uk or xxxx_yy@yahoo.co.us", I will permit him for further processing. If the user inputs the email id as "xxx@gmail.com or xxx@rediffmail.com orxxx@someothermail.com" I should display an Error Message.
i added autocomplete extender its working fine but the suggestion list half bottom is not showing because its exceed the length of the div containing textbox
I'm writing a program that records time-in and time-out and I have a problem when trying to retrieve data for a specific date.In the table, the "timein" and "timeout" fields have format of "smalldatetime". To record the timein, I insert the system time (by using System.DateTime.Now) into the "timein" field.I want two types of searches.
1) Search records between a date range
2) Search records for a specific date
For example, First, I want to search if there are any records between 11/2/2010 and 12/1/2010. I will ask user to input "11/2/2010" as start date and "12/1/2010" as end date. I will use Convert.DateTime() methods to convert these two input before put them into SQL query like:
"SELECT * FROM timesheet WHERE timein BETWEEN Convert.DateTime(startdate) AND Convert.DateTime(enddate)"
The output results do not include the date 11/2/2010 and 12/1/2010. I get only the dates in between. I know that is the limitation of BETWEEN. I wonder if someone has a way to work around this limitation.
Secondly, I want to prompt users to enter a specific date like (11/2/2010) and search the table for rows match that criteria. I can't get this to work. I have tried "SELECT * from timesheet WHERE timein LIKE '%searchdate%'", "......timein = 'searchdate'" but none works.
(I'm using VS 2010 C# and SQL 2008 for this project)
How would I create a list then on click add data to the list which is then stored into a session variable, then on another page retrieve the variable and output them? Currently I have:
Page Load:
List <myClass> listName=new List<myClass>
OnClick:
listName.add(3); listName.add(4);
Session["IDs"]=listName; Second Page
I need to get the whole list and add output the list so I can output (hopefully) the '3' and '4'.
I'm designing my own custom control that contains a .NET dropdownlist. What I'm wondering is if it is possible to populate my dropdownlist with listitems placed in a placeholder? For example:
This doesn't work because the DropDownList control only allows ListItems as child controls. But, I want to do something similar to this so when the user includes my control on a page, they can do something like this:
ASP.NET Web-forms Javascript (jQuery for instance)
Case,To make it clearer let's give the Stackoverflow Users list as an example. This list can be manipulated at client-side. I can search, page and so forth. So obviously we would need to call jQuery.ajax to retrieve the HTML of each page given a search. Alright. Now this leaves me with the first question:
What is the best way to render the response for the jQuery.ajax at server-side? I can't use templates I suppose, so the most obvious solution I think is to create the HTML tags as server-controls and render them as the result of an ASHX request? Nice. That solved we have yet another problem:
When the user first enters the Authors List the first list page should already come from the server completely rendered alright? Of course we could render the first page as well as an ajax call but I don't think it's better. This time I CAN use templates to render the list but this template couldn't be reused in case 1. What do I do?
Now the final question: Now we have 2 rendering strategies: 1) Client and 2) Server. How do I reuse code for the 2 renderings?
