retrieving data from database which lies between two dates

Question

0.00/5 (No votes)

See more:

I have one drop down list where i select vendor name and in another two text boxes i enter two dates one is from date and another To date.When i click on Display order button,it should display all the orders placed between those two dates having selected vendor name.But i am getting no records found message what ever date i select.Please help me to resolve this.my button click code is below.please help me.

C#

protected void btndisplayordr_Click(object sender, EventArgs e)
    {


        DataTable dt = Periodicalcls.LoadPeriodicalprintdetails(txtvndrname.SelectedItem.Value, txtfrmdate.Text, txttodate.Text);
        if (dt.Rows.Count > 0)
        {
            lblmsg.Text = "";
            grdprinord.DataSource = dt;
            grdprinord.DataBind();
        }
        else
        {
            lblmsg.Text = "No Orders Found.";
        }


    }

C#

public static DataTable LoadPeriodicalprintdetails(string p, string p_2, string p_3)
   {
       try
       {
           return clsDbCommon.GetDataTable("[Lib_selectperioprintdetails]", new Object[] { "@VendorName", "@OrderDate", "@OrdDate" }, new Object[] { p, p_2, p_3 });
       }
       catch
       {
           throw;
       }
   }

Posted 13-Aug-13 2:50am

Member 10194425

Add a Solution

Comments

pradiprenushe 13-Aug-13 12:32pm

What problem you are facing? How you are writing query/sp? What is your table column types for date?

kishore sharma 14-Aug-13 1:48am

need more details, how is your query?

4 solutions

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)

Mukesh Ghosh · Answer 1 · 2013-08-13T02:59:00

Solution 1

Instead of passing Date as a string, pass as Datetime

Posted 13-Aug-13 2:59am

Mukesh Ghosh

Updated 13-Aug-13 6:10am

v2

Dholakiya Ankit · Answer 2 · 2013-08-13T18:30:00

This may also help you..

SQL

select * from yourtablename where
(CAST(CONVERT(varchar(10), your column name of date , 101) AS datetime) <= CAST(CONVERT(varchar(10), todate, 101) AS datetime)) 
	AND (CAST(CONVERT(varchar(10), your column name of date , 101) AS datetime) <= CAST(CONVERT(varchar(10), fromdate, 101) AS datetime))

regards...:)

Member 10186638 · Answer 3 · 2013-08-13T23:26:00

C#

public DataTable Date_Select_ByDate(String vendorName,String d1,String d2)
{
     DateTime D1=Convert.ToDateTime(d1);
     DateTime D2=Convert.ToDateTime(d2);
     DB_Connection();
     DataSet DS = new DataSet();
     string Date_All = "";
    Date_All = "SELECT  VendorName,CONVERT(char(10),OrderDate, 103) AS OrderDate,CONVERT(char(10),OrdDate, 103) AS OrdDate FROM Lib_selectperioprintdetails where VendorName='"+vendorName+"' OrderDate between '" + D1 + "' and '" + D2 + "'";
            SqlDataAdapter DA = new SqlDataAdapter(Date_All, con);
            
     DA.Fill(DS);
     DataTable DT = DS.Tables[0];
     return DT;

        }

Member 8622273 · Answer 4 · 2013-08-13T03:00:00

Solution 2

try

C#

select * from table where datecol>='"+fromdate.ToStrong("dd-mm-yyyy")+"' and datecol<'"+todate.ToString("dd-mm-yyyy")+"'

Posted 13-Aug-13 3:00am

Member 8622273

Updated 13-Aug-13 6:09am

v2

Comments

Member 12360714 1-Mar-16 4:05am

@Maciej Los ,ToString The method ToString(String) is undefined for the type Date

retrieving data from database which lies between two dates

4 solutions

Solution 1

Solution 3

Solution 4

Solution 2

Add your solution here

Preview 0