The code:
Expand|Select|Wrap|Line Numbers
- <asp:SqlDataSource ID="dsMyReports" runat="server"
- ConnectionString="<%$ ConnectionStrings:vortex2devConnectionString %>"
- SelectCommand="SELECT [ID], [Name], [Description] FROM [Report] WHERE (([IsPublic] = @IsPublic) AND ([OwnedByUserID] = @userID))"
- OnSelecting="dsMyReports_Selecting"
- DeleteCommand="DELETE FROM Report WHERE ID = @reportID"
- UpdateCommand="UPDATE Report SET Name = @Name, Description = @Description WHERE ID = @ID">
- <SelectParameters>
- <asp:Parameter DefaultValue="0" Name="IsPublic" Type="Int32" />
- <asp:Parameter DefaultValue="" Name="userID" Type="Int32" />
- </SelectParameters>
- <DeleteParameters>
- <asp:Parameter Name="reportID" />
- </DeleteParameters>
- <UpdateParameters>
- <asp:Parameter Name="Name" />
- <asp:Parameter Name="Description" />
- <asp:Parameter Name="ID" />
- </UpdateParameters>
- </asp:SqlDataSource>
- <asp:GridView ID="myReportsGrid" runat="server" AutoGenerateColumns="False" DataSourceID="dsMyReports" DataKeyNames="ID">
- <Columns>
- <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
- <asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" />
- <asp:CommandField ControlStyle-Width="16px" ButtonType="Image" EditImageUrl="~/images/edit_icon2.gif" ShowEditButton="true" />
- </Columns>
- </asp:GridView>