i am having two textboxes one is startdate and another one is enddate and i have assign ajax calendar extender control for each textbox.Now i need to show ajax validator popup if the startdate and enddate range should be grater than one month.
View 3 Replies
SQL query so that if i pass date that is not between startdate and EndDate then it should return the previous row schedularID.
For Example:if i pass 19/06/2010 i should get SchedularID 1
if i pass 09/07/2010 i should get SchedularID 3
and so on....
SchedularID
ContestantA
ContestantB
StartDate
EndDate
1
3
4
10/06/2010
18/06/2010
2
1
2
20/06/2010
28/06/2010
3
5
6
01/07/2010
08/07/2010
4
7
8
10/07/2010
18/07/2010
I have 2 coulmns
PromCode, StartDate , EndDate
A001 2010/05/01 2010/05/30
A002 2010/04/01 2010/04/30
C120 2010/03/01 2010/03/31
DECLARE @NOWDATE VARCHAR(10)
SET @NOWDATE = CONVERT(VARCHAR(10),GETDATE(),111) -- Get System Date
I want to use (StarDate + EndDate) compare with SystemDate to make sure if the PromCode is process or expired..
my problem is .. how to compare both StartDate and EndDate with SystemDate?
this is the result I trying to query..
PromCode, StartDate , EndDate ,Status
A001 2010/05/01 2010/05/30 Future
A002 2010/04/01 2010/04/30 Valid
C120 2010/03/01 2010/03/31 Expired
SELECT
PROMCODE
,STARTDATE
,ENDDATE
, .... AS STATUS ( does here I should use when..case? or use subquery? I try use Case..but get syntax error)from Table
I have two drops downs one for dislaying month & other for year till the current year
Here all months & year from 1900 till current year is displayed
I need to display the month or make user select the month & year only till one year back , not beyond that current month is june 2012
The user should be able to select months from may 2011 to june 2012 only
Same thing I need to accomplish with calendar control....
I am using ASP.NET's server-side validation. In the page_load event I'm calling Page.Validate(), and if Page.IsValid is not true I'm then polling the controls to figure out which ones are not valid, and then determining what actions to take.It would be much easier if each control would raise an event as validation fails, allowing me to take action for that particular control. I'm very much a naive programmer when it comes to validation, but is there a way to extend these controls so that a validation error raises an event?
View 1 RepliesI have a button Import on my page. Upon pressing this button, a modal popup dialog appears where the user can enter path of the import file. I have a required field validator to make sure the user entered the path. And I have there a Submit button. My problem is that validation happens not only when I press the Submit button on the modal popup, but also when I press any button on the page itself, which is wrong.
View 2 RepliesI have 1textbox and 1 button==BtnPopupL in page..I define RequiredFieldValidator for text box and use ModalPopupExtender for button below is code:
<asp:UpdatePanel ID="Uptload1" runat="server">
<ContentTemplate>
<asp:ModalPopupExtender DropShadow="true" ID="ModalPopupExtender3" PopupControlID="PnPopupL"
runat="server" TargetControlID="BtnPopupL">
[code]..
here when I click on button it will show popup but I want if users don't type any text in textbox if they click on button it doesn't show popup and show error that I define in RequiredFieldValidator...here when I don't type text in textbox when I click on button it show both(popup and Required FieldValidator) but I want it doesn't show popup untill I type text in textbox...
I am using one simple captcha form in modal popup so when i am inserting the captcha text in textbox if it is not validating
then in the same page i used one label to show the error "not validated". but when i click on the button modal popup is getting hide.
Here is my design code:
<div>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<Triggers>
<asp:PostBackTrigger ControlID="btnExcel"/>
</Triggers>
<ContentTemplate>
<asp:Panel ID="Panel3" runat="server" Width="300px">
[Code] ...
And here is my code behind:
protected void btnExcel_Click(object sender, EventArgs e) {
Captcha1.ValidateCaptcha(Txtcaptcha.Text.Trim());
if (Captcha1.UserValidated) {
HiddenField1.Value = "0";
VerifyPassword(txtUsername.Text, txtPassword.Text);
} else {
Label6.ForeColor = System.Drawing.Color.Red;
Label6.Text = "Not validate";
} }
i want it if it's not validate in the same modal popup page it should show the message.
I'm using the ASP.Net Validation controls and I want to display the Validation Summary in a JQuery Dialog instead of the native javascript alert messagebox. I've found this solution (aspsnippets) by overriding the clientside WebForm_OnSubmit() function:
<script type="text/javascript">
function WebForm_OnSubmit() {
if (typeof (ValidatorOnSubmit) == "function" && ValidatorOnSubmit() == false) {
$("#validation_dialog").dialog({
title: "Validation Error!",
modal: true,
resizable: false,
[Code] ....
The WebForm_OnSubmit() function is being rendered by the BaseValidator control and in the form tag te following attribute is being added: onsubmit="javascript:return WebForm_OnSubmit();
I am running into a problem on a page which has an UpdatePanel. The input field with the validator (1 to make it simple) is in a Panel within an UpdatePanel. The Panel is set to Visible=False at the first Page Load. There's a button inside the UpdatePanel which makes the Panel with the Validator Visible.
When this happens, the WebForm_OnSubmit() function and the onsubmit="javascript:return WebForm_OnSubmit(); attribute of the form tag are not being rendered because it's an AJAX callback and the form tag is outside the updatepanel (in a master page), so the validation summary will not be shown in the jquery dialog.
Validation is being performed, so the validation summary wil be shown in a div on a page, but the validation is not being called by the WebForm_OnSubmit() function in this case, because it's not being rendered.
Here's the markup of the page:
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:Button ID="btnNew" runat="server" Text="New" />
<asp:Panel ID="pnlEdit" runat="server">
<table>
[Code] ....
So, when the validators are not visible at the first load and they will be made visible by an AJAX callback, the WebForm_OnSubmit() function and the onsubmit="javascript:return WebForm_OnSubmit(); attribute of the form tag are not being rendered on the pag. Because of that, the WebForm_OnSubmit() function will not be called and the validation summary will not be shown in the JQuery dialog (although it is being shown in a div on the page). How can I get the Validation Summary to be shown in de JQuery dialog in this case?
Is there another function that has to be overriden for this case? I know I can use a Full Postback for the New button and then all the stuff needed is being rendered on the page, or I can make the panel not visible by using a style, but I don't prefer that because there are a lot of pages with this situation.
One solution is to use a dummy textbox with a dummy validator (with a dummy validationgroup) of which I set the display to none. Then this dummy validator will cause the the WebForm_OnSubmit() function and the onsubmit="javascript:return WebForm_OnSubmit(); attribute of the form tag to be rendered.
In ASP.Net textbox, How I can restrict the user to enter maxlength. I should show message in label or message box, if user exceeding the maximum length. I am using C# as code behind.
View 4 RepliesI have the following code. What's happening is, on postback, the required attribute for sequence will fire. If it passed, the range check is skipped completely. If it fails, it never gets to the range check either. Have I coded something wrong?
using System.ComponentModel.DataAnnotations;namespace Venue.Models{ [MetadataType(typeof(CategoryMetadata))] public partial class Category { } public class CategoryMetadata { [Required(ErrorMessageResourceType = typeof(Resources.Locale), ErrorMessageResourceName = "sequence_required")] [Range(0, 9999, ErrorMessageResourceType = typeof(Resources.Locale), ErrorMessageResourceName = "sequence_invalid")] public int Sequence { get; set; } [Required(ErrorMessageResourceType = typeof(Resources.Locale), ErrorMessageResourceName = "title_required")] [StringLength(256, ErrorMessageResourceType = typeof(Resources.Locale), ErrorMessageResourceName = "title_invalid")] public string Title { get; set; } }}
As they have given option to pass typeof() as first parameter and min-max value.Is there any way we can implement range validator attribute for date by using typeof(datetime) ?please let me know if anyone has implemented same ?
View 1 RepliesI need regular expression validation for textBox
(integer and min value 200)
If input text 200, 201,202 OK
Else error input!
i am trying to raise my page_load event in my MultiHandleSliderExtender ,
how do i do this ? here is my HTML code
<%
<%
<%
@
Page
[Code]....
I have a ListView InsertItemTemplate where there is field (Date) using the AJAX Library CalendarExtender. I want to add some validation to this field, whereby they can't add a date that is later than today. So I have added a RangeValidator and tried to set its MaximumValue to DateTime.Now on Page Load. Unfortuantely it isn't working.
View 5 RepliesI want to put validation in a Textbox, that the numbers entered inside textbox should be between 1 to -1 only i.e., (-1, -0.1, -0.2, -0.3, -0.4, -0.5, -0.6, -0.7 ....... 1 )I tried below code but "RangeValidator" is not working as per requirement:
HTML:
<asp:RangeValidator ID="RangeValidator1" runat="server" MaximumValue="1" MinimumValue="-1" Text="value between 1 to -1" ErrorMessage="value between 1 to -1" ControlToValidate="TxtY" ValidationGroup="usrvalid"></asp:RangeValidator>
<asp:TextBox ID="TxtY" Text='<%#Eval("Y") %>' runat="server" Width="30%"></asp:TextBox>
<cc1:FilteredTextBoxExtender ID="FilteredTextBoxExtender5" TargetControlID="TxtY" FilterType="Custom" ValidChars="-01234567890." runat="server"></cc1:FilteredTextBoxExtender>
How to achieve it.
I am inserting some text in texbox and there is range validation set as minimum as 10 and maximun as 100. But when i run the program, though i insert the text atleast or more than 10 characters, it is showing the error message of this range validation. how to set range so that user has to input atleast 10 character minimum ?
View 7 RepliesI am trying to get a modal popup inside a modal popup?, also i want to fire the modal popup on a condition in a text change event of a textbox?...is this possible and can anyone give me directon on this
View 5 RepliesIn my application I have a formview which is inside of a Ajax modal popup.Once users enter the information in the formview and click save, I validation the input.errors, I want to display an error message as a popup or as a modal popup (not javascript alert) with in the ajax modal.How do I do that. I tried several ways but it closes the ajax modal popup.
View 2 Replieshas anyone implemented date range vaildation using jquery.validate file? when i m trying to implement it with mvc application its not working properly , as its working only for numeric types. wl range validator of jquery validate only numeric values ?
View 2 RepliesI am facing problem using range validator.
Like in code below
[code]
If I enter value 450 in textbox to validate it in range 25 to 50 ,it won't give any error message
I have a Range Validator as follows. It is for restricting values between 1900 and 2070. However, it fires error when I enter a alphabet also. I want this to be fired only if the user enters integer values. How do I overcome it?
<asp:RangeValidator ID="RangeValidator1" runat="server" ControlToValidate="txtYear"
ValidationGroup="report" ErrorMessage="EM1|Year" MaximumValue="2079" MinimumValue="1900"
SetFocusOnError="True" Display="Dynamic" Type="Integer">
<img src="../../Images/error.gif" alt="Format" />
</asp:RangeValidator>
When using a range validator, if the user exceeds the defined range, How do you code it so it disables a button so the user can't continue. (without using JavaScript)
View 3 RepliesHow to calculate current date(month) minus one month in crystal report?
View 1 RepliesHow to display the number of days in textbox when the month is selected in the dropdown list,,,for example if i select the month december ,after selection i want to display 31days in the textbox how ?
View 1 Replies
