日期时间选择器转换时出错

Question

这是我的错误

即使我尝试过：dtp_ngaycap.Value 它仍然证实了我的错误。 这是CNcommands类的代码

   public bool CNcommands(string commandType,string tenchunha,string nguoidaidien, string chucvu, int soCMDN, DateTime ngaycap, string diachi, string masothue, string nguoithuhuong, string sotaikhoan,string nganhang,string sodienthoai, string diachiemail, string diachinganhang, int maCN)
    {
        if (commandType == "insert")
        {
            string insertCN = "INSERT INTO [QLThueNha].[dbo].[ChuNha][MaChuNha],[TenChuNha],[Nguoidaidien],[Chucvu],[SoCMND],[Ngaycap],[Diachi],[Masothue],[Nguoithuhuong],[Sotaikhoan],[Nganhang],[Sodienthoai],[DiachimailCN],[Diachinganhang])VALUES('" + tenchunha + "','" + nguoidaidien + "','" + chucvu + "','" + soCMDN + "','" + ngaycap + "','" + diachi + "','" + masothue + "','" + nguoithuhuong + "','" + sotaikhoan + "','" + nganhang + "','" + sodienthoai + "','" + diachiemail + "','" + diachinganhang + "')";
            if (executeQuery(insertCN, ref rowAffect_) == true && rowAffect_ == 1)
            {
                return true;
            }
            return true;
        }
        else if (commandType == "update")
        {
            string updateCN = "UPDATE [QLThueNha].[dbo].[ChuNha]  SET [TenChuNha] = '" + tenchunha + "',[Nguoidaidien] = '" + nguoidaidien + "',[Chucvu] = '" + chucvu + "',[SoCMND] = '" + soCMDN + "',[Ngaycap] = '" + ngaycap + "',[Diachi] = '" + diachi + "',[Masothue] = '" + masothue + "',[Nguoithuhuong] = '" + nguoithuhuong + "',[Sotaikhoan] = '" + sotaikhoan + "',[Nganhang] = '" + nganhang + "',[Sodienthoai] = '" + sodienthoai + "',[DiachimailCN] = '" + diachiemail + "',[Diachinganhang] = '" + diachinganhang + "' WHERE <Search Conditions,,>";
            if (executeQuery(updateCN, ref rowAffect_) == true && rowAffect_ == 1)
            {
                return true;
            }
            return true;
        }
        else
        {
            return false;
        }
        //if (commandType == "delete")
        //{
        //    string deleteCN = "SET [TenChuNha] = '" + tenchunha + "',[Nguoidaidien] = '" + nguoidaidien + "',[Chucvu] = '" + chucvu + "',[SoCMND] = '" + soCMDN + "',[Ngaycap] = '" + ngaycap + "',[Diachi] = '" + diachi + "',[Masothue] = '" + masothue + "',[Nguoithuhuong] = '" + nguoithuhuong + "',[Sotaikhoan] = '" + sotaikhoan + "',[Nganhang] = '" + nganhang + "',[Sodienthoai] = '" + sodienthoai + "',[DiachimailCN] = '" + diachiemail + "',[Diachinganhang] = '" + diachinganhang + "' WHERE <Search Conditions,,>";
        //    if (executeQuery(deleteCN, ref rowAffect_) == true && rowAffect_ == 1)
        //    {
        //        return true;
        //    }
        //}

    }

Answer 1

由于传递给 CNcommands 方法的最后一个参数而引发 FormatException：

int.Parse("");

另请检查 Convert.ToDateTime("");//note如果您使用的是DateTimePicker，则无需解析为Convert.ToDateTime，因为dateTimePicker.Value是DateTime。

还要检查 int.Parse(txt_sosmdn.Text)

但是您还应该考虑重构您的方法。

Answer 2

问题是您正在尝试将无效值解析为 int..
int.Parse 将数字的字符串表示形式转换为其等效的 32 位有符号整数。
该字符串必须是有效的数字，因此请在那里提供有效的数字..

就像

    int.Parse("0");