DataGrid -- no data shows up

Question

I have a datagrid whose datasource is an SQL 2000 table -- when I run the program the grid appears with the columns formatted exactly as I specified but NO data. When I run the query that underlies the datasource on the database table itself I get results. Does anybody have an idea why that could be? I have another control (a listbox) connected to the same database (different table) and I get results in that control with no problems.

mibuyt · Answer

Hi So you already solve the problem? Cheers.

jenka13all · Answer

oops there were 2 problems one extremely obvious and one not so: I forgot to Fill the data adaptor object in the constructor with these two lines: dbConn.Open(); daPat.Fill(dsPat); Also the connection property for the data adapter had been set without the allow user to save password box checked. This caused the program once the two lines above had been added to the constructor to shut down with a runtime error.