dotnet windows forms databinding: advice...... -- dotnet windows forms databinding

advice......

Luc
9/12/2007 11:22:00 AM

dotnet windows forms databinding:

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??
--
Best regards

Re: advice......

Morten Wennevik [C# MVP]
9/13/2007 9:08:04 PM

[quoted text, click to view]

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.

--
Happy coding!