> 
- Home Page
- > Script C#
- > Script C# Various
- > Counter
Counter - << VB.NET VERSION >>
Realize a simple access counter
<%@ Page Language="c#" Debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<script language="c#" runat="server">
private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection objCon = new SqlConnection("server=DBSERVER;User id=USER;password=PASSWORD;database=DB");
SqlCommand cmd = new SqlCommand("update Counter set Visite = Visite + 1", objCon);
objCon.Open();
SqlDataReader r = cmd.ExecuteReader();
r.Read();
CounterVisite.text = "Visite : " + r.item(0);
}
</script>
<html>
<head>
</head>
<body>
<asp:label ID="CounterVisite" runat="server"/>
</body>
</html>
