HenOwnenodelS
New Member
Scenario: I am developing a web application that allows users to upload Excel files into their respective tables in a SQL Server 2008 R2 database. I am also running an ETL process developed using SSIS when the user clicks on the upload button.My development environment: Asp.net, IIS7, C#, SQL Server 2008 R2I am currently facing the problem to shift the 'download error' column to the last column of the table. I did not define any columns for the other columns in the gridview as i am doing a direct pull from my tables in the sql database.Question: How do i shift my 'download error' column to the last column of the table. Below are my codes:\[code\]<asp:GridView ID="aeGridView" runat="server" CaptionAlign="Top" HorizontalAlign="Justify" DataKeyNames="id" onselectedindexchanged="aeGridView_SelectedIndexChanged" onrowdatabound="aeGridView_RowDataBound" ToolTip="Excel File Download Tool" CellPadding="4" ForeColor="#333333" GridLines="None" Width="855px"> <RowStyle BackColor="#E3EAEB"/> <Columns> <asp:CommandField ShowSelectButton="True" SelectText="Download Errors" ControlStyle-ForeColor="Blue" > <ControlStyle ForeColor="Blue"></ControlStyle> </asp:CommandField> </Columns> <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" /> <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" /> <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" /> <EditRowStyle BackColor="#7C6F57" Width="150px" /> <AlternatingRowStyle BackColor="White" /> <SortedAscendingCellStyle BackColor="#F8FAFA" /> <SortedAscendingHeaderStyle BackColor="#246B61" /> <SortedDescendingCellStyle BackColor="#D4DFE1" /> <SortedDescendingHeaderStyle BackColor="#15524A" /> </asp:GridView> \[/code\]Are there any ways that I can resolve this? Thanks for helping!