Hello (i'm french, so sorry for my english),
I develope with VB.NET and infragistics for Winform.
I would like to use grid to display a stock, as you can see on picture.
" width="1" border="0" />Why grid ? Because i need informations for all localizations (qty, item code,designation, etc...)
But, i want also move (drag and drop) item from localization A to B.I need to manage my stock like that.
Can you give help and tell me where to find answer and try to make my goal.
Thank you very much.
Laurent
Hi Laurent,
I'm not sure what your question is. Which part of this are you having trouble with?
Setting up a grid like this should not be very difficult. You will need some kind of data source with the structure you want and then you simply use the SetDataBinding method of the grid to bind it.
The gragging and dropping is a little more work. How you do it depends what you want to drag and drop, though. So it's hard to point you in the right direction without more information about what you need to do.
Hi (i'm french, so sorry for my english),
1- I have my stock structure on sql server database (other difficulty, some bins need Merged cells because they are larger then small bins).
2- I need to show the struture of my stock in grid with images. I need Grid to know witch one is click, and i need to put informations about my item in.
3- Then, if a reference changed place, I must be able to click on its image, slide it in its new place and updating automatically the database.
4- For example, if i want to use an empty location on shelf, i would do a right click , open a context menu, and use function to add a new item,
globally, manage my stock on shelfs with bins with a ultragrid control and images.
Do you have an example to help me ?
thank you very much for your help.
I'm still having trouble understand what you need.
1) The grid is not a spreadsheet. So I'm not sure if this can be done. You can merge cells in the same column as long as they have the same value. But there's no way to merge cells in the same row. You could use a RowLayout to make certain cells in the row bigger than others, but this applies to all rows, you can't do it on an individual row.
2) This should not be a problem.
3) I'm not sure what you mean. The grid does not update the database. The grid works with a local data source like a DataSet or a DataTable. The interaction between the data source and the back end (the database) has nothing to do with the grid, that part is up to you. It's easy enough to update a data base from a DataSet, of course.
4) Adding a context menu to a cell and changing the values of cells is certainly possible.
I'm not sure what kind of example you are looking for. There are a lot of samples included with NetAdvantage. None of them do exactly what you want here, of course, because they are just samples, not full applications.
I insert for you an image to help you to understand what i want to do.
I draw image on Excel file to represent what i want to develop with grid.
And with this image, i need to manage my stock. Add item in an empty location, move an item from location A to location B.
Etc...
is it possible ? And do you have examples to help me ?
thanks
Since I don't know all the intricacies of your application, I can't really say if it's possible or not. You could certainly create a grid with cell and edit the cells in that grid either via the keyboard or drag and drop. But I'm still not sure I understand your question.