gpigate
01-13-2009, 12:32 AM
ok so I am more of a php guy.... I have a site that I am working on that is written in ASP. I am simply making some non db related, non asp related changes. However there are some things that I could do much easier by pulling the info from the database (mssql) instead of doing what I had intended.
It appears the site may have been generated at least partially by Vstudio.
So my question is.. Ihave found a function that I think looks to the database to get all records from a table. I also think I have found where it calls the function......... but none of it makes sense to me.
is there anyone out there that can help me decipher this code and extract what i need to do?
synopsis.
there is a page that lists all results from a table in a paginated format. instead of paginated I need to spool off all rows (roughly 1300) in a tabular layout with out pagination.
I think this is the layout and the table that calls the data get methods
<tr>
<td align="center" colspan="3">
<igtbl:UltraWebGrid ID="nameSearchResultsGrid" runat="server" Height="260px" Width="400px">
<Bands>
<igtbl:UltraGridBand>
<SelectedRowStyle BackColor="#CAD3E4" />
<RowEditTemplate>
</RowEditTemplate>
<AddNewRow View="NotSet" Visible="NotSet">
</AddNewRow>
<RowTemplateStyle BackColor="White" BorderColor="White" BorderStyle="Ridge">
<BorderDetails WidthBottom="3px" WidthLeft="3px" WidthRight="3px" WidthTop="3px" />
</RowTemplateStyle>
</igtbl:UltraGridBand>
</Bands>
<DisplayLayout AllowColSizingDefault="Free" AllowSortingDefault="OnClient" BorderCollapseDefault="Separate"
CellClickActionDefault="RowSelect" ColWidthDefault="" EnableInternalRowsManagement="True"
GridLinesDefault="Vertical" HeaderClickActionDefault="SortSingle" Name="nameSearchResultsGrid"
RowHeightDefault="20px" RowSelectorsDefault="No" ScrollBar="Always" SelectTypeRowDefault="Single"
StationaryMarginsOutlookGroupBy="True" TableLayout="Fixed" UseFixedHeaders="True"
Version="3.00" ScrollBarView="Vertical" StationaryMargins="Header">
<GroupByBox>
<Style BackColor="ActiveBorder" BorderColor="Window"></Style>
</GroupByBox>
<GroupByRowStyleDefault BackColor="Control" BorderColor="Window">
</GroupByRowStyleDefault>
<ActivationObject BorderStyle="Dotted">
</ActivationObject>
<FooterStyleDefault BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px">
<BorderDetails ColorLeft="White" ColorTop="White" />
</FooterStyleDefault>
<RowStyleDefault BackColor="Window" BorderColor="Gray" BorderStyle="Solid" BorderWidth="1px"
Font-Names="Arial" Font-Size="8pt">
<BorderDetails ColorLeft="Window" ColorTop="Window" />
<Padding Left="3px" />
</RowStyleDefault>
<FilterOptionsDefault>
<FilterDropDownStyle BackColor="White" BorderColor="Silver" BorderStyle="Solid" BorderWidth="1px"
CustomRules="overflow:auto;" Font-Names="Verdana,Arial,Helvetica,sans-serif"
Font-Size="11px" Width="200px">
<Padding Left="2px" />
</FilterDropDownStyle>
<FilterHighlightRowStyle BackColor="#151C55" ForeColor="White">
</FilterHighlightRowStyle>
</FilterOptionsDefault>
<ClientSideEvents AfterRowActivateHandler="nameSearchResultsGrid_AfterRowActivateHandler" />
<SelectedRowStyleDefault BackColor="#CAD3E4">
<BorderDetails ColorBottom="Black" ColorLeft="202, 211, 228" ColorRight="202, 211, 228"
ColorTop="202, 211, 228" StyleBottom="Solid" StyleLeft="None" StyleRight="None"
StyleTop="None" WidthBottom="1px" />
</SelectedRowStyleDefault>
<HeaderStyleDefault BackColor="#E9E7D7" BorderStyle="Solid">
<BorderDetails ColorBottom="DarkGray" ColorLeft="White" ColorTop="LightGray" StyleBottom="Solid"
StyleTop="Outset" WidthBottom="2px" WidthLeft="1px" WidthTop="1px" />
</HeaderStyleDefault>
<RowAlternateStyleDefault BackColor="#FFFFC0">
<BorderDetails ColorLeft="255, 255, 192" ColorTop="255, 255, 192" />
<Padding Left="3px" />
</RowAlternateStyleDefault>
<Images>
<ExpandImage Url="ig_tblcrm_rowarrow_right.gif" />
<CollapseImage Url="ig_tblcrm_rowarrow_down.gif" />
</Images>
<EditCellStyleDefault BorderStyle="None" BorderWidth="0px">
</EditCellStyleDefault>
<FrameStyle BorderStyle="Solid" BorderWidth="1px" Font-Names="Arial" Font-Size="8pt"
Height="260px" Width="400px">
</FrameStyle>
<Pager AllowCustomPaging="True" AllowPaging="True" PageSize="10">
<Style BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px" Font-Names="Arial"
Font-Size="8pt">
<BorderDetails ColorTop="White" WidthLeft="1px" WidthTop="1px" ColorLeft="White"></BorderDetails>
</Style>
</Pager>
<AddNewBox>
<Style BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px">
<BorderDetails ColorTop="White" WidthLeft="1px" WidthTop="1px" ColorLeft="White"></BorderDetails>
</Style>
</AddNewBox>
</DisplayLayout>
</igtbl:UltraWebGrid>
</td>
</tr>
There are a lot of functions in the same named file.vb at the end that start with nameSearchResultsGrid, which I think is functions that is calling the db and getting the data then returning and displaying... I do not need anywhere near the functions or features of the grid that is displayed above, no sort, no search , no nothing... just a tabular layout of all names in the table.
Anyone want to help? I can show the functions if needed, but its a lot of code.
It appears the site may have been generated at least partially by Vstudio.
So my question is.. Ihave found a function that I think looks to the database to get all records from a table. I also think I have found where it calls the function......... but none of it makes sense to me.
is there anyone out there that can help me decipher this code and extract what i need to do?
synopsis.
there is a page that lists all results from a table in a paginated format. instead of paginated I need to spool off all rows (roughly 1300) in a tabular layout with out pagination.
I think this is the layout and the table that calls the data get methods
<tr>
<td align="center" colspan="3">
<igtbl:UltraWebGrid ID="nameSearchResultsGrid" runat="server" Height="260px" Width="400px">
<Bands>
<igtbl:UltraGridBand>
<SelectedRowStyle BackColor="#CAD3E4" />
<RowEditTemplate>
</RowEditTemplate>
<AddNewRow View="NotSet" Visible="NotSet">
</AddNewRow>
<RowTemplateStyle BackColor="White" BorderColor="White" BorderStyle="Ridge">
<BorderDetails WidthBottom="3px" WidthLeft="3px" WidthRight="3px" WidthTop="3px" />
</RowTemplateStyle>
</igtbl:UltraGridBand>
</Bands>
<DisplayLayout AllowColSizingDefault="Free" AllowSortingDefault="OnClient" BorderCollapseDefault="Separate"
CellClickActionDefault="RowSelect" ColWidthDefault="" EnableInternalRowsManagement="True"
GridLinesDefault="Vertical" HeaderClickActionDefault="SortSingle" Name="nameSearchResultsGrid"
RowHeightDefault="20px" RowSelectorsDefault="No" ScrollBar="Always" SelectTypeRowDefault="Single"
StationaryMarginsOutlookGroupBy="True" TableLayout="Fixed" UseFixedHeaders="True"
Version="3.00" ScrollBarView="Vertical" StationaryMargins="Header">
<GroupByBox>
<Style BackColor="ActiveBorder" BorderColor="Window"></Style>
</GroupByBox>
<GroupByRowStyleDefault BackColor="Control" BorderColor="Window">
</GroupByRowStyleDefault>
<ActivationObject BorderStyle="Dotted">
</ActivationObject>
<FooterStyleDefault BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px">
<BorderDetails ColorLeft="White" ColorTop="White" />
</FooterStyleDefault>
<RowStyleDefault BackColor="Window" BorderColor="Gray" BorderStyle="Solid" BorderWidth="1px"
Font-Names="Arial" Font-Size="8pt">
<BorderDetails ColorLeft="Window" ColorTop="Window" />
<Padding Left="3px" />
</RowStyleDefault>
<FilterOptionsDefault>
<FilterDropDownStyle BackColor="White" BorderColor="Silver" BorderStyle="Solid" BorderWidth="1px"
CustomRules="overflow:auto;" Font-Names="Verdana,Arial,Helvetica,sans-serif"
Font-Size="11px" Width="200px">
<Padding Left="2px" />
</FilterDropDownStyle>
<FilterHighlightRowStyle BackColor="#151C55" ForeColor="White">
</FilterHighlightRowStyle>
</FilterOptionsDefault>
<ClientSideEvents AfterRowActivateHandler="nameSearchResultsGrid_AfterRowActivateHandler" />
<SelectedRowStyleDefault BackColor="#CAD3E4">
<BorderDetails ColorBottom="Black" ColorLeft="202, 211, 228" ColorRight="202, 211, 228"
ColorTop="202, 211, 228" StyleBottom="Solid" StyleLeft="None" StyleRight="None"
StyleTop="None" WidthBottom="1px" />
</SelectedRowStyleDefault>
<HeaderStyleDefault BackColor="#E9E7D7" BorderStyle="Solid">
<BorderDetails ColorBottom="DarkGray" ColorLeft="White" ColorTop="LightGray" StyleBottom="Solid"
StyleTop="Outset" WidthBottom="2px" WidthLeft="1px" WidthTop="1px" />
</HeaderStyleDefault>
<RowAlternateStyleDefault BackColor="#FFFFC0">
<BorderDetails ColorLeft="255, 255, 192" ColorTop="255, 255, 192" />
<Padding Left="3px" />
</RowAlternateStyleDefault>
<Images>
<ExpandImage Url="ig_tblcrm_rowarrow_right.gif" />
<CollapseImage Url="ig_tblcrm_rowarrow_down.gif" />
</Images>
<EditCellStyleDefault BorderStyle="None" BorderWidth="0px">
</EditCellStyleDefault>
<FrameStyle BorderStyle="Solid" BorderWidth="1px" Font-Names="Arial" Font-Size="8pt"
Height="260px" Width="400px">
</FrameStyle>
<Pager AllowCustomPaging="True" AllowPaging="True" PageSize="10">
<Style BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px" Font-Names="Arial"
Font-Size="8pt">
<BorderDetails ColorTop="White" WidthLeft="1px" WidthTop="1px" ColorLeft="White"></BorderDetails>
</Style>
</Pager>
<AddNewBox>
<Style BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px">
<BorderDetails ColorTop="White" WidthLeft="1px" WidthTop="1px" ColorLeft="White"></BorderDetails>
</Style>
</AddNewBox>
</DisplayLayout>
</igtbl:UltraWebGrid>
</td>
</tr>
There are a lot of functions in the same named file.vb at the end that start with nameSearchResultsGrid, which I think is functions that is calling the db and getting the data then returning and displaying... I do not need anywhere near the functions or features of the grid that is displayed above, no sort, no search , no nothing... just a tabular layout of all names in the table.
Anyone want to help? I can show the functions if needed, but its a lot of code.