日期和时间问题 [英] Problem with date and time

问题描述

尊敬的先生/女士





i我正在使用visual studio 2005和sqlserver 2000



先生，当我运行我的网页然后问题发生在行中

字符串无法识别为有效日期时间

Dear sir/ma''am


i am using visual studio 2005 and sqlserver 2000

sir when i run my webpage then problem occur in the line as
String not recognized as valid date time

cm = New SqlCommand("select * from h_leave where holi_date1='" & Convert.ToDateTime(Me.txt_frmdate.Text).ToString("MM/dd/yyyy") & "' or holi_date2='" & Convert.ToDateTime(Me.txt_todate.Text).ToString("MM/dd/yyyy") & "' or (holi_date1 between '" & Convert.ToDateTime(Me.txt_frmdate.Text).ToString("MM/dd/yyyy") & "' and '" & Convert.ToDateTime(Me.txt_todate.Text).ToString("MM/dd/yyyy") & "')or(holi_date2 between '" & Convert.ToDateTime(Me.txt_frmdate.Text).ToString("MM/dd/yyyy") & "' and '" & Convert.ToDateTime(Me.txt_todate.Text).ToString("MM/dd/yyyy") & "')", con)

帮我检查日期值

help me to check the date value

推荐答案

而不是做这个字符串连接垃圾，使用参数化查询。谷歌的vb.net参数化查询，你应该做什么和为什么。您的代码引入了可能会消灭数据库的安全风险。

Instead of doing this string concatenation garbage, use a parameterized query. Google for "vb.net parameterized query" for what you should be doing and why. Your code introduced security risks that can wipe out your database.

而不是Convert.ToDateTime（）尝试

Instead of Convert.ToDateTime() try

DateTime dt = DateTime.ParseExact(value, format, CultureInfo.InvariantCulture);

这篇关于日期和时间问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！