[冷枫].NET现成程序给你用[一]

string UserName=Request.Form["name"];
   string upassword=Request.Form["password"];
   string urpassword=Request.Form["rpassword"];

   SqlConnection myConn=DBCONN.CreateCon();
   myConn.Open();
   string strSql = "select * from user01 where name='"+UserName+"'";
   SqlCommand cmd= new SqlCommand(strSql,myConn);
   SqlDataReader myrs = cmd.ExecuteReader();
   if (myrs.Read())
   {
    L_Check.Text="对不起,该会员名已经存在,请更换再注册,谢谢!";
   }
   else
   { myConn.Close();
    myConn.Open();
    string SqlStr="insert into user01 (name,password,rpassword) values"
    +"('"+UserName+"','"+upassword+"','"+urpassword+"')";
    SqlCommand SqlCmd=new SqlCommand(SqlStr,myConn);
    SqlCmd.ExecuteNonQuery();
    Session["UserName"]=name.Text ;//生成用户的Session
    Response.Redirect ("index.aspx");//转向首页，起刷新作用
   
    
   }
   myrs.Close ();//一切读取行为结束后，一定要关闭阅读器
   myConn.Close();