C# Data Table count rows.

Questions & Answers
1

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

2

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.
//...