Torna al Thread

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ASPNETDBConnectionString7 %>" DeleteCommand="DELETE FROM shoutbox WHERE (message_id = @message_id)" InsertCommand="INSERT INTO shoutbox(message, message_title, user_id, message_id) VALUES (@message, @message_title, @user_id, @message_id)" SelectCommand="SELECT * FROM shoutbox" UpdateCommand="UPDATE shoutbox SET message = @message, message_title = @message_title"> <DeleteParameters> <asp:Parameter Name="message_id" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="message_title" /> <asp:ControlParameter ControlID="TextBox1" DefaultValue="defvalueprova" Direction="InputOutput" Name="message" Type="String" /> </UpdateParameters> <InsertParameters> <asp:ControlParameter ControlID="TextBox1" DefaultValue="defvalueprova" Direction="InputOutput" Name="message" Type="String" /> <asp:Parameter Name="message_title" /> <asp:Parameter Name="user_id" /> <asp:Parameter Name="message_id" /> </InsertParameters> </asp:SqlDataSource> <asp:DetailsView ID="DetailsView1" runat="server" Height="150px" Width="280px" DataKeyNames="message_id" DataSourceID="SqlDataSource1" AllowPaging="True" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" AutoGenerateInsertButton="True" AutoGenerateRows="False" CaptionAlign="NotSet" DefaultMode="ReadOnly" HorizontalAlign="Left"> <Fields> <asp:TemplateField><ItemTemplate> <asp:TextBox ID="TextBox2" runat="server" Text="ciao"></asp:TextBox></ItemTemplate></asp:TemplateField> <asp:BoundField DataField="message_date" HeaderText="message_date" SortExpression="message_date" /> <asp:BoundField DataField="message_title" HeaderText="message_title" SortExpression="message_title" /> <asp:BoundField DataField="user_id" HeaderText="user_id" SortExpression="user_id" /> <asp:BoundField DataField="message_id" HeaderText="message_id" SortExpression="message_id" /> </Fields> </asp:DetailsView>
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5