1 2 3 4 5 6 7 8 9 10 11 12
| <asp:SqlDataSource ID="source" runat="server" ConnectionString="<%$ ConnectionStrings:connexion %>" SelectCommand="SELECT ID_Prospect,(Nom+' '+Prenom) as Nom,Sujet,Statut_Activite.Libelle as statu,Date_Crea FROM Prospect left join Statut_Activite on Statut_Activite.Id_Statut = Prospect.Statut ">
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID_Prospect"
DataSourceID="source" AllowPaging="False" AllowSorting="True" >
<Columns>
<asp:BoundField DataField="ID_Prospect" HeaderText="ID_Prospect" Visible="false" />
<asp:HyperLinkField DataTextField="Nom" HeaderText="Nom" SortExpression="Nom" NavigateUrl="http://msdn.microsoft.com/fr-fr/library/cc295223.aspx" />
<asp:BoundField DataField="Sujet" HeaderText="Sujet" SortExpression="Sujet" />
<asp:BoundField DataField="Statu" HeaderText="Statu" SortExpression="Statu" />
<asp:BoundField DataField="Date_Crea" HeaderText="Date de creation" SortExpression="Date de creation" />
</Columns>
</asp:GridView> |
Partager