how to Count the filled rows in the DataGrid

dim cm as currencymanager = ctype(me.bindingcontext(datagrid1.datasource),currencymanager)
dim intRowCount as integer = cm.count

KenTucker at 2007-9-4 >

Dear Ken Tucker,

Thanks for your reply

I tried it but it gives me only 1 row count in all cases

I have around 400 rows

Is there some more code I must write it ?!!

Thank U too much

ams_ashraf at 2007-9-4 >

I get 77 with this example.

Dim conn As SqlConnection
Dim strConn As String
Dim da As SqlDataAdapter
Dim ds As New DataSet

strConn = "Server = .; Database = NorthWind; Integrated Security = SSPI;"

conn = New SqlConnection(strConn)
da = New SqlDataAdapter("Select * From Products", conn)
da.Fill(ds, "Products")
DataGrid1.DataSource = ds.Tables("Products")
Dim cm As CurrencyManager
cm = CType(Me.BindingContext(DataGrid1.DataSource), CurrencyManager)
Dim intRows As Integer = cm.Count
Me.Text = String.Format("Number of rows {0}", intRows)

KenTucker at 2007-9-4 >

public static int dataTableRowCount(DataTable dt)

{

int dtRowCount = 0;

foreach(DataRow myRow in dt.Rows)

if (myRow.RowState != DataRowState.Deleted)

dtRowCount ++;

return dtRowCount;

}

CarlosValenzuela at 2007-9-4 >