private void Button1_Click(object sender, System.EventArgs e)
{
string strConn="server=xq;uid=sa;pwd=sa;database=Aspnet";
string strCmd="select count(*) from Ex09_User where UserName like '"+TextBox1.Text+"'";
SqlConnection myConnection=new SqlConnection();
myConnection.ConnectionString=strConn;
SqlCommand myCommand=new SqlCommand(strCmd,myConnection);
myCommand.Connection.Open(); //察看用户名是否存在
int flag=(int)myCommand.ExecuteScalar();
if (flag==0)
{
//将用户信息添加到数据表Ex_User中
string insCmd="insert Ex09_User(UserName,Pwd,Gender,QQ,EMail,WebStie,Regtime)valuse('"+TextBox1.Text+"','"+TextBox2.Text+"',"+RadioButtonList2.SelectedItem.Value+"','"+TextBox3.Text+"','"+TextBox4.Text+",'"+TextBox5.Text+",gendate())";
//Label1.Text=insCmd;
SqlCommand myIns=new SqlCommand(strCmd,myConnection);
    //myIns.Connection.Open();
myIns.ExecuteScalar();
//myIns.Connection.Close();
Session["username"]=TextBox1.Text;
Session["gender"]=RadioButtonList2.SelectedItem.Value;
//Response.Redirect("Ex10_01.aspx");
}
else
{
//Label1.Text="对不起!用户名已占,请选择其他用户名!";
TextBox1.Text="";
TextBox2.Text="";   
TextBox3.Text="";
} }