可以运行,但总提示 从数据类型 varchar 转换为 bigint 时出错。 (有颜色的那行)
代码如下,
sqlcon.Open();
SqlCommand sqlcom = new SqlCommand("select count(*) from tb_Member where MemberID='"+this.txtMemberID.Text+"'",sqlcon);
int count = Convert.ToInt32(sqlcom.ExecuteScalar());
if (count > 0)
{
Session["MemberID"] = this.txtMemberID.Text;
Response.Redirect("AnsQuestion.aspx");
}
else
{
Response.Write("<scipt>alert('没有该会员ID');location='javascript:history.go(-1)'</script>");
}
sqlcon.Close();
代码如下,
sqlcon.Open();
SqlCommand sqlcom = new SqlCommand("select count(*) from tb_Member where MemberID='"+this.txtMemberID.Text+"'",sqlcon);
int count = Convert.ToInt32(sqlcom.ExecuteScalar());
if (count > 0)
{
Session["MemberID"] = this.txtMemberID.Text;
Response.Redirect("AnsQuestion.aspx");
}
else
{
Response.Write("<scipt>alert('没有该会员ID');location='javascript:history.go(-1)'</script>");
}
sqlcon.Close();
sqlcon.Open();
SqlCommand sqlcom = new SqlCommand("select count(*) from tb_Member where MemberID=@mid",sqlcon);
sqlcom.Parameters.AddWithValue("@mid",this.txtMemberID.Text);
int count = Convert.ToInt32(sqlcom.ExecuteScalar());
if (count > 0)
{
Session["MemberID"] = this.txtMemberID.Text;
Response.Redirect("AnsQuestion.aspx");
}
else
{
Response.Write("<scipt>alert('没有该会员ID');location='javascript:history.go(-1)'</script>");
}
sqlcon.Close();
这样的话就不用考虑类型了。