i want hidden two field in my grid ,and i write code like this .
<igtbl:UltraGridBand> <Columns> <igtbl:UltraGridColumn BaseColumnName="SYSID" Hidden="True" IsBound="True" Key="SYSID"> <Header Caption="SYSID"> </Header> </igtbl:UltraGridColumn> <igtbl:UltraGridColumn BaseColumnName="DCODE" Hidden="True" IsBound="True" Key="DCODE"> <Header Caption="DCODE"> <RowLayoutColumnInfo OriginX="1" /> </Header> <Footer> <RowLayoutColumnInfo OriginX="1" /> </Footer> </igtbl:UltraGridColumn> <igtbl:UltraGridColumn BaseColumnName="DNAME" IsBound="True" Key="DNAME"> <Header Caption="DNAME"> <RowLayoutColumnInfo OriginX="2" /> </Header> <Footer> <RowLayoutColumnInfo OriginX="2" /> </Footer> </igtbl:UltraGridColumn> </Columns> <AddNewRow View="NotSet" Visible="NotSet"> </AddNewRow> </igtbl:UltraGridBand>
but after i set BaseTableName and DataKeyField like this to make update and delere working,it don't working of hidden anymore ,just show all field again
this is the code i modifed :
<igtbl:UltraGridBand DataKeyField="DCODE" BaseTableName="doc_yanse">
can anyone please tell me why?and any solution for that?
Hello,I am trying to reproduce the issue, unfortunately to no avail. I use NetAdvantage 8.3 VS 2008 SP1 and SQL Server 2005.Could you please send little bit more information about SQL queries. Please find attached sample project.
Hope this helps.
Also and ZIP format
I Have get this soluvoed,by set autogeneraterow to false,then it is ok,but thanks for you reply anyway
Great, thanks for sharing the solution in public forums - this will surely be appreciated by other people as well. My guess is the AutoGenerateColumns = True was creating another copies of the columns that were not hidden.