Nested Array? Populating a menu using a loop.

Hello,

I am trying to populate a scrollable menu with items from a sqlite database.

Below is the code for the menu:

 Rect rScrollFrame = new Rect(listMargin.x, listMargin.y, listSize.x, listSize.y);
         Rect rList        = new Rect(0, 0, rowSize.x, numRows*rowSize.y);
         
         scrollPosition = GUI.BeginScrollView (rScrollFrame, scrollPosition, rList, false, false);
             
         Rect rBtn = new Rect(0, 0, rowSize.x, rowSize.y);
         
         for (int iRow = 0; iRow < numRows; iRow++)
         {
                // draw call optimization: don't actually draw the row if it is not visible
             if ( rBtn.yMax >= scrollPosition.y && 
                  rBtn.yMin <= (scrollPosition.y + rScrollFrame.height) )
                {
                 bool fClicked = false;
 
                 /* TESTING STRING */
 
                    string rowLabel = "Row Number " + iRow;
                    
                    if ( iRow == selected )
                    {
                     fClicked = GUI.Button(rBtn, rowLabel, rowSelectedStyle);
                    }
                    else
                 {
                        fClicked = GUI.Button(rBtn, rowLabel);
                 }
                 
                 // Allow mouse selection, if not running on iPhone.
                 if ( fClicked && Application.platform != RuntimePlatform.IPhonePlayer )
                 {
                    Debug.Log("Player mouse-clicked on row " + iRow);
                 }
                }
                            
             rBtn.y += rowSize.y;
         }
         GUI.EndScrollView();

That works fine.

It's getting items from my SQL query into the rowLabel I am having problems with.

Here is the SQLite query, I can get the values and print them to the console

 string sql = "SELECT WeaponID, WeaponName FROM Weapon ORDER BY WeaponID";
             
         SimpleSQL.SimpleDataTable dt = dbManager.QueryGeneric(sql);

         int rowIndex = 0;
         foreach (SimpleSQL.SimpleDataRow dr in dt.rows)
         {
                 
                             Debug.Log(dr["WeaponName"].ToString() + "\n");
                                 
                         
             rowIndex++;
         }
 

I would like to assign each WeaponName in the database to RowLabel.

I have tried combining the two loops, but I having no luck I just can't seem to figure it out.

Any help would be appreciated.