外部组件引发的异常。 [英] External component has thrown an exception.

问题描述

我的日期时间错误，它给了我错误

My date time has an error where it gives me the error

string d = Request.QueryString["ava"];
string c = Request.QueryString["to"];
string strConnString = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection con = new SqlConnection(strConnString);
int term = Convert.ToInt32(Request.QueryString["term"]);
double rate = Convert.ToDouble(Request.QueryString["rate"]);
DateTime a = Convert.ToDateTime(d);
DateTime b = Convert.ToDateTime(c);
txtEff.Text = d;
txtExp.Text = c;
txtrate.Text = Convert.ToString(rate);
txtTerm.Text = Convert.ToString(term);
txtType.Text = Request.QueryString["type"];

string str = "Select id from LoanRates where LoanTerm=@term and LoanRate=@rate and LoanAvailableFrom=@LoanAvailableFrom and LoanAvailableTo=@LoanAvailableTo and LoanType=@type";
SqlCommand insert = new SqlCommand(str, con);

insert.Parameters.AddWithValue("@term", int.Parse(txtTerm.Text));
insert.Parameters.AddWithValue("@rate", double.Parse(txtrate.Text));
insert.Parameters.AddWithValue("@type", txtType.Text);
//insert.Parameters.AddWithValue("@LoanAvailableFrom", DateTime.Parse(txtEff.Text));
//insert.Parameters.AddWithValue("@LoanAvailableTo", DateTime.Parse(txtExp.Text));
con.Open();

SqlDataReader reader = insert.ExecuteReader();
if (reader.Read())
{
    Lblid.Text = reader["Id"].ToString();
    con.Close();
}

推荐答案

你为什么要做这样奇怪的事情：

Why do you do such weird things like:

string d = Request.QueryString["ava"];
DateTime a = Convert.ToDateTime(d);
txtEff.Text = d;
//insert.Parameters.AddWithValue("@LoanAvailableFrom", DateTime.Parse(txtEff.Text));

而不是 Convert.ToDateTime 使用 DateTime.ParseExact ，然后直接将该值用于SQL查询而不是TextBox内容：

insert.Parameters.AddWithValue（@ LoanAvailableFrom，a）;

当然，您还应该更好地命名变量。

Instead of Convert.ToDateTime use DateTime.ParseExact, and then use that value directly for your SQL query instead of a TextBox content:
insert.Parameters.AddWithValue("@LoanAvailableFrom", a);
Of course, you should also take care of better naming of your variables.

这篇关于外部组件引发的异常。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！