Intersoft Solutions - Community - WebGrid Enterprise - hide columnn without losing structure

Community / WebGrid

Latest Development Blogs

Retrieving News

ForumPostTopic

WebGrid Enterprise

2138

8348

WebCombo

357

1383

WebDesktop

430

1620

WebTreeView

263

WebScheduler

253

944

WebTextEditor

118

423

357

134

114

567

1861

Lounge

305

768

Crosslight

366

1443

Browse By Tag

hide columnn without losing structure

8 replies. Last post: September 2, 2009 11:34 PM by Gordon Tumewu

Tags :

(None)

Create New

New Discussion
New Question
New Product Feedback

Post Reply

koby shaboMember

Posted: August 24, 2009 11:09 AM

hi i have a nested(With Child Table) web grid

when i try to hide columns after getting from db what columns should appear i lose the structure

in my remarks column i get the values of other columns

please tell me how to do this

<ISWebGrid:WebGrid ID="WebGrid1" runat="server" Height="100%" DataMember="parent"

UseDefaultStyle="True" DefaultStyleMode="Elegant" Width="100%" OnInitializeDataSource="WebGrid1_InitializeDataSource" OnInitializeLayout="WebGrid1_InitializeLayout"

OnBatchUpdate="WebGrid1_BatchUpdate" OnInitializeRow="WebGrid1_InitializeRow">

<LayoutSettings AutoHeight="true" AutoFitColumns="false" AllowSelectColumns="Yes"

AllowExport="Yes" AllowFilter="Yes" AllowContextMenu="true" CellClickAction="CellSelect"

AllowBatchUpdate="true" Hierarchical="true" AllowEdit="Yes" AllowSorting="Yes">

<ClientSideEvents OnCellDblClick="MainGridDbClick()" OnAfterExitEditMode="CalcUsedBudget()"

OnEnterEditMode="SetPreTotalAmount" OnInitialize="ColumnPer();" />

</LayoutSettings>

<ISWebGrid:WebGridTable DataMember="child" DataKeyField="exec_guid">

<ISWebGrid:WebGridColumn Caption="exec_guid" DataMember="exec_guid" Visible="false"

EditType="NoEdit" Name="exec_guid">

</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption="™ ™…" DataMember="payment_name" EditType="NoEdit"

Name="payment_name">

</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption="‘‹… ™…" DataMember="payment_value" DataType="System.Float"

EditType="NoEdit" Name="payment_value" DataFormatString="n">

</ISWebGrid:WebGridColumn>

<%-- <ISWebGrid:WebGridColumn Caption="—‰… ”˜…ˆ ‡‰™…" ColumnType="CheckBox" DataMember="debug_enabled"

DataType="System.Bit" EditType="NoEdit" Name="debug_enabled">

</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption="‹…" DataMember="debug_url" EditType="NoEdit"

Name="debug_url">

</ISWebGrid:WebGridColumn>--%>

</Columns>

</ISWebGrid:WebGridTable>

</ChildTables>

<ISWebGrid:WebGridColumn Caption="plan_exec_result_id" DataMember="plan_exec_result_id"

Visible="false" EditType="NoEdit" Name="plan_exec_result_id" Width="100px">

</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption="exec_guid" DataMember="exec_guid" Visible="false"

EditType="NoEdit" Name="exec_guid" Width="100px">

</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption="™" DataMember="person_name" ColumnType="Text"

EditType="NoEdit" Name="payment_name" Width="100px">

</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption='"†' DataMember="person_pid_no" EditType="NoEdit"

Name="person_pid_no" Width="100px">

</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption="”—‰ƒ" DataMember="person_position_name" EditType="NoEdit"

Name="person_position_name" Width="100px">

</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption="‡—„" DataMember="unit_name" EditType="NoEdit"

Name="unit_name" Width="100px">

</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption="…‹‰" DataMember="plan_name" EditType="NoEdit"

Name="plan_name" Width="100px">

</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption="™… ‘‰‘" DataMember="payment_value" DataType="System.Decimal"

DataFormatString="n" EditType="NoEdit" Name="payment_value" Width="100px">

</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption="„…‘” €‡…†" DataMember="manager_per" DataType="System.Decimal"

DataFormatString="n" EditType="TextBox" Name="manager_per" DefaultText="0" Width="100px"

InputRequired="True" InputRequiredErrorText="Please enter a value" DefaultValue="0">

</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption="„…‘” ’˜" DataMember="manager_quantity" DataType="System.Decimal"

DataFormatString="n" EditType="TextBox" Name="manager_quantity" Width="100px"

DefaultValue="0" DefaultText="0" InputRequired="True" InputRequiredErrorText="Please enter a value">

</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption='‘„"‹ ™…' DataMember="manager_total_amount"

DataType="System.Decimal" DataFormatString="#.##" EditType="NoEdit" Name="manager_total_amount"

Width="100px">

</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption="„’˜…" DataMember="manager_remarks" EditType="TextBox"

Name="manager_remarks" Width="100px">

</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption="URL" DataMember="debug_url" EditType="TextBox"

Visible="false" Name="debug_url" Width="100px">

</ISWebGrid:WebGridColumn>

</Columns>

</RootTable>

</ISWebGrid:WebGrid>

Quick Reply

Quote

All Replies

Gordon TumewuSupport

Posted: August 24, 2009 11:24 PM in response to koby shabo

Hi Koby,

Could you describe more spesific about the issue? What structure that you lost? Also step to reproduce the issue.

Thanks.

Best Regards,

Gordon Tumewu

Quick Reply

Quote

George BrandesMember

Posted: August 26, 2009 10:53 AM in response to koby shabo

Try setting the width to 0px.

Quick Reply

Quote

koby shaboMember

Posted: August 27, 2009 7:43 AM in response to Gordon Tumewu

hi Gordon ,

thx for the replay.

when i try to hide in the server or client one of my columns the structre change

sample :

in the second column i have First Name in third i have Last Name and the next is remrks.

if i hide the last name in the firstname i get the last name data and in the remrks i get fhe first name data the column is hidden but the data get mixed up

thanks in advance

koby

Quick Reply

Quote

Gordon TumewuSupport

Posted: August 31, 2009 4:09 AM in response to koby shabo

Hi Koby,

Could I know the code that you used to hide the column?

Best Regards,

Gordon Tumewu

Quick Reply

Quote

koby shaboMember

Posted: September 1, 2009 8:27 AM in response to Gordon Tumewu

protected void WebGrid1_InitializeLayout(object sender, ISNet.WebUI.WebGrid.LayoutEventArgs e)

{

WebGrid1.RootTable.Columns[4].Visible = false; // first try dont work

WebGrid1.RootTable.Columns[4].CellStyle.Width = System.Web.UI.WebControls.Unit.Pixel(0); // second try dont work

}

Quick Reply

Quote

Gordon TumewuSupport

Posted: September 1, 2009 11:03 PM in response to koby shabo

Hi Koby,

Actually you only need the WebGrid1.RootTable.COlumns[4].Visible = false. But you need to put it in PrepareDataBinding event not in InitializeLayout.

Hope this helps.

Best Regards,

Gordon Tumewu

Quick Reply

Quote

koby shaboMember

Posted: September 2, 2009 1:50 AM in response to Gordon Tumewu

Hi Gordon,

no i'm sorry but this is not working.

just a reminder this is a grid with a

RootTable and ChildTables!!!!!

Quick Reply

Quote

Gordon TumewuSupport

Posted: September 2, 2009 11:34 PM in response to koby shabo

Hi Koby,

Please for the next time no need to use th "!" mark, I can read it perfectly without any "!" mark.

Before I gave you the solution I have tested it by creating a simple sample. Here I attached my simple sample that I used to test, please check it and let me know if you have different scenario than my sample.

1 attachment

2009R1.zip

Quick Reply

Quote