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 = "SELECTFROM 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配置:
asp.net连接sqlserver不成功
最新推荐文章于 2022-11-07 22:55:49 发布