C# Programming
03-29-2009, 02:41 AM
Hello, I was wondering what would be the fastest way to read from a SQL database. I have a inventory database that populates a listview with various icons depending on the TypeOfEquipment field. Now I did make it use threading when populating the ListView but it was very chopping... performance wise it didn't "freeze" while loading thei nformation, but everytime an item was insert I guess it would try to go to the top and made the way it looked very choppy.
Anyways, right now I read from the database with SqlDataReader. Would putting it in a datalist then reading from there be faster? All that I am pulling from the SQL table is text. There isn't any files or pictures.
Anyways, right now I read from the database with SqlDataReader. Would putting it in a datalist then reading from there be faster? All that I am pulling from the SQL table is text. There isn't any files or pictures.