Hi EddieP,
Please take reference to the below code and correct your code.
HTML
<asp:LinkButton ID="LinkButton1" runat="server" OnClick="Count">Count1</asp:LinkButton>
<br />
<asp:LinkButton ID="LinkButton2" runat="server" OnClick="Count">Count2</asp:LinkButton>
<br />
<asp:LinkButton ID="LinkButton3" runat="server" OnClick="Count">Count3</asp:LinkButton>
<br />
<asp:LinkButton ID="LinkButton4" runat="server" OnClick="Count">Count4</asp:LinkButton>
<br />
<asp:LinkButton ID="LinkButton5" runat="server" OnClick="Count">Count5</asp:LinkButton>
<br />
Clicked Count :
<asp:Label ID="lblCount" runat="server"></asp:Label>
Namespaces
C#
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
VB.Net
Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration
Code
C#
protected void Count(object sender, EventArgs e)
{
int previousCount = 0;
string strConstr = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
using (SqlConnection con = new SqlConnection(strConstr))
{
using (SqlCommand cmd = new SqlCommand("SELECT CountStatus FROM Incrementdecrement WHERE USERID = 1", con))
{
con.Open();
previousCount = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
lblCount.Text = previousCount.ToString();
}
using (SqlCommand cmd = new SqlCommand("UPDATE Incrementdecrement SET CountStatus = @CountStatus WHERE USERID = 1", con))
{
previousCount = previousCount + 1;
con.Open();
cmd.Parameters.AddWithValue("@CountStatus", previousCount.ToString());
cmd.ExecuteNonQuery();
con.Close();
this.lblCount.Text = previousCount.ToString();
}
}
}
VB.Net
Protected Sub Count(ByVal sender As Object, ByVal e As EventArgs)
Dim previousCount As Integer = 0
Dim strConstr As String = ConfigurationManager.ConnectionStrings("conString").ConnectionString
Using con As SqlConnection = New SqlConnection(strConstr)
Using cmd As SqlCommand = New SqlCommand("SELECT CountStatus FROM Incrementdecrement WHERE USERID = 1", con)
con.Open()
previousCount = Convert.ToInt32(cmd.ExecuteScalar())
con.Close()
lblCount.Text = previousCount.ToString()
End Using
Using cmd As SqlCommand = New SqlCommand("UPDATE Incrementdecrement SET CountStatus = @CountStatus WHERE USERID = 1", con)
previousCount = previousCount + 1
con.Open()
cmd.Parameters.AddWithValue("@CountStatus", previousCount.ToString())
cmd.ExecuteNonQuery()
con.Close()
Me.lblCount.Text = previousCount.ToString()
End Using
End Using
End Sub