Dear Infragistic,
I would like to ask some questions regarding wingrid control. i have downloaded the trial version of dotnetAdvantage. i am using the wingrid.
as i have experienced that grid controls in market supports both bound and unbound data models.
but in your case it is not elaborated. if wingrid supports unbound data then plz let me know how.
in this case if you provide me a video of doing this or a tutorial then it will help us making our new relationship that is customer and vendour.
I am also attaching an image from our existing software, i want you to tell me how should i achieve the same from your wingird.
it will help us very much to upgrade our software and our relation too.
if there is something missing in my query then you may email me @
msherazkhan@hotmail.com or
msherazkhan@alkhairpolymers.com or info@alkhairgroup.com
. i prefer hotmail.
Muhammad Sheraz Khan
Manager IT
Al-Khair Group Lahore Pakistan
Ph: 92-42-111-111-043
msherazkhan said:if wingrid supports unbound data then plz let me know how.
UltraWinGrid must be bound to a data source. But the grid will bind to anything that implement IList or IBindingList. So you do not need a DataBase. If you want to use the grid in an unbound mode, you could use the UltraDataSource, a BindingList<T>, or a custom IBindingList as the DataSource for the grid.
msherazkhan said:I am also attaching an image from our existing software
There is no image attached to your forum post. I think we might have been having some problems with our forums yesterday. So please try posting the image again so I can take a look.
Dear Mike,
I am attaching the image, if you can see then ok, othewise tell me the alternative. i need to develop a form which offers user to enter the Sale Order (and other documents) information from a customer. then i will store this information for further complex industrial processing. i need an open grid like farpoint spread or power builder's grid, which offers me to enter the data on the fly as well as database binding.
i will must say that i like infragistic wingrid very much, but if unwillingly i might have to skip this great grid only because of its not having the said feature (i.e. managing unbound data/ user data entry), then it will be my great bad luck that a great control can not let me use it easily or the way i need it to be.
I will appriciate very much if you send me a video of doing the same thing as shown below. you can see the image, it has a grid with multi-column comboboxes in it. This a kind of Sale Order form. which is typed by the company user for the customer. i can elaborate if you ask me to do so. if you can see the image then its self-explanatory. the problem is that we can not continue working with our current software, and we are opting to develop it in VS2005 using csharp. we need a third party control which offers the same as shown below. I force you to send us a video-tutorial for acheiving the same because we dont want to spend our time on exploring a new grid.
Please reply me ASAP. if you are unable to view the image then i am uploading the image on rapidshare.com you can download it from there.
http://rapidshare.com/files/300311993/sample_pic.JPG.html
Thanks.
M. Sheraz Khan
Al-Khair Group.
msherazkhan said:I am attaching the image, if you can see then ok, othewise tell me the alternative. i need to develop a form which offers user to enter the Sale Order (and other documents) information from a customer. then i will store this information for further complex industrial processing. i need an open grid like farpoint spread or power builder's grid, which offers me to enter the data on the fly as well as database binding.
WinGrid is not designed to be a spreadsheet. Users can, of course, enter data into the grid and add rows. But if you need an indefinite number of columns, then there's no way to do that. You would have to bind the grid to some sort of fixed data structure with a certain number of columns.
msherazkhan said:I will appriciate very much if you send me a video of doing the same thing as shown below. you can see the image, it has a grid with multi-column comboboxes in it. This a kind of Sale Order form. which is typed by the company user for the customer. i can elaborate if you ask me to do so. if you can see the image then its self-explanatory. the problem is that we can not continue working with our current software, and we are opting to develop it in VS2005 using csharp. we need a third party control which offers the same as shown below. I force you to send us a video-tutorial for acheiving the same because we dont want to spend our time on exploring a new grid.
Yes, the grid supports multi-column dropdowns via the UltraDropDown control. There are samples of this included in the NetAdvantage SDK. And an article here that explains the options:
HOWTO:What is the best way to place a DropDown list in a grid cell?
Dear Mike, hi there,
thanks for your precious time and useful reply. of course wingrid supports multi column combo box, i saw it. And further
i dont want ultra grid to provide me unlimited columns support as unbound.
instead i want unlimited rows which will be entered by the user , but i feel the need to ask you the things listed below.
how can I
1- display text boxes with limitations for the user in wingrid.
2- display checkboxes, read only text, numeric data, percentage data, pictures with limitations on design time or at run time. i would like to have an answer from your side.
3- at run time, change the cell type of a column on an event like leave cell or key press.
4- add a column with its specified type like numeric column or text column at run time.
I am very much overburdened now a days. You are requested to send me the csharp code for above mentioned things. you can understand i am in no state to go through all the examples and find one which is suitable for me.
i like your wingrid very much and i hope i will surely convince my highers to buy this one for our company. but to do this we both have to work quickly.
Thank you very much.
Sheraz Khan.
Al-Khair Group
Hi msherazkhan,
from what i can see in your description and screenshot of the application form, all this can be done very fine with the UltraGrid. Actually there are very very little things that can not be done with the UltraGrid. The features you ask for are really very basic features and all explained very well in the online help (including source code in C# and VB) and in the samples download (you did install the samples, did you?).
Making the decision to switch to an new and possibly complex component like an grid is always a big deal, especially if you under heavy workload. I personaly rather spend some time to learn an very flexible component like the UltraGrid then use something more simple and regret it later due to lack of features.
msherazkhan said: I force you to send us a video-tutorial for acheiving the same because we dont want to spend our time on exploring a new grid.
I force you to send us a video-tutorial for acheiving the same because we dont want to spend our time on exploring a new grid.
msherazkhan said: I am very much overburdened now a days. You are requested to send me the csharp code for above mentioned things. you can understand i am in no state to go through all the examples and find one which is suitable for me.
But, and it might be totally inappropriate for me to say that, from your quotes above one could get the impression you want the component supplier building your application as well. :)
msherazkhan said: 1- display text boxes with limitations for the user in wingrid.
I would guess you mean like the Drop Down List in your screen?
One easy way to do that in UltraGrid is with ValueLists: http://help.infragistics.com/Help/NetAdvantage/WinForms/2009.2/CLR2.0/html/WinGrid_Display_and_Store_Values_Using_ValueLists.html.
msherazkhan said:4- add a column with its specified type like numeric column or text column at run time.
Unbound Column at runtime: http://help.infragistics.com/Help/NetAdvantage/WinForms/2009.2/CLR2.0/html/WinGrid_Add_Unbound_Columns_to_WinGrid.html.
msherazkhan said:1- display text boxes with limitations for the user in wingrid.
I'm afraid I do not understand the question. What kind of limitation do you mean?
msherazkhan said:2- display checkboxes, read only text, numeric data, percentage data, pictures with limitations on design time or at run time. i would like to have an answer from your side.
A boolean column in the grid will automatically display as a TextBox.
Here's a KB article that describes all the way to make thing read-only in the grid: HOWTO:How can I make a grid or a column, row, or cell in the UltraWinGrid disabled or read-only?
For numeric data, it depends what you want. Do you mean masking? You could use the MaskInput property on the column. Or the Format property for formatting.
Percentages - you could display these using a Progress bar in the grid, or use the format to display a numeric value as a percent.
For pictures, there are a number of ways to do that. If your data source contains a picture, the grid will display it as such. If you want to add pictures to the grid in a cell with other data, you can use the cell's Appearance.
Again, I do not know what you mean by limitation. If you are talking about validation, then you can validate the grid data in an event of the grid, like BeforeRowUpdate or BeforeExitEditMode, or BeforeRowUpdate. Or, your data source can validate the data. Or you can use UltraWinValidator.
msherazkhan said:3- at run time, change the cell type of a column on an event like leave cell or key press.
I'm not sure what you mean by "cell type". The editor that a cell uses, such as text, checkbox, or image is determined by default by the DataType. You can also set the the Style property on the cell or column. Or use an Editor. Typically, it would not be feasible to change the type of a cell dynamically in the events you mention here, because the style of the cell would have to be compatible with the data type of the field in the data source and that can't change at run-time.
Adding columns is typically done either at design-time (if your data source exists at design-time) or in the InitializeLayout event of the grid. You just add a column to the band and set it's DataType and possibly also the Style or an editor.
msherazkhan said:I am very much overburdened now a days. You are requested to send me the csharp code for above mentioned things. you can understand i am in no state to go through all the examples and find one which is suitable for me.
I'm sure there are sample in the WinGrid Samples Explorer (which installs with the NetAdvantage SDK) that do just about everything you mentioned here.