To make the explination short, what I have is a listbox bound to a dataset. I want to add a custom row to the dataset so that it is on top of the listbox. This is my code, however I keep getting an error: "Object Reference not set to an instance of an object"

            Dim dr As dsSites.SitesRow '<-- My dataset row
            dr.SiteID = 0 '<--The error occurs here
            dr.Site = "DUMMY"
            dr.Address1 = "DUMMY" '
            dr.Address2 = "DUMMY" '
            dr.City = "DUMMY"
            dr.State = "DUMMY"
            dr.Zip = "99999" ''
            dr.Phone = "9999999999"
            DsSites1.Tables(0).Rows.InsertAt(dr, 0) '<--Should put the row on top of the dataset.

Any help would be appreciated.

Jim

Ok everyone, I fixed that problem but now have a new one.

The row gets inserted but always shows up on the bottom of my listbox, even when I use InsertAt(dr, 0).

Any Help?
Thanks

I am currently working on an application with almost the same code except that I am not binding my data and mine is inserting it in the correct spot.

Are you sure that it isn't inserting correctly in your dataset table and then just placing it in the wrong place in the listbox? I am not sure if since it is bound it will just automatically add that value to the bottom of the listbox even though you insert it at a different spot.

After inserting it in the dataset, can you loop through the dataset and output it to the debugger window to see the order?

J

Thanks for the reply. Acutally what I have is a DataView tied to the dataset table. I use it for filtering. What I did was, place a sort on the dataview, after the dataset was filled. This cured my problem.


   I am not sure, but I think it has something to do with binding order. It as if it inserts the row after binding, but then you have to reorder. I am not sure.