title: Index was outside the bounds of the array
body: <p>I am getting this error:</p>
  
  <blockquote>
    <p>Index was outside the bounds of the array.</p>
  </blockquote>
  
  <p>Code:</p>
  
  <pre><code>   private void PopulateWallPosts(string userId)
      {
  
          using (OdbcConnection cn = new OdbcConnection("Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Database=gymwebsite2; User=root; Password=commando;"))
          {
              cn.Open();
              using (OdbcCommand cmd = new OdbcCommand("SELECT wp.WallPostings, p.PicturePath FROM WallPosting wp INNER JOIN User u ON u.UserID = wp.FriendUserID INNER JOIN Pictures p ON p.UserID = u.UserID WHERE wp.UserID=" + userId + " ORDER BY idWallPosting DESC", cn))
              {
                  //SELECT idWallPosting, wp.WallPostings, p.PicturePath FROM WallPosting wp LEFT JOIN User u ON u.UserID = wp.UserID LEFT JOIN Pictures p ON p.UserID = u.UserID WHERE wp.UserID=" + userId + " ORDER BY idWallPosting DESC
                  using (OdbcDataReader reader = cmd.ExecuteReader())
                  {
                      test1.Controls.Clear();
  
                      while (reader.Read())
                      {
  
                          System.Web.UI.HtmlControls.HtmlGenericControl div = new System.Web.UI.HtmlControls.HtmlGenericControl("div");
                          div.Attributes["class"] = "test";
  
  
                          div.ID = String.Format("{0}", reader.GetString(0)); //idwallposting
                          string id = Convert.ToString(div.ID); 
                          //store the div id as a string
                          Image img = new Image();
                          img.ImageUrl = String.Format("{0}", reader.GetString(2)); //p.picturepath 
                          img.AlternateText = "Test image";
  
                          div.Controls.Add(img);
                          div.Controls.Add(ParseControl(String.Format("&amp;nbsp&amp;nbsp&amp;nbsp;" + "{0}", reader.GetString(1)))); //wp.wallpostings
                          div.Attributes.Add("onclick", "confirm_delete(" + id + ");");
                          // send the div id to javascript
                          div.Style["clear"] = "both";
                          test1.Controls.Add(div);
  
                      }
                  }
              }
          }
      }
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/jtnbW.jpg" alt="enter image description here"></p>