query by specific day asp.net c#

Question

I have a grid view. Under this, I have used some parameter like @LHNoofOverdueEMI and @LHDisbDate. I want to query by grater than or equal value of @LHNoofOverdueEMI and equal to value of specific day value of any month or year from @LHDisbDate. All are details below:

page.aspx

<asp:SqlDataSource ID="DSGVRecList" runat="server" 
ConnectionString="<%$ ConnectionStrings:OptimaWebCustomerQueryCon %>" 
SelectCommand="select LHID, LHAcNo, LhAcName, LHIntRate, LHDisbDate
LHDrawingPower, LHtotalDisbAmt, LHEMI, LHNoofOverdueEMI,  LHUploadDate
from dbo.TblLoanHistory where
(YEAR(LHUploadDate) = YEAR(GETDATE())) AND (MONTH(LHUploadDate) = MONTH(GETDATE())) 
AND LHNoofOverdueEMI ??? 
AND  LHDisbDate ??? "

onselecting="DSGVRecList_Selecting">
<SelectParameters>
<asp:ControlParameter ControlID="txtNoofOverDue" Name="LHNoofOverdueEMI" PropertyName="Text" /> 
<asp:ControlParameter ControlID="txtEMIDate" Name="LHDisbDate" PropertyName="Text" />  
</SelectParameters>
</asp:SqlDataSource>

c#

protected void DSGVRecList_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{
if (txtEMIDate.Text.Length == 0) e.Command.Parameters["@LHDisbDate"].Value = "%";
else e.Command.Parameters["@LHDisbDate"].Value = txtEMIDate.Text;
if (txtNoofOverDue.Text.Length == 0) e.Command.Parameters["@LHNoofOverdueEMI"].Value = "%";
else e.Command.Parameters["@LHNoofOverdueEMI"].Value = txtNoofOverDue.Text;
}

and what is the problem?

Zaki
– Zaki

2013-10-30 12:32:39 +00:00
Commented Oct 30, 2013 at 12:32 — Zaki
– Zaki, Commented Oct 30, 2013 at 12:32

Mido · Accepted Answer · 2013-10-30 12:37:38Z

1

Have you tried using: SELECT DATEPART(weekday,GetDate()) ?

It returns the day of the week based on the specified date. 1 = Sunday and 7 = Saturday.

answered Oct 30, 2013 at 12:37

Mido

1205 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nur Muhammad Over a year ago

Actually I want any day query like 1,4 , 10, 23, 27

Collectives™ on Stack Overflow

query by specific day asp.net c#

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related