dotNetHell.it - Forum - Codice Sorgente

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Import Namespace = "System.Data"%>
<%@ Import Namespace = "System.Data.OleDb" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >

<script language="c#" runat="server">
    void Load_Page(object Object, EventArgs e)
    {
        string Scn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("Clienti.mdb");
        OleDbConnection cnn = new OleDbConnection(Scn);
        cnn.Open();
        OleDbCommand cmd = new OleDbCommand("select * from Categories", cnn);
        OleDbDataReader res = cmd.ExecuteReader();
        while (res.Read())
        {
            Response.Write(res["GENERI"]);
            res.Close();
            cnn.Close();
        }
        

    }
   
</script>

<body>

    <form id="form1" runat="server">
    <div style="text-align: center">
        Benvenuti nel miglior negozio di DVD Italiano!<table style="width: 353px; height: 176px">
                <tr>
                    <td>
                    
                    </td>
                    <td>
                    </td>
                    <td>
                    </td>
                </tr>
                <tr>
                    <td>
                    </td>
                    <td>
                    </td>
                    <td>
                    </td>
                </tr>
                <tr>
                    <td>
                    </td>
                    <td>
                    </td>
                    <td>
                    </td>
                </tr>
            </table>
        
        <br />
        <br />
        <span style="font-size: 24pt">Ecco i principali generi presenti<br />
            <br />
        
        </span>
    
    </div>
    </form>
</body>
</html>