Question

.net中存储过程的问题、急，在线等！！！！

BLLBG_Bargain.ExcuteProductCommand("usp_InsertUpdateBG_Bargain",
new SqlParameter("@BG_OP_Time", DateTime.Now.ToShortDateString().ToString()), //设为字符串了
new SqlParameter("@BG_STime", DateTime.Now.ToShortDateString().ToString()),
new SqlParameter("@BG_SNode",txtSNode.Text),
new SqlParameter("@BG_SName",txtSName.Text),
new SqlParameter("@BG_TNode",txtTNode.Text),
new SqlParameter("@BG_TName",txtTName.Text),
new SqlParameter("@BG_Etype",txtNO.Text),
new SqlParameter("@BG_BCard",txtCardNo.Text),
new SqlParameter("@BG_GCode",txtGCode.Text),
new SqlParameter("@BG_SD_Linker",txtFLinker.Text),
new SqlParameter("@BG_SD_LkCode",txtFPhone.Text),
new SqlParameter("@BG_RC_Linker",txtSLinker.Text),
new SqlParameter("@BG_RC_LkCode",txtSPhone.Text),
new SqlParameter("@BG_RC_Addr",txtAddress.Text),
new SqlParameter("@BG_BMode",int.Parse(dlMode.SelectedValue.ToString())),
new SqlParameter("@BG_Number",int.Parse(txtSNumber.Text)),
new SqlParameter("@BG_Remain",int.Parse(txtSNumber.Text)),
new SqlParameter("@BG_OP_Name",users.Ur_Name),
new SqlParameter("@BG_Remark",txtRemark.Text),
new SqlParameter("@BG_GPayment", Convert.ToDouble(txtPayment.Text)),
new SqlParameter("@BG_GFreight", Convert.ToDouble(txtNextFreight.Text)),
new SqlParameter("@BG_GIFreight", Convert.ToDouble(txtInfoMoney.Text)),
new SqlParameter("@BG_RFreight", Convert.ToDouble(txtSFreight.Text)),
new SqlParameter("@BG_SJ_Freight", Convert.ToDouble(txtSFreight.Text)),
new SqlParameter("@BG_SCharge", Convert.ToDouble(txtSCharge.Text)),
new SqlParameter("@BG_SG_Freight", Convert.ToDouble(txtInfoMoney.Text)),
new SqlParameter("@BG_RMode",int.Parse(dlMode.SelectedValue.ToString())),
new SqlParameter("@BG_PreFreight", Convert.ToDouble(txtPreFreight.Text.ToString())),
new SqlParameter("@BG_Hui",int.Parse(rblHui.Text.ToString())),
new SqlParameter("@BG_Xian",int.Parse(rblXian.Text.ToString())));
老是报输入的字符串格式不正确、、求救！！！

Answer 1

一一查看下你存储过程的变量类型是否与传入的参数类型对应，问题基本在此。

Answer 2

定义的参数类型和参入的参数类型你自己审查一下，估计问题就在这里，以前我也经常遇到，都这样解决了滴~~