数据库的表中没有刚注册的信息，怎么办？？急求问，谢谢大家了！！！
初学C#.NET
一个注册的程序，程序运行是正常，注册完也会显示注册成功，可在数据库表中没有刚注册的用户信息，怎么办？？
程序为


private   void   BT_submit_Click(object   sender,   System.EventArgs   e)
{
      string   connstr= "server=127.0.0.1;database=aspnet;uid=sa;pwd=111 ";
      string   strsql= "select   count(*)from   UserInfo   where   UserID   like ' "+TB_UserName.Text+ " ' ";
      SqlConnection   Conn=new   SqlConnection(connstr);
      SqlCommand   mycommand=new   SqlCommand(strsql,Conn);
      Conn.Open();
      int   flag=(int)mycommand.ExecuteScalar();
      Conn.Close();
      if(flag==0)
  {

        string   selectstr= "insert   into   UserInfo(UserID,Pwd,Sex,Email,Website)values( ' "+TB_UserName.Text+ " ', ' "+TB_Pwd.Text+ " ', ' "+RBL_Sex.SelectedItem.Value+ " ', ' "+TB_Email.Text+ " ', ' "+WebSite+ " ',getdate()) ";
      SqlCommand   addcommand=new   SqlCommand(selectstr,Conn);
      Conn.Open();

      Conn.Close();
      Session[ "username "]=TB_UserName.Text;
      Session[ "Sex "]=RBL_Sex.SelectedItem.Value;
      Label7.Text= "注册成功，请先登录！ ";
}
  else  
  {
      Label7.Text= "对不起，该用户名已经存在，请选择其他用户名！ ";
      TB_UserName.Text= " ";
      TB_Pwd.Text= " ";
      TB_Pswd.Text= " ";
}
}

    private   void   BT_reset_Click(object   sender,   System.EventArgs   e)
{
Response.Redirect( "Register.aspx ");
}

------解决方案--------------------
if(flag==0)
{
string selectstr= "insert into UserInfo(UserID,Pwd,Sex,Email,Website)values( ' "+TB_UserName.Text+ " ', ' "+TB_Pwd.Text+ " ', ' "+RBL_Sex.SelectedItem.Value+ " ', ' "+TB_Email.Text+ " ', ' "+WebSite+ " ',getdate()) ";
SqlCommand addcommand=new SqlCommand(selectstr,Conn);
Conn.Open();

addcommand..ExecuteNonQuery();

Conn.Close();
Session[ "username "]=TB_UserName.Text;
Session[ "Sex "]=RBL_Sex.SelectedItem.Value;
Label7.Text= "注册成功，请先登录！ ";
}