PC Review


Reply
Thread Tools Rate Thread

Change the DataGridView Column in the run time

 
 
anbaesivam
Guest
Posts: n/a
 
      5th Jan 2009
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.
 
Reply With Quote
 
 
 
 
Philipp Brune
Guest
Posts: n/a
 
      5th Jan 2009
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
 
Reply With Quote
 
 
 
 
Zhi-Xin Ye [MSFT]
Guest
Posts: n/a
 
      6th Jan 2009
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:
(E-Mail Removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subs...#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/subs.../aa948874.aspx
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 
Reply With Quote
 
anbaesivam
Guest
Posts: n/a
 
      6th Jan 2009
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:
> (E-Mail Removed).
>
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/en-us/subs...#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/subs.../aa948874.aspx
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>

 
Reply With Quote
 
anbaesivam
Guest
Posts: n/a
 
      6th Jan 2009
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:
> (E-Mail Removed).
>
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/en-us/subs...#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/subs.../aa948874.aspx
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>

 
Reply With Quote
 
Zhi-Xin Ye [MSFT]
Guest
Posts: n/a
 
      7th Jan 2009
Hi anbaesivam,

Thanks for the feedback.

When the display style is set to DataGridViewComboBoxDisplayStyle.Nothing,
the column itself is still of DataGridViewComboBoxColumn type, not of
DataGridViewTextBoxColumn type, so its editing control is still a
ComboBox, that's why you see the ComboBox appear when editing on the
column.
If you want to show a TextBox on the DataGridViewComboBoxColumn when
editing, there're many ways to do this, for example, you can create a
custom DataGridViewComboBoxColumn derive from the standard
DataGridViewComboBoxColumn class and change its editing control to TextBox,
but this way cost a lot of work.
So to make things easy, you can use two columns, one is
DataGridViewTextBoxColumn, the other is DataGridViewComboBoxColumn, show or
hide them based on your requirement.

If you have any questions or concerns, please feel free to let me know. I
will be happy of assistance. Have a nice 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:
(E-Mail Removed).

This posting is provided "AS IS" with no warranties, and confers no rights.


 
Reply With Quote
 
Zhi-Xin Ye [MSFT]
Guest
Posts: n/a
 
      9th Jan 2009
Hi anbaesivam,

Does my last reply make sense to you? If you need further help, please feel
free to let me know, I will be happy to be of assistance.

Have a nice 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:
(E-Mail Removed).

This posting is provided "AS IS" with no warranties, and confers no rights.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy from datagridview and paste to second datagridview ing.Zeco Microsoft C# .NET 2 29th Oct 2007 07:41 AM
Datagridview - Writing Journal Transactions for a Datagridview =?Utf-8?B?Qm9iIFJvZ2d5?= Microsoft VB .NET 0 1st Nov 2006 02:40 PM
DataGridView (.NET 2.0 Windows Forms) Text wrapping in DataGridView Items Chris Hayes Microsoft Dot NET Framework 1 27th Aug 2006 06:07 PM
Clearing selection in DataGridView when user clicks outside the DataGridView control djyakov@gmail.com Microsoft Dot NET Framework Forms 0 16th Feb 2006 07:38 PM
Refreshing datagridview contents after a failed delete in bound datagridview Bob Microsoft VB .NET 0 5th Jan 2006 07:34 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:03 AM.