显示两个日期之间的数据 [英] Show data between two dates

问题描述

我想在两个日期之间从数据库中选择数据，它只在那个月显示数据，如果我想在两个月之间显示未显示的数据。

我正在使用此代码检索数据。

Hi, i want to select data from database between two dates, its showing data only that month, if i want to show data between two months its not showing.
I am using this code for retrieving data.

using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connection"].ConnectionString))
        {
            using (SqlCommand cmd = new SqlCommand("SELECT * FROM [tablename] where Date BETWEEN '"+txtDateFrom.Text+"' AND '"+txtToDate.Text+"'"))
            {
                using (SqlDataAdapter sda = new SqlDataAdapter())
                {
                    cmd.Connection = con;
                    sda.SelectCommand = cmd;
                    using (DataTable dt = new DataTable())
                    {
                        sda.Fill(dt);
                        GridView1.DataSource = dt;
                        GridView1.DataBind();
                    }
                }
            }
        }

推荐答案

Select * from Tablename where (Initiate_date BETWEEN '" + txtsdate.Text + "' AND '" + txtfdate.Text + "')

您可以使用以下SQL代码获取记录之间的日期

Hi,

You can use following code of SQL to get date between records

where Date BETWEEN Convert(DateTime,'"+txtFromDate.Text+"',101) AND Convert(DateTime,'"+txtToDate.Text+"',101)"

你也可以在DataTable对象上使用服务器端过滤器选项

you can also use server side filter option on DataTable object

DataTable dt = new DataTable();
//Date between datefrom and dateto expression like sql server
string strSQLExp = "Date=21/12/2013";
dt.Select(strSQLExp);

您用于将数据绑定到datacontrol





不要忘记将其标记为解决方案。



Happy Codding ...

N. ayan Chavada

that you have use for binding data to datacontrol


Don't forgot to mark this as solution if it is.

Happy Codding...
Nayan Chavada

试试这样，

Try like this,

SELECT * FROM tablename
WHERE datecolumn >= '"+txtDateFrom.Text+"'  AND datecolumn <=  '"+txtDateTo.Text+"'  

这篇关于显示两个日期之间的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！