varchar转成datetime

[caijingui]

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;
}
}

[EnForGrass]

fields1.Add("LastModifiedDate", Convert.ToDateTime(txtLastModifiedDate.Text.Trim()));

[gxingmin]

DateTime lastModifiedDate=DateTime.MinValue; if(DateTime.TryParse(txtLastModifiedDate.Text.Trim(), out lastModifiedDate)) fields1.Add("LastModifiedDate", lastModifiedDate); else fields1.Add("LastModifiedDate", null);

[Chobohoo]

只看这一句: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. 日期范围超出了?

[linrachel]

加个断点，看看要转换的字符串是什么，格式有没有问题。

[caijingui]

引用 楼主 caijinguinet123 的回复:

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; } }

是不是可以在存储过程里转

[caijingui]

引用 4 楼 linrachel 的回复:

加个断点，看看要转换的字符串是什么，格式有没有问题。

没有

[caijingui]

引用 3 楼 zhuoweizhao 的回复:

只看这一句: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. 日期范围超出了?

没有可以正常转为日期格式的字符串，没走出范围

[md5e]

要看fields1.Add的方法是什么了

[caijingui]

现在好了，正常了

[u010612747]

能加个QQ告诉我 这是什么问题导致的吗？我也遇到了同样的问题 QQ：99082591