日期时间错误..... Gridview更新。 [英] Error in date time.....Gridview updating.

问题描述

嗨frnds，



请你能帮我解决这个错误。



转换一个char数据类型为日期时间数据类型导致超出范围的日期时间值。

该语句已被终止。



这个代码在Gridview更新按钮单击。我在Gridview中有一个更新图像按钮。



在数据库中我给了Issuedate和ExpiryDate DATATYPE作为DateTime。

Hi frnds,

Please can you help me this error.

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.

This code is in Gridview Update Button Click. I have a Update Image Button In Gridview.

In Database I gave Issuedate and ExpiryDate DATATYPE as DateTime.

protected void btnUpdate_Click(object sender, EventArgs e)
   {
       con.Open();

SqlCommand cmd = new SqlCommand（UPDATE AddUsers SET FirstName ='+ txtfname.Text +'，LastName ='+ txtlname.Text +'，EmpNo ='+ txtEmpNo.Text +'，Sponsor ='+ txtSponsor.Text +'， ManagerName ='+ txtManagerName.Text +'，Dept ='+ txtDepartment.Text +'，Location ='+ txtLocation.Text +'，OffTelNo ='+ txtOffTelNo.Text +'，MobileNo = '+ txtMobileNo.Text +'，IssuedDate ='+ txtIssueDate.Text +'，ExpiryDate ='+ txtExpiryDate.Text +'其中Id = @ Id，con）;

SqlCommand cmd = new SqlCommand("UPDATE AddUsers SET FirstName='" + txtfname.Text + "',LastName='" + txtlname.Text + "',EmpNo='" + txtEmpNo.Text + "',Sponsor='" + txtSponsor.Text + "',ManagerName='" + txtManagerName.Text + "', Dept='" + txtDepartment.Text + "',Location='" + txtLocation.Text + "',OffTelNo='" + txtOffTelNo.Text + "',MobileNo='" + txtMobileNo.Text + "',IssuedDate='" + txtIssueDate.Text + "',ExpiryDate='" + txtExpiryDate.Text + "' Where Id=@Id", con);

cmd.Parameters.AddWithValue("@FirstName", txtfname.Text);
        cmd.Parameters.AddWithValue("@LastName", txtlname.Text);
        cmd.Parameters.AddWithValue("@EmpNo", txtEmpNo.Text);
        cmd.Parameters.AddWithValue("@Sponsor", txtSponsor.Text);
        cmd.Parameters.AddWithValue("@ManagerName", txtManagerName.Text);

        cmd.Parameters.AddWithValue("@Dept", txtDepartment.Text);

        cmd.Parameters.AddWithValue("@Location", txtLocation.Text);

        cmd.Parameters.AddWithValue("@OffTelNo", txtOffTelNo.Text);

        cmd.Parameters.AddWithValue("@MobileNo", txtMobileNo.Text);

        cmd.Parameters.AddWithValue("@IssuedDate", txtIssueDate.Text);

        cmd.Parameters.AddWithValue("@ExpiryDate", txtExpiryDate.Text);
        cmd.Parameters.AddWithValue("@Id", Convert.ToInt32(lblID.Text));

 cmd.ExecuteNonQuery();
        con.Close();

 ScriptManager.RegisterStartupScript(this, this.GetType(), "RunCode", "javascript:alert('Updated successfully');", true);
        BindGV();
}

这是点击更新按钮时的错误。



将char数据类型转换为datetime数据类型会导致日期时间值超出范围。

语句已终止。



请帮忙。谢谢。

This is the error am getting when update button click.

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.

Please help. THANKS.

推荐答案

DateTime txtMyDate = DateTime.ParseExact(txtDate.Text, , "dd/MM/yyyy",CultureInfo.InvariantCulture) 

你必须解析TextBox DateTime的值首先

尝试今年5月解决您的查询

you have to Parse the TextBox Values to DateTime First
Try this May this Solves your Query

这篇关于日期时间错误..... Gridview更新。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！