如何在查询之间写日期 [英] how to write date between query

问题描述

我想在两个日期之间汇总列值。

两个日期值来自asp日历。

如何编写sql查询并在文本框中显示结果。

例如：

i want to sum column values between two dates.
the two date values are coming from asp calender.
how to write sql query and display result in textbox.
for eexample:

query="select sum(column names) from tablename where date between calender1 and calender2"

推荐答案

刚刚通过Calendar1.SelectedDate，它是sql查询的DateTime值，但使用参数化查询来阻止防止SQL注入攻击ASP.NET - 第一部分 [ ^ ]

代码片段：

Just pass the Calendar1.SelectedDate which is a DateTime value to the sql query, but use parameterized query to prevent Preventing SQL Injection Attack ASP.NET - Part I[^]
The code snippet:

DateTime startDate = Calendar1.SelectedDate;
DateTime endtDate = Calendar2.SelectedDate;
string commandText = "select sum(column) from tablename where datecolumn between @startDate and @enddate";
using (SqlConnection connection = new SqlConnection(connectionString))
{
	SqlCommand command = new SqlCommand(commandText, connection);
	command.Parameters.AddWithValue("@startDate", startDate);
	command.Parameters.AddWithValue("@endDate", endDate);
        Int32 sum = (Int32) command.ExecuteScalar();
        Textbox1.Text = sum.ToString();
}

参考：

1. Calendar.SelectedDate Property [ ^ ]

2. SqlCommand.Parameters Property [ ^ ]

这篇关于如何在查询之间写日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！