从字符串转换日期/或时间时，转换失败

Question

用的VS2012版本写的程序，然后数据库是SQL2008版本。程序运行的时候这个部分一直出现这个问题，只要是涉及时间的。看了好久不知道哪里出错了。

数据库的话是这样设置的：

代码：
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace HotelManage
{
public partial class FormPurchase : Form
{
public FormPurchase()
{
InitializeComponent();
}
OperatorDBClass operat = new OperatorDBClass();

    private void InitDataGridViewHead()
    {
        this.dataGridViewPurchase.Columns[0].HeaderText = "商品编号";
        this.dataGridViewPurchase.Columns[0].Width = 100;

        this.dataGridViewPurchase.Columns[1].HeaderText = "供货商编号";
        this.dataGridViewPurchase.Columns[1].Width = 180;

        this.dataGridViewPurchase.Columns[2].HeaderText = "商品名称";
        this.dataGridViewPurchase.Columns[2].Width = 140;

        this.dataGridViewPurchase.Columns[3].HeaderText = "商品规格";
        this.dataGridViewPurchase.Columns[3].Width = 100;

        this.dataGridViewPurchase.Columns[4].HeaderText = "进价";
        this.dataGridViewPurchase.Columns[4].Width = 80;

        this.dataGridViewPurchase.Columns[5].HeaderText = "售价";
        this.dataGridViewPurchase.Columns[5].Width = 100;

        this.dataGridViewPurchase.Columns[6].HeaderText = "数量";
        this.dataGridViewPurchase.Columns[6].Width = 80;

        this.dataGridViewPurchase.Columns[7].HeaderText = "生产日期";
        this.dataGridViewPurchase.Columns[7].Width = 160;

        this.dataGridViewPurchase.Columns[8].HeaderText = "保质期";
        this.dataGridViewPurchase.Columns[8].Width = 160;

    }

    /// <summary>
    /// 录入商品信息
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    private void buttonOk_Click(object sender, EventArgs e)
    {
        try
        {
            if (textBoxId.Text != "" && textBoxName.Text != "" && textBoxBid.Text != "" && textBoxSellPrice.Text != "")
            {
                if (operat.FindIdExist("Products", "products_id", textBoxId.Text) == true)
                {
                    MessageBox.Show("该商品编号已经存在，请重新添加！", "提示");
                    return;
                }
                else
                {
                    string productor_id = this.textBoxId.Text;
                    string vendorsname = ""; //供货商名称
                    string productor_name = this.textBoxName.Text;
                    string productor_spec = this.comboBoxSpec.Text;
                    string productor_bid = this.textBoxBid.Text;
                    string productor_sell_price = this.textBoxSellPrice.Text;
                    string productor_date = this.dateTimePicker1.Text;
                    string productor_quality_date = this.comboBoxQuality.Text;

                    vendorsname = operat.FindVendorsId("Vendors", comboBoxVen.Text);

                    string InsertSql = "insert into Products values(" + productor_id + ",'"+ vendorsname+"','" + productor_name + "','";
                    InsertSql += productor_spec + "','" + productor_bid + "','" + productor_sell_price + "','"+textBoxProNum.Text+"','" + productor_date + "','";
                    InsertSql += productor_quality_date + "')";

                    if (operat.OperateData(InsertSql) > 0)
                    {
                        operat.StoreManage(productor_id, productor_sell_price,textBoxProNum.Text);
                        MessageBox.Show("录入商品信息成功!", "提示");
                        operat.DataBind(this.dataGridViewPurchase, "select *from Products", "Products");
                        return;
                    }
                }
            }
            else
            {
                MessageBox.Show("请填满所有字段", "提示");
                return;
            }
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message);
        }
        finally
        {
            //关闭数据库
            operat.CloseDatabaseCnn();
        }
    }

    private void FormPurchase_Load(object sender, EventArgs e)
    {
        operat.BindDropdownlist("Vendors", this.comboBoxVen, 1);
        operat.DataBind(this.dataGridViewPurchase, "select *from Products", "Products");
        InitDataGridViewHead();

        //绑定商品单位到下拉框
        operat.BindDropdownlist("Products_Unit", this.comboBoxSpec, 1);
    }
}

}

Answer 1

https://blog.csdn.net/lclcsdnblink/article/details/95048686