如何在Windows应用程序的asp.net中明智地搜索数据日期 [英] how to search data date wise in asp.net for windows application

问题描述

有人告诉我如何明智地搜索数据，我能够通过sql datareader从数据库中读取数据，在我的代码中是错误将字符串转换为smalldatetime数据类型时转换失败.

我已经在我的代码中获取了搜索数据，例如

cmd.Parameters.Add("COMP_DT"，SqlDbType.SmallDateTime).Value = dateTimePicker3.Text;

和

在
中显示
date2.Text = rdr ["DISP_DT"].ToString();


请一些帮助来解决此问题.文字:

 cmd.Parameters.Add(" ，SqlDbType.SmallDateTime) .Value = dateTimePicker3.Text; 

成为

 cmd.Parameters.AddWithValue(" ，dateTimePicker3.Value) ; 

value属性返回DateTime，它与区域性无关-因此您不必担心SQL格式还是用户格式.

尝试此代码

cmd.Parameters.AddWithValue("COMP_DT"，dateTimePicker3.Value);

Pls some one tell that how to search data date wise, i am able to read data from database by sql datareader, in my code ther is error Conversion failed when converting character string to smalldatetime data type.

i have taken for search data in my code like

cmd.Parameters.Add("COMP_DT", SqlDbType.SmallDateTime).Value = dateTimePicker3.Text;

and

showing in

date2.Text = rdr["DISP_DT"].ToString();


Pls some one help to solve this.

解决方案

Don''t use Add (it''s depreciated, use AddWithValue instead), and don''t use DateTimePicker.Text:

cmd.Parameters.Add("COMP_DT", SqlDbType.SmallDateTime).Value = dateTimePicker3.Text;

Becomes

cmd.Parameters.AddWithValue("COMP_DT", dateTimePicker3.Value);

The value property returns a DateTime, which is culture independent - so you don''t have to worry about SQL format versus user format.

try this code

cmd.Parameters.AddWithValue("COMP_DT", dateTimePicker3.Value);

这篇关于如何在Windows应用程序的asp.net中明智地搜索数据日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！