varchar转成datetime
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
The statement has been terminated.这个是错误
以下是代码
MssqlFields fields1 = new MssqlFields();
fields1.Add("ActionType", "UpdateDate");
fields1.Add("BU", this.ddlBU.SelectedValue.ToString());
fields1.Add("Payee", this.ddlPayeer.SelectedValue.ToString());
fields1.Add("Supplier", this.ddlPayeer.SelectedValue.ToString());
fields1.Add("PartNo", txtPartNo.Text.Trim());
fields1.Add("VendorPartNo", txtVendorPartNo.Text.Trim());
fields1.Add("DescriptionCN", txtDescriptionCn.Text.Trim());
fields1.Add("DescriptionEN", txtDescriptionEN.Text.Trim());
fields1.Add("PalletSize", txtPalletSize.Text.Trim());
fields1.Add("PartNoProperty", ddlPartNoProperty.SelectedValue.ToString());
fields1.Add("PartNoType", ddlPartNoType.SelectedValue.ToString());
fields1.Add("PackageType", ddlPackType.SelectedValue.ToString());
if (ckbQICFlag.Checked == true)
{
fields1.Add("IQCFlag", "Y");
}
else
{
fields1.Add("IQCFlag", "N");
}
try
{
decimal ShippingRage = Convert.ToDecimal(txtShippingRage.Text.Trim());
int CtnByPlt = Convert.ToInt32(txtCtnByPlt.Text.Trim());
int QtyByCtn = Convert.ToInt32(txtQtyBtCn.Text.Trim());
int MinPackingQty = Convert.ToInt32(txtMinPackingQty.Text.Trim());
}
catch (Exception)
{
this.Page.RegisterStartupScript("", "<script>alert('你輸入的類型有誤，請查正后再保存！')</script>");
return;
}
fields1.Add("MinShippingUnit", ddlMinShippingUnit.SelectedValue.ToString());
fields1.Add("ShippingRate", txtShippingRage.Text.Trim());
fields1.Add("CtnByPlt", txtCtnByPlt.Text.Trim());
fields1.Add("QtyByCtn", txtQtyBtCn.Text.Trim());
fields1.Add("MinPackingUnit", ddlMinPackingUnit.SelectedValue.ToString());
fields1.Add("MinPackingQty", txtMinPackingQty.Text.Trim());
fields1.Add("Remark", txtRemark.Text.Trim());
fields1.Add("LastModifiedBy", txtLastModifiedBy.Text.Trim());
fields1.Add("LastModifiedDate", txtLastModifiedDate.Text.Trim());
MssqlDAL dal1 = new MssqlDAL(WebConfigLogic.ConnectionStringHUB, "Web_BasicData_VMIHUBPartno_sp", fields1);
DataSet ds1 = dal1.GetList();
if (ds1.Tables.Count > 0)
{
if (dal1.GetList().Tables[0].Rows[0][1].ToString() == "修改成功")
{
this.Page.RegisterStartupScript("", "<script>window.alert('修改成功！');location='PartNoPackageMaintainVMI.aspx';</script>");
}
else
{
JScriptlib.MsgBox("Update Date Failed!", "PartNoPackageMaintainVMIAdd1.aspx");
return;
}
}
[解决办法]
fields1.Add("LastModifiedDate", Convert.ToDateTime(txtLastModifiedDate.Text.Trim()));
------解决方案--------------------
只看这一句:
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
日期范围超出了?
[解决办法]
加个断点，看看要转换的字符串是什么，格式有没有问题。
[解决办法]
要看fields1.Add的方法是什么了
