- Home /
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.
Your answer
Follow this Question
Related Questions
Determining groups in a 2D array by checking neighbours (and their neighbours etc) 2 Answers
Loop Coroutine For A Demo Mode 1 Answer
How to get first script from gameobject while having propery : Unity 0 Answers
How to get first script from gameobject while having propery : Unity 1 Answer
problem with loop / unity crash 2 Answers