将字符串数据类型转换为日期数据类型 [英] convert string data type to date datatype

问题描述

如何将文本框值转换为日期数据类型.有人帮助我.在下面有我的代码
cm.Parameters.Add("@fromdate", SqlDbType.Date) = Convert.ToDateTime(txtfromdate.Text);
它向我显示错误:您无法将日期强制更改为datetime".我将如何进行转换..

Thnaks

Hi,

How to convert textbox value to date datatype.anbody help me.in below there is my code
cm.Parameters.Add("@fromdate", SqlDbType.Date) = Convert.ToDateTime(txtfromdate.Text);
it shows me error that" You can''t forcefully change the date to datetime".How how will i convert it..

Thnaks

推荐答案

似乎您错过了在代码上添加Value的问题.试试这个.

cm.Parameters.Add("@fromdate", SqlDbType.Date).Value = Convert.ToDateTime(txtfromdate.Text);

It seems you missed to add Value on your code. Try this.

cm.Parameters.Add("@fromdate", SqlDbType.Date).Value = Convert.ToDateTime(txtfromdate.Text);

文本框的第一个修复日期时间格式.
然后用这个

first fix datetime format of your textbox.
Then use this

System.Globalization.DateTimeFormatInfo dateInfo = new System.Globalization.DateTimeFormatInfo();
dateInfo.ShortDatePattern = "dd/MM/yyyy";//This may depend on your format
cm.Parameters.Add("@fromdate", SqlDbType.DateTime).Value = Convert.ToDateTime(txtfromdate.Text, dateInfo);

如果要传递DateTime值，则需要使用SqlDbType.DateTime作为参数.
cm.Parameters.Add("@fromdate", SqlDbType.DateTime)

解决此问题的第二种方法是尝试Convert.ToDateTime(txtfromdate.Text) .Date .
只需传递Date值而不是DateTime.

You need to use SqlDbType.DateTime as your parameter if you are going to pass a DateTime value.
cm.Parameters.Add("@fromdate", SqlDbType.DateTime)

The second way to fix this could be to try Convert.ToDateTime(txtfromdate.Text).Date.
Just pass in the Date value instead of DateTime.

这篇关于将字符串数据类型转换为日期数据类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！