getting info for hyperlink clicked

I am having troble displaying relevant information for a clicked hyperlink .

I have a table "Course" and "StudentInfo"

My Hyperlinks display list courses from DB* table(Course.table) and when I click one Hyperlink, the program has to get information for that link clicked from database

and display whether in a gridview or label (It has to check which hyperlink is clicked i guess)

this is how I display my hyperlinks from DB*

autogeneratecolumns="false"

runat="server">

datatextformatstring="{0:c}"

datanavigateurlfields="hyperlink"

datanavigateurlformatstring="~\WebForm1.aspx?hyperlink={0}"

headertext=""

if (!IsPostBack)

{

BindGrid(mygv);

}

try

{

SqlCommand cmd = new SqlCommand(" SELECT [hyperlink] FROM Courses WHERE [Student ID] = '" + Session["StudentID"] + "'", con);

con.Open();

SqlDataReader dr = cmd.ExecuteReader();

if (dr.HasRows)

{

mygv.DataSource = dr;

mygv.DataBind();

}

else

{

mygv.DataSource = null;

mygv.DataBind();

}

catch (Exception ex)

{

Response.Write("Error Occured: " + ex.ToString());

}

finally

{

con.Close();

}

how do I get the information for the link clicked??

test3.aspx code

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="test3.aspx.vb" Inherits="test3" %>

    Untitled Page



test3.aspx.vb code
Imports System.Data
Imports System.Data.SqlClient
Partial Class test3
    Inherits System.Web.UI.Page
    Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings.Item("ConnectionString").ToString()
    Dim con As New SqlConnection(strConnString)
    Dim str As String
    Dim com As SqlCommand
    Dim sqlda As SqlDataAdapter
    Dim ds As DataSet
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        bind()
    End Sub
    Sub bind()
        con.Open()
        str = "select * from employee"
        com = New SqlCommand(str, con)
        Dim reader As SqlDataReader
        reader = com.ExecuteReader()
        g4.DataSource = reader
        g4.DataBind()
        con.Close()
    End Sub
End Class

test4.aspx code

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="test4.aspx.vb" Inherits="test4" %>

    Untitled Page



test4.aspx.vb code

Imports System.Data
Imports System.Data.SqlClient
Partial Class test4
    Inherits System.Web.UI.Page
    Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings.Item("ConnectionString").ToString()
    Dim con As New SqlConnection(strConnString)
    Dim str As String
    Dim com As SqlCommand
    Dim sqlda As SqlDataAdapter
    Dim ds As DataSet
    Dim s1 As String
    Dim dt As DataTable
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Try
            con.Open()
            s1 = Request.QueryString(0)
            str = "select * from employee where empid='" + s1 + "'"
            com = New SqlCommand(str, con)
            g5.DataSource = com.ExecuteReader
            g5.DataBind()
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try
        con.Close()
    End Sub

End Class

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak13y ago
test3.aspx code

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="test3.aspx.vb" Inherits="test3" %>

    Untitled Page






















test3.aspx.vb code
Imports System.Data
Imports System.Data.SqlClient
Partial Class test3
    Inherits System.Web.UI.Page
    Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings.Item("ConnectionString").ToString()
    Dim con As New SqlConnection(strConnString)
    Dim str As String
    Dim com As SqlCommand
    Dim sqlda As SqlDataAdapter
    Dim ds As DataSet
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        bind()
    End Sub
    Sub bind()
        con.Open()
        str = "select * from employee"
        com = New SqlCommand(str, con)
        Dim reader As SqlDataReader
        reader = com.ExecuteReader()
        g4.DataSource = reader
        g4.DataBind()
        con.Close()
    End Sub
End Class

test4.aspx code

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="test4.aspx.vb" Inherits="test4" %>

    Untitled Page












test4.aspx.vb code

Imports System.Data
Imports System.Data.SqlClient
Partial Class test4
    Inherits System.Web.UI.Page
    Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings.Item("ConnectionString").ToString()
    Dim con As New SqlConnection(strConnString)
    Dim str As String
    Dim com As SqlCommand
    Dim sqlda As SqlDataAdapter
    Dim ds As DataSet
    Dim s1 As String
    Dim dt As DataTable
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Try
            con.Open()
            s1 = Request.QueryString(0)
            str = "select * from employee where empid='" + s1 + "'"
            com = New SqlCommand(str, con)
            g5.DataSource = com.ExecuteReader
            g5.DataBind()
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try
        con.Close()
    End Sub

End Class