hi All,
i'm new in Infragistic tools and i don't understand how to design ultra win grid like attached file.
Data is cuming from Stored Procedure and i m using vb.net for this,.
please help me and reply me as soon as possible.
Thanks in Advance
Hi,
Which part of this is giving you trouble?
If you have your Stored Procedure returning data to your application using a DataTable or DataSet, then all you have to do is bind the grid to that data source.
To get a column arrangement like this, where you have one cell at the bottom that spans across all of the other cells, you have a couple of options.
One way to do this would be to use RowLayouts. You could do this in the grid designer at design-time. The designer comes up when you place a new grid on a form, so you can set it up that way, or just go into the designer by clicking on the grid's Start button and go to the Column Arrangement Overview.
An alternative option would be to use the grid's RowAutoPreview. The autopreview displays at the bottom of each row just like you have here. If you only have one cell of data to display and it doesn't need to be editable, then the RowAutoPreview is a simpler way to set this up than using RowLayouts.
Thanks for your reply. Actually i'm using Net Advantage Infragistic Tools 6.3 version. will i get these options watever u written in ur reply....?
actually the blank space is i think not a bottom coz after blank area again data fill come.
my requirments is to create grid like that, which can expand according to stored procedure data.
In blank area some data will also come from dataset.
please help me how to do that.
I am pretty sure that RowLayouts and RowAutoPreview were both available in v6 of the WinGrid. I'm not sure what the grid designer looked like back then, though, so I don't know if I can give you any specific instructions.
If you need more than one field spanning across then you will have to use a RowLayout. Set it up using the grid designer if you can. It's very hard to create a RowLayout in code.
Can you send me steps how to achieve RowLayouts and RowAutoPreview using wizard....?
i m not able to find this kind of options...
please see this attachments this will clear u my requriment....
that is second screen-shot of my requriment....
Please help me as soon as possible.
Hello ,
What you could is try the following code after your "Status" value has been changed:
if (Status == 2) { ultraGrid1.DisplayLayout.Bands[0].Columns[col6].Hidden = false; ultraGrid1.DisplayLayout.Bands[0].Columns[col7].Hidden = true; ultraGrid1.DisplayLayout.Bands[0].Columns[col8].Hidden = true; } if (Status == 3) { ultraGrid1.DisplayLayout.Bands[0].Columns[col6].Hidden = true; ultraGrid1.DisplayLayout.Bands[0].Columns[col7].Hidden = false; ultraGrid1.DisplayLayout.Bands[0].Columns[col8].Hidden = true; } if (Status == 4) { ultraGrid1.DisplayLayout.Bands[0].Columns[col6].Hidden = true; ultraGrid1.DisplayLayout.Bands[0].Columns[col7].Hidden = true; ultraGrid1.DisplayLayout.Bands[0].Columns[col8].Hidden = false; }
Hello,
Assuming that your are changing the "Status" value you could do something like the following right after this value has been changed:
i found this property and i changed it, now it is working.
tell me how to hide column of grid at run time based on some conditions..........?
Suppose Layout is like That:-
|col1||col2||col3||col4||col5|
______________________
col6
col7
col8
_______________________
Condition:-
if(Status==2)
Show:- col6
Hide:- col7 and col8
if(Status==3)
Show:- col7
Hide:- col6 and col8
if(Status==4)
Show:- col8
Hide:- col6 and col7
Please reply as soon as possible
These properties were added recently, so I am sure they do not exist in v6.3. Try this:
FAQ:How do I turn off the ActiveRowAppearance so that the active row in the grid does not appear selected.
This code is not working for me i m working on vb.net and using 6.3 version of infragistic.
Actually i've changed some property and i dont know which one i've changed.