I have an ultragrid binding from a DataTable. I would like the user to be able to assign what Column the data belongs to by displaying a dropdown of column values from the bindable datatable. Is something like the picture feasible? Using VB.NET and Winforms
Hi Scott,
Thank you for posting in our forums.
I can’t see the picture for some reason and your requirement is not completely clear for me. Could you please clarify it? Do you want to display the columns with different captions, chosen from the dropdown list by the user? Do you have manually defined the schema in the grid prior to binding?
I would greatly appreciate if you explain your scenario and requirements in greater detail.
I am looking forward to hearing from you.
Dimitar;
My use case is for a user data ETL ingestion feature:
1) User imports a spreadsheet into a spreadsheet control and I create a DataTable from it.
2) I then load that data into a grid but I want the user to choose what column in another SQL table that imported data maps too.
3) After user maps columns to that data column I import the whole thing into a SQL table.
http://1drv.ms/15ydPwo
LEt me know if u see the picture.
Thank you for the clarification.
What you could do in your case is after creating the DataTable from the imported spreadsheet, to bind the grid to a data table with the grid columns and empty rows. After that when the user chooses a column from the dropdown lists, populate the respective column from the grid with the values from the column that is selected in the DataTable.
I have attached a sample that demonstrates this approach. It uses a user control for the functionality.
Let me know if this is what you are looking for.
Dimitar
Thank you! Unfortuantly Im getting an incompatible project when I try to load the solution. Despite trying to rebuild the project im getting tons of errors on the form. Im currently using VS2010 and Infrigitics 2012.2
I have modified the sample to use 12.2 and VS 2010. Let me know if this is what you are looking for.