advice......

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Luc - 12 Sep 2007 19:22 GMT

Which place is the best one to load data to be used in comboboxes,
datagridviews,.....??
In my application, it takes 0.5 seconds before my form is displayed, (the
data is loaded in the load event of the form.

another one....,whats the best way for inserting, deleting, updating
records, via stored procedures on the SQL server or via the dataset in the
application??

Signature

Best regards
Luc

Reply to this Message

Morten Wennevik [C# MVP] - 13 Sep 2007 20:08 GMT

> Which place is the best one to load data to be used in comboboxes,
> datagridviews,.....??
[quoted text clipped - 4 lines]
> records, via stored procedures on the SQL server or via the dataset in the
> application??

Hi Luc,

For ComboBoxes, a simple list of any kind would suffice.

It is faster to use stored procedures and map the data yourself than using a DataSet, although you will have to write more code for the mapping. I prefer using SqlCommand.ExecuteReader and create objects for each row of data to be used in the GUI-layer, or store objects back in the sql database.

Signature

Happy coding!
Morten Wennevik [C# MVP]

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...