//Username yanına bir checkbox koydum 
          <asp:Button CssClass="btncheck" Text="Check" runat="server" OnClick="UserNameCheck_Click"  /> 
   
  protected void UserNameCheck_Click(object sender, EventArgs e) 
          { 
              SqlConnection con = new SqlConnection(); 
              con.ConnectionString = @"SERVER=FURKAN\SQLEXPRESS; Database=SRO_VT_ACCOUNT; User ID=sa; Password=429255"; 
              con.Open(); 
              SqlCommand cmd = new SqlCommand(); 
              cmd.CommandText = "SELECT * FROM TB_User StrUserID=@uname"; 
              cmd.Parameters.AddWithValue("@uname", txtUserName.Text); 
              cmd.Connection = con; 
              SqlDataReader rd=cmd.ExecuteReader(); 
              if(rd.HasRows) 
              { 
                  lblchck.Visible = true; 
                  lblchck.Text = "Username already exist"; 
                  lblchck.ForeColor = System.Drawing.Color.Red; 
   
              } 
   
              else 
              { 
                  lblchck.Visible = true; 
                  lblchck.Text = "Username availabel"; 
                  lblchck.ForeColor = System.Drawing.Color.Green; 
              } 
          } 
  

protected void btnregister_Click(object sender, EventArgs e) 
          { 
              if (txtUserName.Text != "" && txtPassword.Text != "") 
              { 
   
   
              } 
              SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings[0].ConnectionString); 
   
              string sorgu = "Insert into TB_User (StrUserID,password) Values (@kullanici,@sifre)"; 
   
              SqlCommand cmd = new SqlCommand(sorgu, cnn); 
   
              cnn.Open(); 
   
              try 
              { 
                  string hashedPassword = FormsAuthentication.HashPasswordForStoringInConfigFile(txtPassword.Text, "MD5"); 
                  cmd.Parameters.AddWithValue("@kullanici", txtUserName.Text); 
                  cmd.Parameters.AddWithValue("@sifre", hashedPassword); 
   
                  cmd.ExecuteNonQuery(); 
                  cnn.Close(); 
                  lblresult.Text = "Succesfuly Registered"; 
   
              } 
              catch (Exception) 
              { 
                  lblresult.Text = "FAILED Registered"; 
              } 
          } 
   
          protected void btncancel_Click(object sender, EventArgs e) 
          { 
              txtUserName.Text = ""; 
              txtPassword.Text = ""; 
              lblresult.Text = ""; 
          }

 
    object User = Session["$UserName"]; 
              if (User != null) 
              { 
                  pnlLogin.Visible = false; 
                  pnlWelcome.Visible = true; 
                  lblUserName.Text = User.ToString(); 
              } 
              else 
              { 
                  pnlWelcome.Visible = false; 
                  pnlLogin.Visible = true; 
                   
              } 
   
   
  protected void btnlogin_Click(object sender, EventArgs e) 
          { 
              SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings[0].ConnectionString); 
              string sorgu = "Selecet * From TB_User Where StrUserID = $UserName AND Password = $Passoword "; 
              SqlCommand cmd = new SqlCommand(sorgu, cnn); 
              cmd.Parameters.AddWithValue("$UserName", txtUserName); 
              cmd.Parameters.AddWithValue("$Password", txtPassword); 
   
              cnn.Open(); 
              SqlDataReader dr = cmd.ExecuteReader(); 
   
              if (dr.Read()) 
              { 
                  Session.Add("User", dr["StrUserID"].ToString()); 
                  Response.Redirect(Request.RawUrl); 
              } 
              else 
              { 
                  lblresult.Text = "Login Failed"; 
              } 
   
              cnn.Close(); 
   
   
   
          }

 
  protected void Page_Load(object sender, EventArgs e) 
          { 
  FtwGuild(); 
  } 
   
          private void FtwGuild() 
          { 
              SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString); 
   
              string sorgu = "SELECT * FROM _SiegeFortress WHERE GuildID like '%%%%%%%'"; 
   
   
              SqlCommand cmd = new SqlCommand(sorgu, cnn); 
   
              cnn.Open(); 
   
              SqlDataReader dr = cmd.ExecuteReader(); 
              FtwOwner.DataSource = dr; 
              FtwOwner.DataBind(); 
   
              cnn.Close(); 
   
   
          } 
   
               

private void FtwGuild() 
           { 
               SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ConnectionString); 
    
               String Jangan = "SELECT GuildID FROM _SiegeFortress WHERE FortressID = 1"; 
               String Hotan = "SELECT GuildID FROM _SiegeFortress WHERE FortressID = 3"; 
               string Bandit = "SELECT GuildID FROM _SiegeFortress WHERE FortressID = 6"; 
    
    
               SqlCommand cmd = new SqlCommand(Jangan, cnn); 
               SqlCommand cmd1 = new SqlCommand(Hotan, cnn); 
               SqlCommand cmd2 = new SqlCommand(Bandit, cnn); 
    
               String JanganGD = "SELECT Name FROM _Guild WHERE ID = @Jangan"; 
               String HotanGD = "SELECT Name FROM _Guild WHERE ID = @Hotan"; 
               String BanditGD = "SELECT Name FROM _Guild WHERE ID = @Bandit"; 
    
               SqlCommand cmd4 = new SqlCommand(JanganGD, cnn); 
               SqlCommand cmd5 = new SqlCommand(HotanGD, cnn); 
               SqlCommand cmd6 = new SqlCommand(BanditGD, cnn); 
    
               cmd.Parameters.AddWithValue("@Jangan", Jangan); 
               cmd.Parameters.AddWithValue("@Hotan", Hotan); 
               cmd.Parameters.AddWithValue("@Bandit", Hotan); 
               cnn.Open(); 
    
    
    
               SqlDataReader dr = cmd.ExecuteReader(); 
               FtwOwner.DataSource = dr; 
               FtwOwner.DataBind(); 
    
               cnn.Close(); 
    
    
           }