ACİL!!

 
  protected void CreateUserWizard1_CreatedUser(object sender, EventArgs e) 
          { 
   
              if (!Roles.RoleExists("uye")) 
                  Roles.CreateRole("uye"); 
   
              Roles.AddUserToRole(CreateUserWizard1.UserName, "uye"); 
   
              RadioButton rErkek = CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("rBtnErkek") as RadioButton; 
              RadioButton rKadin = CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("rBtnKadin") as RadioButton; 
   
              TextBox tboy = CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("txtboy") as TextBox; 
              TextBox tkilo = CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("txtkilo") as TextBox; 
              TextBox ttarih = CreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("txtbirthday") as TextBox; 
   
              Convert.ToDateTime(ttarih .Text, CultureInfo.CurrentCulture); 
              
              MembershipUser user = Membership.GetUser(CreateUserWizard1.UserName); 
              user.IsApproved = false; 
              Membership.UpdateUser(user); 
   
   
              SqlConnection con = new SqlConnection("Server=ASUS;Database=Beefit;UID=sa;PWD=1234"); 
              SqlCommand cmd = new SqlCommand("insert into UyeDetay(UserID,UyeCinsiyet,Uyekilo,UyeBoy,UDogumTarihi) values(@id,@cins,@kilo,@boy,@dogtar)", con); 
   
              cmd.Parameters.AddWithValue("id", user.ProviderUserKey); 
              cmd.Parameters.AddWithValue("cins", rKadin.Checked); 
              cmd.Parameters.AddWithValue("kilo", tkilo.Text); 
              cmd.Parameters.AddWithValue("boy", tboy.Text); 
              cmd.Parameters.AddWithValue("dogtar", ttarih.Text); 
   
              con.Open(); 
              cmd.ExecuteNonQuery(); 
              con.Close();     
          }