title: Inserting selected data using checkbox from gridview
body: <p>When I select the in the gridview using checkbox, I want it to insert the data into the database, but it is not adding it. My code is below, please see where I am going wrong.</p>
  
  <pre><code>public partial class HomeTeamCheckList : System.Web.UI.Page
  {
      protected void Page_Load(object sender, EventArgs e)
      {
          LiveGameReporting Window
          SubmitLineUp.Attributes.Add("onclick", "PassValues();");
  
          SubmitLineUp.Text = "Submit " + Session["HomeTeam"] + "'s Line Up";
      }
  
      protected void SubmitLineUp_Click(object sender, EventArgs e)
      {
          String GameID = string.Empty;
          String Name = string.Empty;
          String Number = string.Empty;
  
          int GKGVCount = GoalKeeperGridView.Rows.Count;
  
  
          foreach (GridViewRow gkrow in GoalKeeperGridView.Rows)
          {
              GameID = (String)Session["GameID"];
              Number = gkrow.Cells[0].Text;
              Name = gkrow.Cells[1].Text;
  
               SqlConnection connection = new SqlConnection(("Data Source=ROBEL-HP;Initial Catalog=RocoSportsDB;Integrated Security=True"));
  
              {
                  SqlCommand cmd = new SqlCommand();
                  cmd.Connection = connection;
                  cmd.CommandText = @"INSERT INTO HTLineUp (GameID, HomeTeamLineUpNo, HomeTeamLineUpName) VALUES (@GameID,@Number,@Name)";
  
                  cmd.Parameters.AddWithValue("@GameID", GameID);
                  cmd.Parameters.AddWithValue("@Number", Number);
                  cmd.Parameters.AddWithValue("@Name", Name);
  
                  cmd.ExecuteNonQuery();
              }
          }
      }
  }
  </code></pre>