Datareader-gird irregular order?

[Paulson]

Hi In my Desktop Application I call a function from UI

The code is as follows

__________________________________________________ ________________

Dim objDataHandler As New DataHandler
Try
dgResidentList.DataSource = objDataHandler.getResidents()
dgResidentList.ReadOnly = True
dgResidentList.Enabled = False
Catch ex As Exception

End Try
__________________________________________________ ________________

The db related operation where datreader reads the values [code] is as follows

__________________________________________________ ________________

Public Function getResidents() As ArrayList

Dim arrList As New ArrayList
Dim dr As SqlDataReader
Dim conn As String
conn = getConn()
dr = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, "getResidents")


While dr.Read
Dim objUser As New Data.Resident
objUser.Name = dr("Name")
objUser.Address = dr("Addr")
objUser.MobNo = dr("Mobile")
' objUser.Telephone = dr("Phone")
objUser.Employed = dr("Employed")
objUser.RecordStatusId = dr("RecordStatusId")
arrList.Add(objUser)
End While

Return arrList


End Function
__________________________________________________ ________________

The sql query(stored procedre written is )

[ Select * from DamecResident] ------------>Damec Resident is a table

I am developing and Desktop(Windows) Application using VB.Net.
I am using -------->"sqldatareader"<-------- to retrieve values from the database.
The values retrieved from the db is passed as an arraylist.
Everything works fine untill I bind the arraylist with the datagrid.
All values are coming(displayed) in grid but the order is ------->Irregular<--------

Does any one know why this happens.Pls tell me if u know(Please also tell me the reason why it comes like that).

But if I use DataSet there is no problem. PLs help guys and gals.

Thanx in advance
bye Paulson

[kenobewan]

I assume that due to datareaders being forward and once only the order is lost where it is retained in the dataset.

[Paulson]

I assume that due to datareaders being forward and once only the order is lost where it is retained in the dataset.

Hi kenu

Thanks for your reply.But I did not get you fully.What is the meaning of

[------>datareaders being forward and once only the order is lost <------]

I did not get you,and isn't there any solution for this?Pls reply whatever be the answer.

Thankyou bye Paulson.