试图在数据库中插入数据,但它返回该错误和我尝试以这种格式添加的日期格式示例:20/05/2015
我的代码:
bool flag = gh.Set_PolicyInfo(Convert.ToString(ComBoxBranchName.SelectedItem.Text),
"DEPT_06",
TxtPolicyNo.Text,
Convert.ToString(ComBoxPolicyType.SelectedItem.Text),
Convert.ToDateTime(TxtPolicyDate.Text), Convert.ToString(ComBoxAccNametst.Text),
Convert.ToDouble(TxtPlcyAmt.Text), Convert.ToDouble(TxtIssueFee.Text),
Convert.ToDouble(TxtSprvisionFee.Text), Convert.ToDouble(TxtTransFee.Text),
Convert.ToInt32(TxtDiscountPER.Text), Convert.ToDouble(TxtDiscountAMT.Text),
Convert.ToDouble(TxtTotalAmt.Text), Convert.ToDouble(TxtNetAmt.Text),
DateTime.ParseExact(TextStartDate.Text.ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture),
DateTime.ParseExact(TxtEndDate.Text.ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture),
'A',
DateTime.ParseExact("20042012", "dd/MM/yyyy", null), "DEVP");
由于您正在使用ParseExact
,因此您的字符串需要与格式字符串完全匹配。这意味着分隔符也必须存在。
所以我看到两个选择:
1.使用适当的格式传递日期
bool flag = gh.Set_PolicyInfo(Convert.ToString(ComBoxBranchName.SelectedItem.Text), "DEPT_06", TxtPolicyNo.Text, Convert.ToString(ComBoxPolicyType.SelectedItem.Text), Convert.ToDateTime(TxtPolicyDate.Text), Convert.ToString(ComBoxAccNametst.Text), Convert.ToDouble(TxtPlcyAmt.Text), Convert.ToDouble(TxtIssueFee.Text), Convert.ToDouble(TxtSprvisionFee.Text), Convert.ToDouble(TxtTransFee.Text), Convert.ToInt32(TxtDiscountPER.Text), Convert.ToDouble(TxtDiscountAMT.Text), Convert.ToDouble(TxtTotalAmt.Text), Convert.ToDouble(TxtNetAmt.Text),DateTime.ParseExact(TextStartDate.Text.ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture), DateTime.ParseExact(TxtEndDate.Text.ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture), 'A', DateTime.ParseExact("20/04/2012", "dd/MM/yyyy", null), "DEVP");
2.从格式字符串中删除分隔符
bool flag = gh.Set_PolicyInfo(Convert.ToString(ComBoxBranchName.SelectedItem.Text), "DEPT_06", TxtPolicyNo.Text, Convert.ToString(ComBoxPolicyType.SelectedItem.Text), Convert.ToDateTime(TxtPolicyDate.Text), Convert.ToString(ComBoxAccNametst.Text), Convert.ToDouble(TxtPlcyAmt.Text), Convert.ToDouble(TxtIssueFee.Text), Convert.ToDouble(TxtSprvisionFee.Text), Convert.ToDouble(TxtTransFee.Text), Convert.ToInt32(TxtDiscountPER.Text), Convert.ToDouble(TxtDiscountAMT.Text), Convert.ToDouble(TxtTotalAmt.Text), Convert.ToDouble(TxtNetAmt.Text),DateTime.ParseExact(TextStartDate.Text.ToString(), "ddMMyyyy", CultureInfo.InvariantCulture), DateTime.ParseExact(TxtEndDate.Text.ToString(), "ddMMyyyy", CultureInfo.InvariantCulture), 'A', DateTime.ParseExact("20042012", "ddMMyyyy", null), "DEVP");
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句