%@ Page Language="VB" %> <%@ import Namespace="System.Data" %> <%@ import Namespace="System.Data.SqlClient" %> <script runat="server"> Sub Page_Load(Sender As Object, E As EventArgs) 'config de votre connection Dim ConnectionString As String = "server=(local);database=SDS;trusted_connection=true" 'votre requete sql Dim CommandText As String = "select * from commande" Dim myConnection As New SqlConnection(ConnectionString) Dim myCommand As New SqlCommand(CommandText, myConnection) myConnection.Open() DataGrid1.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection) DataGrid1.DataBind() End Sub </script> <html> <head> </head> <body style="FONT-FAMILY: arial"> <h2>Simple Data Report </h2> <hr size="1" /> <form runat="server"> <asp:datagrid id="DataGrid1" runat="server" CellSpacing="1" GridLines="None" CellPadding="3" BackColor="White" ForeColor="Black" EnableViewState="False"> <HeaderStyle font-bold="True" forecolor="white" backcolor="#4A3C8C"></HeaderStyle> <ItemStyle backcolor="#DEDFDE"></ItemStyle> </asp:datagrid> </form> </body> </html>
Télécharger le zip
Se souvenir du profil
Mot de passe oublié ? / Activation de compteCréer un compte
1 903 442 membres 25 nouveaux aujourd'hui 16 195 membres club