I used ASP.net.
ASP is not worth learning.
<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" Debug="True" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script runat="server">
Sub Page_load
Dim myConn As SqlConnection
Dim myQuery As String
Dim myCmd As SqlCommand
Dim scorereader As SqlDataReader
myConn = New SqlConnection("server=desktop;uid=sa;pwd=developer;database=techforum")
myQuery = "select score from player"
myCmd = New SqlCommand(myQuery,myConn)
myConn.Open()
scorereader = myCmd.ExecuteReader()
displayarea.DataSource = scorereader
displayare.DataBind()
scorereader.Close()
myConn.Close
End Sub
</script>
<html>
<body>
<form runat="server">
<asp:datalist runat="server" ID="displayarea">
<itemtemplate>
<%# Container.DataItem("score") %>
</itemtemplate>
</asp:datalist>
</form>
</body>
</html>
You can also find the sum in the same way. This is a very basic way. There are many more methods available.
Similarly sum can also be found out.
