Validate Date in Asp.net

Sourav Kumar Das

8y816.NET

Validation of date in Asp.Net by the given date in SQL Database...

If there's a solution please send me the link....

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suraj Kumar8y ago
Accepted answer
You are requested to do some modification as per your need
if(Convert.ToDateTime(txtSelectedDate.Text) < firstDate || Convert.ToDateTime(txtSelectedDate.Text)> secondDate)
{
//Your logic here.
}else
{
//Your logic here.
}
Sourav Kumar Das8y ago
This is the solution for my question....

1. Getting values from SQL Server

public void getDateList(string sBranchCode, string sProjectId)
{
ddlModule.Items.Clear();
try
{
string sQuery = string.Empty;
string sError = string.Empty;
DataTable dtbl = new DataTable();
sQuery = "SELECT CONVERT(NVARCHAR, StartDate, 105) AS StartDate,CONVERT(NVARCHAR, EndDate, 105) AS EndDate FROM TFS_mstrProjectAssign WHERE BranchCode='" + sBranchCode + "' and ProjectName='" + sProjectId + "' and pStatus='Y'";
objHelper.CreateConnection("Connect");
if (objHelper.FillDataTableByQueryString(ref dtbl, ref sError, sQuery) == true)
{
txtAssignedDate.Text = String.Empty;
if (dtbl.Rows.Count > 0)
{
ViewState["StartDate"] = dtbl.Rows[0]["StartDate"].ToString();
ViewState["EndDate"] = dtbl.Rows[0]["EndDate"].ToString();
}
}
else
{
Page.Controls.Add(new LiteralControl(""));
return;
}
}
catch (Exception ex)
{
Page.Controls.Add(new LiteralControl(""));
return;
}
}

2. Validating in Asp.Net

public void checkdate()
{
if (Convert.ToDateTime(txtAssignedDate.Text) <= Convert.ToDateTime(DateTime.Parse(ViewState["EndDate"].ToString())) && Convert.ToDateTime(txtAssignedDate.Text) >= Convert.ToDateTime(DateTime.Parse(ViewState["StartDate"].ToString())))
{
// My Code
}
else
{
Page.Controls.Add(new LiteralControl(""));
txtAssignedDate.Text = string.Empty;
}
}
Sourav Kumar Das8y ago
As I am Taking from single textbox need to validate with two dates.......Fromdate to Todate...

@Suraj Kumar
Suraj Kumar8y ago
You can set minimum and maximum date, refer this

https://www.c-sharpcorner.com/forums/datepicker-validation
or

You can check
if(Convert.ToDateTime(txtFromDate.Text) < firstDate || Convert.ToDateTime(txtToDate.Text)> secondDate)
{
    //Your logic here.
}else
{
    //Your logic here.
}
Sourav Kumar Das8y ago
Yes, I need to compare two dates from SQL Server......by passing the date in Asp.net Page...
Example:

SQL Server has two dates 12-10-2018 to 23-10-2018

In Asp.net I select it 25-10-2018, it should show error in validation....

@Suraj Kumar
Suraj Kumar8y ago
Hello Sourav,
Which type of validation you need? Do you need to compare two dates in sql server or something else?