Home » 2012 » October » 26

Archive for October 26, 2012

Update counter in lookup table

October 26, 2012 - Posted in .NET 4.0, Applications, ASP.NET, MS SQL, VS2010 - Permalink

Code behind Imports System.Web.UI Imports System.Data.Sql Imports System.Data.SqlClient Partial Class _Default Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load ‘acquire the ad id Dim adLookupCS As String = ConfigurationManager.ConnectionStrings + (“My_ConnectionString1”).ToString Dim adLookupConn As New SqlConnection(adLookupCS) Dim adLookupCmd As New SqlCommand(“SELECT * FROM recordLookup;”, adLookupConn) Dim adLookupRdr As SqlDataReader […]