cm = New SqlCommand("select * from h_leave where holi_date1='" & Convert.ToDateTime(Me.txt_frmdate.Text).ToString("MM/dd/yyyy") & "' or holi_date2='" & Convert.ToDateTime(Me.txt_todate.Text).ToString("MM/dd/yyyy") & "' or (holi_date1 between '" & Convert.ToDateTime(Me.txt_frmdate.Text).ToString("MM/dd/yyyy") & "' and '" & Convert.ToDateTime(Me.txt_todate.Text).ToString("MM/dd/yyyy") & "')or(holi_date2 between '" & Convert.ToDateTime(Me.txt_frmdate.Text).ToString("MM/dd/yyyy") & "' and '" & Convert.ToDateTime(Me.txt_todate.Text).ToString("MM/dd/yyyy") & "')", con)
DateTime dt = DateTime.ParseExact(value, format, CultureInfo.InvariantCulture);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)