mysql varchar转bigint_将数据类型 varchar 转换为 bigint 时出错，求帮看代码

publicpartialclassFrontDesk_Login_UserRegister:System.Web.UI.Page{DataConmyCon=newDataCon();DataOperatesqlBind=newDataOperate();protectedvoidPage_Load(objectsender,EventA...

public partial class FrontDesk_Login_UserRegister : System.Web.UI.Page

{

DataCon myCon = new DataCon();

DataOperate sqlBind = new DataOperate();

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btnRegister_Click(object sender, EventArgs e)

{

string sqltest = "select * from tb_User where UserID='" + this.txtUserID.Text + "'";

SqlConnection sqlconn = myCon.getCon();

sqlconn.Open();

SqlCommand sqlcom = new SqlCommand(sqltest, sqlconn);

SqlDataReader read = sqlcom.ExecuteReader();

read.Read();

if (read.HasRows)

{

if (this.txtUserID.Text.Trim() == read["UserID"].ToString().Trim())

{

Response.Write("");

return;

}

}

string sqlstr = "insert into tb_User "

+ "(UserID,UserLoginName,UserSex,UserPwd,UserName,"

+ "UserQuePwd,UserAnsPwd,UserTel,UserEmail,UserAddress,UserPostCode,UserQQ)"

+ "values('" + txtUserID.Text + "','" + txtLoginName.Text + "','" + ddlSex.Text

+ "','" + txtPwd.Text + "','" + txtTName.Text + "','" + txtQuePwd.Text

+ "','" + txtAnsPwd.Text + "','" + txtTel.Text + "','" + txtEmail.Text

+ "','" + txtAddress.Text + "','" + txtPostCode.Text + "','" + txtQQ.Text + "')";

sqlBind.DataCom(sqlstr);

Response.Redirect("SuccessReg.aspx");

}

将数据类型 varchar 转换为 bigint 时出错。说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Data.SqlClient.SqlException: 将数据类型 varchar 转换为 bigint 时出错。

源错误:

行 67: SqlCommand sqlcom = new SqlCommand(sqlstr, sqlconn);

行 68: SqlDataReader read = sqlcom.ExecuteReader();

行 69: read.Read();

行 70: if (read.HasRows)

行 71: {

源文件: f:\BBS\FrontDesk\Login\UserRegister.aspx.cs 行: 69

展开