Validate Date in Asp.net

Question

Validation of date in Asp.Net by the given date in SQL Database... If there's a solution please send me the link....

Suraj Kumar · Answer

You are requested to do some modification as per your need if (Convert.ToDateTime(txtSelectedDate.Text) secondDate) { //Your logic here. } else { //Your logic here. }

Sourav Kumar Das · Answer

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["StartDate"].ToString()))) { // My Code } else { Page.Controls.Add(new LiteralControl(" alert('Assigned Date is not set to the provided date.') ")); txtAssignedDate.Text = string.Empty; } }

Suraj Kumar · Answer

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) secondDate) { //Your logic here. } else { //Your logic here. }

Sourav Kumar Das · Answer

As I am Taking from single textbox need to validate with two dates.......Fromdate to Todate... @Suraj Kumar

Sourav Kumar Das · Answer

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 Kumar · Answer

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