Loading

DataGrid -- no data shows up

jenka13all

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

mibuyt21y ago
Hi, So you already solve the problem? Cheers.
jenka13all21y ago
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.