使用 C# 查询 EXCEL 日期

发布于 2024-09-13 03:20:22 字数 769 浏览 4 评论 0原文

我试图使用 C# 中的查询制作 Excel 图表，我需要收集上个月的数据。我正在使用以下代码，它没有给出任何错误，但也没有给出任何结果。

基本上我有 Excel 表格中的数据，并使用这些数据制作图表。

首先，我获取两个日期并将它们转换为短字符串，然后将字符串与从 Excel 中以短强格式选取的日期进行匹配。

如果有人能回答，我将非常感谢帮助。

谢谢，

代码：

// Get current date and time
DateTime dtx = DateTime.Now;
string Date = dtx.ToShortDateString();

// Calculating the last month's date (substracting days from current date.)
DateTime lastmonth= DateTime.Today.AddDays( -30 );
string Date2 = lastmonth.ToShortDateString();

OleDbCommand objCmdSelect = new OleDbCommand(
"SELECT [Hour],(Format(Date, 'Short Date')) AS text_Date,[U_CSSR] FROM [" + excelSheets[j] + "] WHERE CI=" + id + " AND (Format(Date, 'Short Date'))BETWEEN "+ Date + " AND "+ Date2 + " ", objConn);

原文

I was trying to make excel graphs using query in c# and I need to collect data for the last month. I am using the following code and its not giving any error but its not giving any result either.

Basicaly I have the data in excel sheets and using that data im making graphs.

First im geting the two dates and converting them to short string and then im matching the strings with the dates picked from excel in the short strong format.

If anyone could answer, I would really appreciate help.

Thankyou,

THE CODE:

// Get current date and time
DateTime dtx = DateTime.Now;
string Date = dtx.ToShortDateString();

// Calculating the last month's date (substracting days from current date.)
DateTime lastmonth= DateTime.Today.AddDays( -30 );
string Date2 = lastmonth.ToShortDateString();

OleDbCommand objCmdSelect = new OleDbCommand(
"SELECT [Hour],(Format(Date, 'Short Date')) AS text_Date,[U_CSSR] FROM [" + excelSheets[j] + "] WHERE CI=" + id + " AND (Format(Date, 'Short Date'))BETWEEN "+ Date + " AND "+ Date2 + " ", objConn);

分享到QQ

分享到微博