我的用户注册代码老是出错,大家帮看看啊(新手)
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
SqlConnection conn = new SqlConnection( "server=.;database=reg;uid=sa;pwd=57744003; ");
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "insert into users(username,userpwd,email) values( ' " + txtusername.Text + " ', ' " + txtpassword.Text + " ', ' " + txtemail.Text + " ') ";
cmd.Connection = conn;
cmd.ExecuteNonQuery();
Response.Write( " <script> alert( '注册成功 ') </script> ");
SqlConnection conn1=new SqlConnection( "server=.;database=reg;uid=sa;pwd=57744003; ");
conn1.Open();
SqlCommand cmd1 = new SqlCommand( "select count(*) from users where username= ' " + txtusername.Text + " ' ", conn);
int count = Convert.ToInt32(cmd1.ExecuteScalar());
&