数据库日期中的格式为yymmdd，想与ddmmyy进行比较 [英] in database date is in yymmdd format,want to compare with ddmmyy

问题描述

请给我回复适当的答案

我的表中有fromdate列，该表以yyyymmdd格式存储日期.
我正在用c#编码，
我有一个文本框(txtfrmdate)，其值是我在日历中选择的值，
该值采用ddmmyyyy格式.

现在我想比较数据以从表中检索特定记录

现在，当我用c#
编写代码时 字符串sqlstr =从表1中选择*，其中fromDate =''"+ txtfrmdate.text +"'';

但它给我错误becoz，fromDate为yyyymmdd格式，并且
txtfrmdate为ddmmyyyy格式

请解决您的问题，如何解决这个问题?

Hi plz reply me with suitable ans

I am having fromdate column in a table which stores date in a yyyymmdd format.
and I am coding with c# ,
I am having one textbox (txtfrmdate)which is having value which I select in calender,
that value is in ddmmyyyy format.

now I want to compare the data to retrive particular records from table

now when I write the code in c#
string sqlstr = select * from Table1 where fromDate = ''"+ txtfrmdate.text+"'';

but it gives me error becoz ,fromDate is in yyyymmdd format and
txtfrmdate is in ddmmyyyy format

plz requesting you , how to slove this problem ???

推荐答案

避免为SQL查询构建字符串，请改用参数化查询

http://www.codinghorror.com/blog/2005/04/give-me-parameterized-sql-or-give-me-death.html [

Avoid building strings for SQL queries, use a parametized query instead

http://www.codinghorror.com/blog/2005/04/give-me-parameterized-sql-or-give-me-death.html[^]

datetime dt = Convert.ToDateTime(txtfrmdate.Text.Trim());

SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
string s = "SELECT * FROM table1 WHERE fromDate = @date";
SqlCommand cmd = new SqlCommand(s);
cmd.Parameters.Add("@date", dt);
SqlDataReader reader = cmd.ExecuteReader();

使用

Use

datetime dt = Convert.ToDateTime(txtfrmdate.Text.Trim());

string sqlstr = select * from Table1 where fromDate = ''"+dt+"'';

尝试以下代码..

Try this code..

datetime dt = Convert.ToDateTime(txtfrmdate.Text.tostring("yyyy/MM/dd"));
select * from Table1 where fromDate = ''"+ dt+"'';

这篇关于数据库日期中的格式为yymmdd，想与ddmmyy进行比较的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！