Getting value from date range

Question

0.00/5 (No votes)

See more:

I have two textboxes

<asp:TextBox ID="Txtfromdate" runat="server" CssClass="txtBoxNormalmedium"
                                                               Height="16px" >mm/dd/yy</asp:TextBox>


   <asp:TextBox ID="Txttodate" runat="server" CssClass="txtBoxNormalmedium"
                                                               >mm/dd/yy</asp:TextBox>

A name drop down

<asp:DropDownList ID="ddlname" runat="server" CssClass="ddlNormalMedium"
        AutoPostBack="True" OnSelectedIndexChanged="ddlname_SelectedIndexChanged"
          >
    </asp:DropDownList>

and Search button

<asp:Button ID="btnSearch" runat="server" Text="Search" CssClass="btnNormal" onclick="btnSearch_Click"  />

So if a user selects say 6th may as the from date and 10th may as the to date,All the names within that date range should be bound into the database after the Search button is clicked.
The below is the code i tried, its not displaying any names in the drop down list.

protected void btnSearch_Click(object sender, EventArgs e)
       {
           DateTime fromDate, toDate;
           fromDate = DateTime.Parse(Txtfromdate.Text.ToString());
           toDate = DateTime.Parse(Txttodate.Text.ToString());
           SqlCommand cmd = new SqlCommand("SELECT  [emp_name], [created_date], [todate] FROM [T_TADA_temp] WHERE (([created_date] = @DateFrom) AND ([todate] = @DateTo))", conn);
           cmd.Parameters.Add("@DateFrom", SqlDbType.DateTime).Value = fromDate;
           cmd.Parameters.Add("@DateTo", SqlDbType.DateTime).Value = toDate;
           DataSet objDs = new DataSet();
           SqlDataAdapter sd = new SqlDataAdapter(cmd);
           conn.Open();
           sd.Fill(objDs);
           conn.Close();
           if (objDs.Tables[0].Rows.Count > 0)
           {
               ddlname.DataSource = objDs;

               ddlname.DataTextField = "emp_name";
               ddlname.DataValueField = "emp_name";

               ddlname.DataBind();

           }

where am i going wrong??

Posted 11-Sep-13 6:17am

Member 10066916

Updated 11-Sep-13 6:18am

Richard C Bishop

v2

Add a Solution

Comments

ZurdoDev 11-Sep-13 12:26pm

Put a breakpoint and walk through your code and let us know what is wrong.

Member 10066916 11-Sep-13 12:28pm

I did that...Its taking in the from date and to date values from the textbox...but it skips the if condition...and thats y the dropdown list is empty

ZurdoDev 11-Sep-13 12:30pm

So, there's your answer. There are not tables which means your SQL is not returning any rows. So, what's the question?

Member 10066916 11-Sep-13 13:03pm

thank you ryan :)

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2013-09-11T06:30:00

When you talk about a date range, you normally mean "all dates between 2nd Feb 2012 and 14th Jun 2013" or similar - but your code doesn't try to do that, so I'm left a little confused as to what you are trying to achieve, especially when you describe what you want as "if a user selects say 6th may as the from date and 10th may as the to date,All the names within that date range".

The code you have checks for two specific conditions: "the start date is exactly this date", and "the end date is exactly that date". If you do want a range, such as "the start and end dates must be between the start and end dates" then it's pretty simple:

SQL

SELECT * FROM MyTable WHERE created_date BETWEEN @DateFrom AND @DateTo AND todate BETWEEN @DateFrom AND @DateTo

If that isn't what you are trying to do, then we need a better description of what you do expect to happen, perhaps with an example or two.