Click here to Skip to main content
15,868,141 members
Please Sign up or sign in to vote.
4.75/5 (4 votes)
See more:
I posted an article on an Excel Add-In for exporting data with feedback. I wanted to improve the solution by allowing the user to make changes in the Windows Form that presents the data in a DataGridView control, but have problems making the Form editable. I updated the RowValidatorTypeDescriptor so that there is SetValue code and IsReadOnly returns false, but that did not work. I am a WPF developer, and not familiar enough with Windows Forms obviousl. Can somebody look at the form and help me.

Excel Add-in Framework for Validating and Exporting Data[^]

Thanks
Posted
Updated 23-Aug-12 7:17am
v2
Comments
Maciej Los 23-Aug-12 16:57pm    
What you mean "making the Form editable"?
Clifford Nelson 23-Aug-12 17:33pm    
Yes. I have tried changing a bunch of properties on the grid, but nothing seems to work. I am probably missing something minor. I just do not have a lot of recent experience in Windows Forms. Once I have editing, I can allow the information to be changed, and validate the changes.
Maciej Los 24-Aug-12 12:37pm    
I'm still not sure what you mean. I understand that you trying to allow user to edit data (add, remove) and/or to resize dataGridView rows/columns. Have a look a these propeties: AllowUserToAddRows, AllowUserToDeleteRows, AllowUserToOrderColumns, AllowUserToResizeColumns, AllowUserToResizeRows. More at: http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview_properties.aspx
Clifford Nelson 24-Aug-12 12:49pm    
I looked at most of them, but they do not seem to have anything to do with editing. I have changed the EditMode property with no luck. Maybe if you are an expert with WinForms you can download the project and see if you can see anything. I did not post code because I am not sure where the problem is. It uses TypeDescriptor and PropertyDescriptors. This may cause problems I am not sure. Really do not want to have to go to WPF unless I have to, but I have to admit that maybe I should since WPF is so much more powerful and I am much more comfortable with the technology.

Thanks
Maciej Los 25-Aug-12 11:12am    
Dear Clifford, i've not enough time to analyze the code of your Excel Addin. If you want my help, please, show the part of code where you load data into DataGridView (DGV). The possibility of modifications in DGV depends on data loading method.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900