Change the DataGridView Column in the run time
in [Framework]
|
From: anbaesivam on 5 Jan 2009 08:17 In my requiement, I need to change the type of the DataGridView Column from one type of another type on a particular event. For example, when a button click occurs change the column type from DataGridViewTextBoxColumn to DataGridViewComboBoxColumn and vice versa. Also at the same time the column values needs to be preserved. Thanks in advance.
From: Philipp Brune on 5 Jan 2009 14:56 anbaesivam schrieb: > In my requiement, I need to change the type of the DataGridView Column from > one type of another type on a particular event. For example, when a button > click occurs change the column type from DataGridViewTextBoxColumn to > DataGridViewComboBoxColumn and vice versa. Also at the same time the column > values needs to be preserved. > > Thanks in advance. Hi, you can assign a new DataGridViewCell instance to any cell in the dataGridView like i.e. dataGridView1.Rows[0].Cells[1] = new DataGridViewTextBoxCell. But i cannot say from my head how / if you can preserve the value if you use databinding. Another option would be to add two columns to the datagridview, which are both bound to the same DataMember and then set only one of them to visible. So you can simulate the desired behaviour. Philipp
From: Zhi-Xin Ye [MSFT] on 6 Jan 2009 01:21 Hi anbaesivam, Thank you for using Microsoft Managed Newsgroup Service, my name is Zhi-Xin Ye, it's my pleasure to work with you on this issue. As I understand, you want to change the DataGridView column type dynamically. The DataGridViewTextBoxColumn/DataGridViewComboBoxColumn/DataGridViewCheckBoxCol umn/etc. are all derived from the DataGridViewColumn class, they're of the same level and cannot cast to each other. However, for the specified scenario you described, i.e. change the column type from DataGridViewTextBoxColumn to DataGridViewComboBoxColumn and vice versa, there's a small trick, you can use a DataGridViewComboBoxColumn and change its DisplayStyle property value between DataGridViewComboBoxDisplayStyle.Nothing and DataGridViewComboBoxDisplayStyle.DropDownButton. For example: private void button1_Click(object sender, EventArgs e) { DataGridViewComboBoxColumn c = (DataGridViewComboBoxColumn)this.dataGridView1.Columns[0]; //Make the column displayed as ComboBox column. c.DisplayStyle = DataGridViewComboBoxDisplayStyle.DropDownButton; } private void Form1_Load(object sender, EventArgs e) { //....other code here... DataGridViewComboBoxColumn c = new DataGridViewComboBoxColumn(); c.DataPropertyName = "c1"; c.DataSource = dt; c.DisplayMember = "c2"; c.ValueMember = "c1"; //Make the column displayed as textbox column. c.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing; this.dataGridView1.Columns.Add(c); } For other kinds of column types, you can try Philipp's suggestion to make different type columns bound to the same filed, and show/hide them based on your needs. If anything is unclear or you have any concerns, please feel free to let me know, I will be happy of assistance. Have a good day! Best Regards, Zhi-Xin Ye Microsoft Managed Newsgroup Support Team Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you. Please feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: msdnmg(a)microsoft.com. ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications. Note: MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 2 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx ================================================== This posting is provided "AS IS" with no warranties, and confers no rights.
From: anbaesivam on 6 Jan 2009 01:58 Thanks a lot for your solution. The solution exactly matches my requirement. "Zhi-Xin Ye [MSFT]" wrote: > Hi anbaesivam, > > Thank you for using Microsoft Managed Newsgroup Service, my name is Zhi-Xin > Ye, it's my pleasure to work with you on this issue. > > As I understand, you want to change the DataGridView column type > dynamically. The > DataGridViewTextBoxColumn/DataGridViewComboBoxColumn/DataGridViewCheckBoxCol > umn/etc. are all derived from the DataGridViewColumn class, they're of the > same level and cannot cast to each other. However, for the specified > scenario you described, i.e. change the column type from > DataGridViewTextBoxColumn to DataGridViewComboBoxColumn and vice versa, > there's a small trick, you can use a DataGridViewComboBoxColumn and change > its DisplayStyle property value between > DataGridViewComboBoxDisplayStyle.Nothing and > DataGridViewComboBoxDisplayStyle.DropDownButton. For example: > > private void button1_Click(object sender, EventArgs e) > { > DataGridViewComboBoxColumn c = > (DataGridViewComboBoxColumn)this.dataGridView1.Columns[0]; > > //Make the column displayed as ComboBox column. > c.DisplayStyle = > DataGridViewComboBoxDisplayStyle.DropDownButton; > } > > private void Form1_Load(object sender, EventArgs e) > { > //....other code here... > > DataGridViewComboBoxColumn c = new DataGridViewComboBoxColumn(); > c.DataPropertyName = "c1"; > c.DataSource = dt; > c.DisplayMember = "c2"; > c.ValueMember = "c1"; > > //Make the column displayed as textbox column. > c.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing; > > this.dataGridView1.Columns.Add(c); > } > > For other kinds of column types, you can try Philipp's suggestion to make > different type columns bound to the same filed, and show/hide them based on > your needs. > > If anything is unclear or you have any concerns, please feel free to let me > know, I will be happy of assistance. Have a good day! > > Best Regards, > Zhi-Xin Ye > Microsoft Managed Newsgroup Support Team > > Delighting our customers is our #1 priority. We welcome your comments and > suggestions about how we can improve the support we provide to you. Please > feel free to let my manager know what you think of the level of service > provided. You can send feedback directly to my manager at: > msdnmg(a)microsoft.com. > > ================================================== > Get notification to my posts through email? Please refer to > http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications. > > Note: MSDN Managed Newsgroup support offering is for non-urgent issues > where an initial response from the community or a Microsoft Support > Engineer within 2 business day is acceptable. Please note that each follow > up response may take approximately 2 business days as the support > professional working with you may need further investigation to reach the > most efficient resolution. The offering is not appropriate for situations > that require urgent, real-time or phone-based interactions. Issues of this > nature are best handled working with a dedicated Microsoft Support Engineer > by contacting Microsoft Customer Support Services (CSS) at > http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx > ================================================== > This posting is provided "AS IS" with no warranties, and confers no rights. > >
From: anbaesivam on 6 Jan 2009 02:14
After chaning the display style to "DataGridViewComboBoxDisplayStyle.Nothing", when I try to enter value from keyboard, the combo-box appears and when I leave the combo-box disappears. Is it possible to fix this issue?. Thanks. "Zhi-Xin Ye [MSFT]" wrote: > Hi anbaesivam, > > Thank you for using Microsoft Managed Newsgroup Service, my name is Zhi-Xin > Ye, it's my pleasure to work with you on this issue. > > As I understand, you want to change the DataGridView column type > dynamically. The > DataGridViewTextBoxColumn/DataGridViewComboBoxColumn/DataGridViewCheckBoxCol > umn/etc. are all derived from the DataGridViewColumn class, they're of the > same level and cannot cast to each other. However, for the specified > scenario you described, i.e. change the column type from > DataGridViewTextBoxColumn to DataGridViewComboBoxColumn and vice versa, > there's a small trick, you can use a DataGridViewComboBoxColumn and change > its DisplayStyle property value between > DataGridViewComboBoxDisplayStyle.Nothing and > DataGridViewComboBoxDisplayStyle.DropDownButton. For example: > > private void button1_Click(object sender, EventArgs e) > { > DataGridViewComboBoxColumn c = > (DataGridViewComboBoxColumn)this.dataGridView1.Columns[0]; > > //Make the column displayed as ComboBox column. > c.DisplayStyle = > DataGridViewComboBoxDisplayStyle.DropDownButton; > } > > private void Form1_Load(object sender, EventArgs e) > { > //....other code here... > > DataGridViewComboBoxColumn c = new DataGridViewComboBoxColumn(); > c.DataPropertyName = "c1"; > c.DataSource = dt; > c.DisplayMember = "c2"; > c.ValueMember = "c1"; > > //Make the column displayed as textbox column. > c.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing; > > this.dataGridView1.Columns.Add(c); > } > > For other kinds of column types, you can try Philipp's suggestion to make > different type columns bound to the same filed, and show/hide them based on > your needs. > > If anything is unclear or you have any concerns, please feel free to let me > know, I will be happy of assistance. Have a good day! > > Best Regards, > Zhi-Xin Ye > Microsoft Managed Newsgroup Support Team > > Delighting our customers is our #1 priority. We welcome your comments and > suggestions about how we can improve the support we provide to you. Please > feel free to let my manager know what you think of the level of service > provided. You can send feedback directly to my manager at: > msdnmg(a)microsoft.com. > > ================================================== > Get notification to my posts through email? Please refer to > http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications. > > Note: MSDN Managed Newsgroup support offering is for non-urgent issues > where an initial response from the community or a Microsoft Support > Engineer within 2 business day is acceptable. Please note that each follow > up response may take approximately 2 business days as the support > professional working with you may need further investigation to reach the > most efficient resolution. The offering is not appropriate for situations > that require urgent, real-time or phone-based interactions. Issues of this > nature are best handled working with a dedicated Microsoft Support Engineer > by contacting Microsoft Customer Support Services (CSS) at > http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx > ================================================== > This posting is provided "AS IS" with no warranties, and confers no rights. > > |