asp.net连接sqlserver不成功

asp.net连接sqlserver不成功
输入注册信息后点击提交按钮没有转入下一个界面,看是不是连接数据库的问题。
代码如下:
private bool doCheck(string condValue,string type=“LOGIN”)
{
bool ret = true;
string strConn =
WebConfigurationManager.ConnectionStrings[“在线测试ConnectionString”].ConnectionString;
SqlConnection con = new SqlConnection(strConn);
con.Open();
SqlCommand cmd = new SqlCommand(“SELECTFROM user WHERE usernumber = @cond_value", con);
if (type.Equals(“URL”))
cmd.CommandText = "SELECT
FROM user WHERE homeUrl = @cond_value”;
cmd.Parameters.AddWithValue("@cond_value", condValue);
SqlDataReader reader = cmd.ExecuteReader();
while(reader.Read())
{
ret = false;
}
cmd = null;
con.Close();
con = null;
return ret;
}
protected void Button3_Click(object sender, EventArgs e)
{
if (!doCheck(TextBox2.Text))
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), “success”, “alert(“该学号已存在”);”, true);
return;
}
string strConn = WebConfigurationManager.ConnectionStrings[“在线测试ConnectionString”].ConnectionString;
SqlConnection con = new SqlConnection(strConn);
con.Open();
SqlCommand cmd = new SqlCommand(“INSERT INTO user(username,” +
“usernumber,” +
“userpassword) values(@user_name, " +
“@user_number,” +
“@user_password)”, con);
cmd.Parameters.AddWithValue(”@user_name", TextBox1.Text);
cmd.Parameters.AddWithValue("@user_number", TextBox2.Text);
SHA1CryptoServiceProvider sha1csp = new SHA1CryptoServiceProvider();
byte[] src = System.Text.Encoding.UTF8.GetBytes(TextBox3.Text);
byte[] des = sha1csp.ComputeHash(src);
int count = cmd.ExecuteNonQuery();
if (count == 1)
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), “success”, “alert(“恭喜你,注册成功”);”, true);
else
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), “success”, “alert(“注册失败”);”, true);
cmd = null;
con.Close();
con = null;
Response.Redirect(“login.aspx”);
}
web.config配置:
 
   
 
 
   
 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值