Date based validations in asp.net

Question

My requirement is like so.

I need to maintain a holiday list. For that I need some validations while saving/editing an entry.

My DB contains a table with HolidayDate column. I have a textbox(jquery date picker) in the page. If the date what I choose has already been saved to the table, I should display an alert message.

Can anyone help me soon, please? Thanks in advance. Aishvarya.

You need custom validator which can have both client and server functions to be called. Of course, for client side, Ajax needs to be used. — Sunny, Apr 04 '13 at 07:57
you need to use server side code on text change of the texbox. Use Jquery ajax for this. [Link](http://stackoverflow.com/questions/886903/calling-asp-net-server-side-method-via-jquery) — शेखर, Apr 04 '13 at 07:58
Maybe you can give some more details? Do you want to do this server-side or client-side? Do you want to do a postback or do this via AJAX? — Elad Lachmi, Apr 04 '13 at 07:59

Igor Lozovsky · Accepted Answer · 2013-04-04T09:08:24.927

0

Try this:

<asp:TextBox ID="DateControl" runat="server"></asp:TextBox>
<asp:RangeValidator ID ="DateValidator" runat ="server" ControlToValidate="DateControl" ErrorMessage="Invalid Date" Type="Date" MinimumValue="01/01/1900" MaximumValue="01/01/2100" Display="Dynamic"></asp:RangeValidator>

Also more information about RangeValidator here: http://msdn.microsoft.com/en-us/library/f70d09xt(v=vs.71).aspx

Sample: http://www.w3schools.com/aspnet/showasp.asp?filename=demo_rangevalidator

Simplest way of server-side validation:

code behind:

protected void Button1_Click(object sender, EventArgs e)
{
     DateTime result;
     if (DateTime.TryParse(DatePicker.Text, out result))
     {
           //handle results
     }
     else
     {
           // e.g. highlight DatePicker or handle error
     }
 }

Form:

<asp:TextBox ID="DatePicker" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" />

Jquery validation sample:

<!doctype html>

<html lang="en">
<head>
  <meta charset="utf-8" />
  <title>jQuery UI Datepicker - Default functionality</title>
  <link rel="stylesheet" href="http://code.jquery.com/ui/1.10.2/themes/smoothness/jquery-ui.css" />
  <script src="http://code.jquery.com/jquery-1.9.1.js"></script>
  <script src="http://code.jquery.com/ui/1.10.2/jquery-ui.js"></script>
  <link rel="stylesheet" href="/resources/demos/style.css" />
  <script>
  $(function() {
    $( "#datepicker" ).datepicker({minDate: new Date(2013, 0, 01),maxDate: new Date(2013, 04, 01), dateFormat: "yyyy/mm/dd"});
  }); <!-- select only date from 1 jan 2013 to 1 may 2013 --!>
  </script>
</head>
<body>

<p>Date: <input type="text" id="datepicker" /></p>

</body>
</html>

edited Apr 04 '13 at 09:08

answered Apr 04 '13 at 08:25

Igor Lozovsky

2,275
2
15
14

My javascript function which I use only to display alert message. function Redirect(opt) { if (opt == "validate") { alert("Holiday already entered for this date...! Choose another date"); } shouldsubmit = true; window.location.assign("SetHolidays.aspx"); } – MusicLovingIndianGirl Apr 04 '13 at 08:46
My server side code for saving. `Dim dsGetHolDetails = dbl.usp_GetHolidaysForView().CopyToDataTable` `ViewState("HolidayDetails") = dsGetHolDetails` `Dim dtHols As New DataTable` `dtHols = CType(ViewState("HolidayDetails"), DataTable)` `For i = 0 To dtHols.Rows.Count - 1` `While dtHols.Rows(i)(2).ToString = txtHolidayDate.Text` `Dim script As String = String.Format("Redirect('{0}')", "validate")` `ScriptManager.RegisterClientScriptBlock(Me, GetType(Page), UniqueID, script, True)` – MusicLovingIndianGirl Apr 04 '13 at 08:51
You should add tag "VB" to your post – Igor Lozovsky Apr 04 '13 at 09:02
Igor, let me make it clear to you. I am NOT going to validate based on range. It is just I have some dates in the table like 01/04, 02/04, 03/04 etc., The new date or the existing one which I am going to save should NOT be equal to the ones in the database i.e, I need the code to check every single records's date column. – MusicLovingIndianGirl Apr 04 '13 at 09:28
I have got it, thanks all :) I just wrote a code, calling the stored procedure which fetches the list of holidays saved in the table. Like `Dim a = ` So, IF a.count > 0 I write an alert message. – MusicLovingIndianGirl Apr 04 '13 at 10:44

Date based validations in asp.net

1 Answers1