1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
| <asp:SqlDataSource ID="SqlDataSource1" runat="server"
UpdateCommand="UPDATE [T_ServiceSuccession] SET [Prénom]=@Prénom, [tel]=@Tel, [Service_Top]=@Top, [Qualité]=@Qualité WHERE ([Nom]=@Nom)"
OldValuesParameterFormatString = {0}>
<UpdateParameters >
<asp:Parameter Name= "Prénom" Type =String />
<asp:Parameter Name ="Tel" Type =String />
<asp:Parameter Name="Top" Type =String />
<asp:Parameter Name ="Qualité" Type =String />
<asp:Parameter Name ="Nom" Type=String />
</UpdateParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" Width="630px"
BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px"
CellPadding="3" DataSourceID="SqlDataSource1" Font-Names="arial" Font-Size="12px"
GridLines="Vertical" AutoGenerateColumns="false" PagerSettings-PageButtonCount="15"
AllowSorting="True" PageSize="15" AutoGenerateEditButton="true" DataKeyNames="Nom">
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<RowStyle BackColor="#EEEEEE" ForeColor="Black" />
<PagerStyle BackColor="#87ceeb" ForeColor="Black" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#87ceeb" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="Gainsboro" />
<Columns>
<asp:BoundField DataField="Nom" HeaderText="Nom" SortExpression="Nom" ReadOnly=true>
<ItemStyle Width= "150px" />
</asp:boundfield>
<asp:BoundField DataField="Prénom" HeaderText="Prénom" SortExpression="Prénom">
<ItemStyle Width= "110px" />
</asp:boundfield>
<asp:BoundField DataField="Tel" HeaderText="Téléphone" SortExpression="Tel">
<ItemStyle Width= "110px" />
</asp:boundfield>
<asp:BoundField DataField="Top" HeaderText="Top" SortExpression="Top">
<ItemStyle Width= "30px" />
</asp:boundfield>
<asp:BoundField DataField="Qualité" HeaderText="Qualité" SortExpression="Qualité">
<ItemStyle Width= "230px" />
</asp:boundfield>
</Columns>
<PagerSettings Mode="NumericFirstLast" />
</asp:GridView></center> |
Partager