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.
Hello anuj1692,
What you could try is setting the following in the InitializeLayout event of the UltraGrid:
private void ultraGrid1_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e) { //If you need to turn off the Active appearances e.Layout.Override.ActiveAppearancesEnabled = Infragistics.Win.DefaultableBoolean.False; //If you need to turn off the Selected appearances e.Layout.Override.SelectedAppearancesEnabled = Infragistics.Win.DefaultableBoolean.False; }
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.
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.
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
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; }