外部组件引发的异常。 [英] 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屋!
查看全文