<asp:DetailsView ID="DetailsView1" runat="Server" CellPadding="4" ForeColor="#333333" GridLines="None" Width="100%" DataSourceID="SqlDataSource1" AllowPaging="True" AutoGenerateRows="False" DataKeyNames="QuestionID" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" AutoGenerateInsertButton="True" DefaultMode="Edit" > <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <CommandRowStyle BackColor="#E2DED6" Font-Bold="True" /> <EditRowStyle BackColor="#999999" /> <RowStyle BackColor="#F7F6F3" ForeColor="#333333" /> <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" /> <FieldHeaderStyle BackColor="#E9ECF1" Font-Bold="True" /> <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <AlternatingRowStyle BackColor="White" ForeColor="#284775" /> <Fields> <asp:TemplateField HeaderText="QuestionID"> <ItemTemplate> <%# Eval("QuestionID") %> </ItemTemplate> </asp:TemplateField> <asp:BoundField DataField="Questiontext" HeaderText="Questiontext" /> <asp:BoundField DataField="Helptext" HeaderText="Helptext" /> <asp:BoundField DataField="Answertype" HeaderText="Answertype" /> </Fields> </asp:DetailsView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString='<%$ ConnectionStrings:ConnectionString %>' SelectCommand="Select * FROM Questions WHERE SurveyId=@sid" DeleteCommand="Delete FROM Questions WHERE QuestionID = @QID" UpdateCommand="UPDATE Questions SET Questiontext = @text, Helptext = @htext, Answertype = @atype WHERE QuestionID = @QID" > <DeleteParameters> <asp:Parameter Name="QID" Type="Int32" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="QID" Type="Int32" /> <asp:Parameter Name="text" Type="string" /> <asp:Parameter Name="htext" Type="string" /> <asp:Parameter Name="atype" Type="string" /> </UpdateParameters> <SelectParameters> <asp:QueryStringParameter Name="sid" QueryStringField="SurveyId"/> </SelectParameters> </asp:SqlDataSource>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)