DataGridView DataSource: bindingSource or dataSet?
-
Hi all, I have a generic question regarding DataGridView. If I have a dataSet with a table, is it best to set the DataSource for the DataGridView as dataSet and the DataMember as the Table in the dataSet? Or should the DataGridView's DataSource be a bindingSource whose DataSource is the dataSet and whose DataMember is the Table in the dataSet? If so, that seems redundant. However, I'm sure there is a reason for doing it this way. Thanks.
-
Hi all, I have a generic question regarding DataGridView. If I have a dataSet with a table, is it best to set the DataSource for the DataGridView as dataSet and the DataMember as the Table in the dataSet? Or should the DataGridView's DataSource be a bindingSource whose DataSource is the dataSet and whose DataMember is the Table in the dataSet? If so, that seems redundant. However, I'm sure there is a reason for doing it this way. Thanks.
It's a horses for courses thing IMO. For very, very simple things with little or no user interaction it is probably simpler to bind directly to the dataset. For most other circumstances and in my somewhat limited experience, using a BindingSource gives more control functionality. Some links for BindingSource: BindingSource a closer look[^] BindingSource Class (MSDN)[^]. Just read the Remarks section for reasons that you might want to use a BindingSource. A Detailed Data Binding Tutorial[^]. Any list would be incomplete without a Code Project article. :) Others might disagree and I hope that they offer their opinions.
Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” Why do programmers often confuse Halloween and Christmas? Because 31 Oct = 25 Dec.