counting the record

Question

How do you count the number of records return when selecting the database with ExecuteReader() ie. myReader = mySelCommand.ExecuteReader()

Sushta Guthnar · Answer

HEY rs.MoveFirst rs.MoveLast i = rs.count hlin 50 color=3 vlin 30 color=0

Tuck Hoh · Answer

Thank you. MMmm I think so too. can't find something more easier to get the row count. with this OlDbdataReader = mySelCommand.ExecuteReader() How can I fill in the DataGridView ?

Hirendra Sisodiya · Answer

hello Tuch you can try this: myReader = mySelCommand.ExecuteReader() Dim Count as integer=0 While myReader .Read Count =Count +1 End While i think there are no default property for counting records in datareader. thanks please mark as answere if you like my answere

Hirendra Sisodiya · Answer

'you can fill datagridview in this way try this: Dim myReader As OleDb.OleDbDataReader = mySelCommand.ExecuteReader() Dim columnCount As Integer = myReader.FieldCount Dim rowData As String () = New String (columnCount - 1) For i As Integer = 0 To columnCount - 1 DataGridView1.Columns.Add(myReader.GetName(i).ToString() myReader.GetName(i).ToString()) Next While myReader.Read() For i As Integer = 0 To columnCount - 1 rowData(i) = myReader.GetInt32(i).ToString() Next DataGridView1.Rows.Add(rowData) End While 'thanks 'Please mark as answere if you like my answere