Morpheusweb.it - Risorse per webmaster: script, ASP.NET, C#, Visual Basic .Net, tutorial, asp, javascript, css, php, html, java, ADO, VBScript, forms, frames, Active Server Pages, Dynamic HTML, database, gratis per webmaster e webdesigner

Leggere i dati da una tabella


<%@ Page Language="VB" Debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<script language="VB" runat="server">
Sub Page_Load(Source as Object, E as EventArgs)
  Dim cnn As New SQLConnection("server=DBSERVER;User id=USER;password=PASSWORD;database=DB")
  Dim objCommand As New SqlCommand("Select campo from tabella", objConn)
  objCommand.Connection.Open()
  Dim aReader As SqlDataReader = objCommand.ExecuteReader(CommandBehavior.CloseConnection)
  While aReader.Read()
    Response.Write(aReader.GetString(1) & "<br/>")
  End While
  aReader.Close()
  objConn.Close()
End sub
</script>



Scarica il Codice...


Stampa la pagina


 


Inizio pagina

risorse per webmaster