How do I retrieve data from database based on the table row data id?

See more:

C#

I want to display the data retrieve from database to a table.


After i displayed to table as shown below, how do i enroll the student when clicked on "Enroll" based on the student id?

What I have tried:

public string getStudentData()
       {
           string data = "";
           using(SqlConnection conn = new SqlConnection(connectionString))
           {
               using(SqlCommand cmd = new SqlCommand())
               {
                   cmd.Connection = conn;
                   cmd.CommandType = CommandType.StoredProcedure;
                   cmd.CommandText = "UspGetStudents";
                   cmd.Connection.Open();
                   using(SqlDataReader sqlRdr = cmd.ExecuteReader())
                   {
                       // table = new DataTable();
                       // table.Load(reader);
                       if (sqlRdr.HasRows)
                       {
                           while (sqlRdr.Read())
                           {
                               int studentId = sqlRdr.GetInt32(0);
                               string Name = sqlRdr.GetString(1);
                               string EmailAddress = sqlRdr.GetString(2);
                               string Gender = sqlRdr.GetString(3);
                               data += "<tr><td>" + studentId + "</td>
                                            <td>" + Name + "</td>
                                            <td>" + EmailAddress + "</td>
                                            <td>" + Gender + "</td>
                                            <td><a href="#">"+Enroll+"</a></td></tr>";
                           }
                       }
                   }
               }
               return data;
           }
   }