Datagrid

Hi,

You would have to iterate through each row on the datagrid and get the column value for each row and keep adding them.

int numRows = datagrid1.Rows.Count;

int sum = 0;

for (int i = 0; i< numRows; i++)

{

int colValue = datagrid1[columnIndex, i].Value; //Typecase this value appropriately

sum = sum + colValue;

}

Console.WriteLine ("sum is "+sum);

RashmiGopinath at 2007-8-30 >

You could get the row counts through DataTable which should be the datagrid's datasource.

int row = dt.Rows.Count;

Salalala at 2007-8-30 >

Hi,

I use dt.Rows.Count also cannot. There is an error occur. What should I do?

Here is the error message :

Compiler Error Message: CS0117: 'System.Data.SqlClient.SqlDataReader' does not contain a definition for 'Rows'

Source Error:

Line 30: DataGrid1.Visible = result; Line 31: Line 32: int numRows = dtrQues.Rows.Count; Line 33: int sum = 0;

LynnOoi at 2007-8-30 >

Hi,

Is dataTable similar with repeater?

LynnOoi at 2007-8-30 >

In addition...

A dataview can be used to search for rows using the row filter - this is definitely in the Data Folder - You may find it easier to use this....?

MrXtra at 2007-8-30 >