DataGridView Binding - Need to Skip Some Columns
-
Hi, I have an instance of data table named Bank_Details with the columns "Bank_Code, Name, Acc_No", sitting inside a dataset MyDataSet. I have a BindingSource associated to the MyDataSet/Bank_Details. Without creating another instance of the table, I want to bind it to a datagridview, and only have Bank_Code column show up in the DataGridView. One way I know I can do it is to do a Visible=false on DataBindingComplete event for columns that I don't want displayed. But I am trying to avoid all that unnecessary adding of columns and hiding them when my requirement is to not deal with those columns at all. Just wondering if there is a way to bind a DataGridView to an already available instance of a DataTable and limit the databinding to only specific columns? I appreciate you all sharing any insights regarding this.
-
Hi, I have an instance of data table named Bank_Details with the columns "Bank_Code, Name, Acc_No", sitting inside a dataset MyDataSet. I have a BindingSource associated to the MyDataSet/Bank_Details. Without creating another instance of the table, I want to bind it to a datagridview, and only have Bank_Code column show up in the DataGridView. One way I know I can do it is to do a Visible=false on DataBindingComplete event for columns that I don't want displayed. But I am trying to avoid all that unnecessary adding of columns and hiding them when my requirement is to not deal with those columns at all. Just wondering if there is a way to bind a DataGridView to an already available instance of a DataTable and limit the databinding to only specific columns? I appreciate you all sharing any insights regarding this.
I've encountered this as well. If there is a solution that someone else has found that works better, by all means use it, but here's the workaround that I've used: What I have done to get around this is to manually enter all the columns into the DataGridView in the forms designer, and set the "DataPropertyName" property on each column to the appropriate DataTable column that will be in the dataset. I can then set the visible on these to false, and bind to them normally, and have only the desired columns show up. What this also allows me to do is use the hidden values in rows for calculations and whatnot, but also set up formatting on the individual cells at design time instead of during runtime. It works for my means (I use DataGrids to display a lot of line-driven real estate calculations and different views on the same value ($/SF/Mo vs $/SF/Yr in unbound columns based on read-only data in visible columns and other data in !visible columns). Hope this helps ##EDIT Edited to be a little more specific
-
Hi, I have an instance of data table named Bank_Details with the columns "Bank_Code, Name, Acc_No", sitting inside a dataset MyDataSet. I have a BindingSource associated to the MyDataSet/Bank_Details. Without creating another instance of the table, I want to bind it to a datagridview, and only have Bank_Code column show up in the DataGridView. One way I know I can do it is to do a Visible=false on DataBindingComplete event for columns that I don't want displayed. But I am trying to avoid all that unnecessary adding of columns and hiding them when my requirement is to not deal with those columns at all. Just wondering if there is a way to bind a DataGridView to an already available instance of a DataTable and limit the databinding to only specific columns? I appreciate you all sharing any insights regarding this.