- Home /
C# Data Table count rows.
Hello.
I am using SimpleSql for my game.
However, I have a menu - I need to know how many rows will be returned.
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;
string rowLabel = dt.rows[iRow]["WhiskyName1"].ToString();
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();
}
Currently numRows is a hard coded static int. This I would like to change.
How do I find how many rows are in a c# data table.
I have tried
dt.Rows.Count
To no avail
Solved it myself. Something simple:
int rowIndex1 = 0;
int count = 0;
foreach (SimpleSQL.SimpleDataRow dr in dt.rows)
{
count = count + 1;
rowIndex1++;
}
Although if anybody knows of a more elegant way that would be appreciated.
Answer by Landern · May 19, 2014 at 12:42 PM
both the rows and columns properties are both type List. List has a property called count. Given that information you should be able to call Count on either of them.
//...
int totalRows = dt.rows.Count;
int totalColumns = dt.columns.Count.
//...
Your answer
Follow this Question
Related Questions
Multiple Cars not working 1 Answer
Distribute terrain in zones 3 Answers
Creating a user defined ID for firebase realtime database 0 Answers
How do I get list of country name, state name and city name for my users in my Game? 1 Answer
Count the contents of the list from FindGameObjectsWithTag 1 Answer