附加信息：从字符串转换日期和/或时间时转换失败。 [英] Additional information: conversion failed when converting date and/or time from character string.

问题描述

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll

Additional information: Conversion failed when converting date and/or time from character string.

cmd = new SqlCommand();
            cmd.Connection = con;
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "INSERT INTO [dbo].[faculty] ([fac_id], [Fname], [Lname], [gender], [dob], [email], [country], [city], [hire_date], [salary], [commission], [fac_rank], [crs_id]) VALUES (@fac_id, @Fname, @Lname, @gender, @dob, @email, @country, @city, @hire_date, @salary, @commission, @fac_rank, @crs_id)";

            cmd.Parameters.AddWithValue("@fac_id", fac_idTextBox.Text);
            cmd.Parameters.AddWithValue("@Fname", fnameTextBox.Text);
            cmd.Parameters.AddWithValue("@Lname", lnameTextBox.Text);
            cmd.Parameters.AddWithValue("@gender", genderTextBox.Text);

            cmd.Parameters.AddWithValue("@dob", DateTime.Parse(dobDateTimePicker.Text));
            cmd.Parameters.AddWithValue("@email", emailTextBox.Text);
            cmd.Parameters.AddWithValue("@country", countryTextBox.Text);
            cmd.Parameters.AddWithValue("@city", cityTextBox.Text);

            cmd.Parameters.AddWithValue("@hire_date", DateTime.Parse(hire_dateDateTimePicker.Text));
            cmd.Parameters.AddWithValue("@salary", salaryTextBox.Text);
            cmd.Parameters.AddWithValue("@commission", commissionTextBox.Text);
            cmd.Parameters.AddWithValue("@fac_rank", fac_rankTextBox.Text);
            cmd.Parameters.AddWithValue("@crs_id", crs_idTextBox.Text);

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

我尝试过：



明天提交的plzz帮助

What I have tried:

all the things plzz help i have submit tomorrow

推荐答案

SQL在转换DateTime值时遇到问题。



你应该使用DateTimePicker.Value，因为这会返回一个DateTime值，而不是使用Text属性并转换它。



亲切的问候

SQL is having a problem converting your DateTime value/s.

You should be using DateTimePicker.Value as this returns a DateTime value instead of using the Text property & converting it.

Kind Regards

这篇关于附加信息：从字符串转换日期和/或时间时转换失败。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！