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
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.Code:<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>
Anyone want to help? I can show the functions if needed, but its a lot of code.



Reply With Quote
Bookmarks