Display count of favorite teacher added by particular user using C# and VB.Net in ASP.Net

Hi micah,

I have created sample code which full-fill your requirement.

HTML

<div>
    <table border="0" cellpadding="0" cellspacing="0">
        <tr>
            <td>
                UserName
            </td>
            <td>
                <asp:TextBox ID="txtUserName" runat="server" />
            </td>
        </tr>
        <tr>
            <td>
                Password
            </td>
            <td>
                <asp:TextBox ID="txtPassword" TextMode="Password" runat="server" />
            </td>
        </tr>
        <tr>
            <td colspan="2">
                <asp:Button ID="btnSubmit" Text="Login" OnClick="OnLogin" runat="server" />
            </td>
        </tr>
    </table>
</div>

C#

private string constring = ConfigurationManager.ConnectionStrings["constring"].ToString();
protected void OnLogin(object sender, EventArgs e)
{
    using (SqlConnection con = new SqlConnection(constring))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT * FROM [User] WHERE UserName=@UserName AND Password=@Password", con))
        {
            cmd.Parameters.AddWithValue("@Username", txtUserName.Text.Trim());
            cmd.Parameters.AddWithValue("@Password", txtPassword.Text.Trim());
            con.Open();
            SqlDataReader idr = cmd.ExecuteReader();
            if (idr.Read())
            {
                Session["UserName"] = idr["UserName"].ToString();
                Response.Redirect("Default2.aspx");
            }
            con.Close();
        }
    }
}

ViewPage

<form id="form1" runat="server">
<div>
    <asp:FormView ID="formview1" runat="server" Width="100%" OnDataBound="formview1_DataBound">
        <ItemTemplate>
            <table>
                <tr>
                    <td>
                        <asp:Label ID="FavoriteId" Text="0" Visible="false" runat="server" />
                        <asp:Label ID="lblId" Text='<%#Eval("favoriteId") %>' Visible="false" runat="server" />
                    </td>
                    <td>
                        UserName:<asp:Label ID="lblUserName" Text='<%#Eval("StudentUserName")%>' runat="server" />
                    </td>
                </tr>
                <tr>
                    <td>
                    </td>
                    <td>
                        Count:
                        <asp:Label ID="lblCount" Text="0" runat="server" />
                    </td>
                </tr>
            </table>
        </ItemTemplate>
    </asp:FormView>
</div>
<asp:LinkButton ID="btnback" OnClick="OnBack" Text="Back" runat="server" />
</form>

C#

private string constring = ConfigurationManager.ConnectionStrings["constring"].ToString();
protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        this.GetData();
    }
}

private void GetData()
{
    using (SqlConnection con = new SqlConnection(constring))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT [favoriteId],[StudentUserName],[TeachersUserName],[Status] FROM [Dim_favorite] WHERE StudentUserName='" + Session["UserName"] + "'", con))
        {
            DataTable dt = new DataTable();
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            sda.Fill(dt);
            formview1.DataSource = dt;
            formview1.DataBind();
        }
    }
}

protected void OnBack(object sender, EventArgs e)
{
    Response.Redirect("Default.aspx");
}

protected void formview1_DataBound(object sender, EventArgs e)
{
    string userName = (formview1.FindControl("lblUserName") as Label).Text;
    using (SqlConnection con = new SqlConnection(constring))
    {
        using (SqlCommand cmd = new SqlCommand(" SELECT COUNT(StudentUserName) as Count FROM Dim_favorite where StudentUserName='" + userName + "'AND Status='1'", con))
        {
            con.Open();
            SqlDataReader idr = cmd.ExecuteReader();
            if (idr.Read())
            {
                (formview1.FindControl("lblCount") as Label).Text = idr["Count"].ToString();
            }

            con.Close();
        }
    }
}

Vb.Net

private string constring = ConfigurationManager.ConnectionStrings["constring"].ToString();
protected void OnLogin(object sender, EventArgs e)
{
    using (SqlConnection con = new SqlConnection(constring))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT * FROM [User] WHERE UserName=@UserName AND Password=@Password", con))
        {
            cmd.Parameters.AddWithValue("@Username", txtUserName.Text.Trim());
            cmd.Parameters.AddWithValue("@Password", txtPassword.Text.Trim());
            con.Open();
            SqlDataReader idr = cmd.ExecuteReader();
            if (idr.Read())
            {
                Session["UserName"] = idr["UserName"].ToString();
                Response.Redirect("Default2.aspx");
            }
            con.Close();
        }
    }
}

ViewPage

Private constring As String = ConfigurationManager.ConnectionStrings("constring").ToString()
Protected Sub Page_Load(sender As Object, e As EventArgs)
	If Not IsPostBack Then
		Me.GetData()
	End If
End Sub

Private Sub GetData()
	Using con As New SqlConnection(constring)
		Using cmd As New SqlCommand("SELECT [favoriteId],[StudentUserName],[TeachersUserName],[Status] FROM [Dim_favorite] WHERE StudentUserName='" + Session("UserName") + "'", con)
			Dim dt As New DataTable()
			Dim sda As New SqlDataAdapter(cmd)
			sda.Fill(dt)
			formview1.DataSource = dt
			formview1.DataBind()
		End Using
	End Using
End Sub

Protected Sub OnBack(sender As Object, e As EventArgs)
	Response.Redirect("Default.aspx")
End Sub

Protected Sub formview1_DataBound(sender As Object, e As EventArgs)
	Dim userName As String = TryCast(formview1.FindControl("lblUserName"), Label).Text
	Using con As New SqlConnection(constring)
		Using cmd As New SqlCommand((Convert.ToString(" SELECT COUNT(StudentUserName) as Count FROM Dim_favorite where StudentUserName='") & userName) + "'AND Status='1'", con)
			con.Open()
			Dim idr As SqlDataReader = cmd.ExecuteReader()
			If idr.Read() Then
				TryCast(formview1.FindControl("lblCount"), Label).Text = idr("Count").ToString()
			End If

			con.Close()
		End Using
	End Using
End Sub

Screenshot