Leggere i dati da una tabella
<%@ Page language="c#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<script language="c#" runat="server">
private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection cnn = new SqlConnection("server=DBSERVER;User id=USER;password=PASSWORD;database=DB");
SqlCommand objCommand = new SqlCommand("Select campo from tabella", objConn);
objCommand.Connection.Open();
SqlDataReader aReader = objCommand.ExecuteReader(CommandBehavior.CloseConnection);
try
{
while (aReader.Read())
response.Write(aReader.GetString(1) + "<br/>");
}
finally
{
aReader.Close();
objConn.Close();
}
}
</script>
Scarica il Codice...
Stampa la pagina