How to click on a link based on another cell in same row

I have a landlord table, tenant table and a property table in my database.I have a html table that is dynamically created which shows the properties of the landlord that is signed in.When a tenant signs up it enters the propery ID which is the foreign key in the tenant table. When I click the view link on that html table, I would like it to be redirected to a new page showing the tenants that belong to that property.. I am unsure how to do this when the view link is clicked based on the property id in that row

Here is my html table

and here is the code for the dynamically created table

public partial class LandlordIndex : System.Web.UI.Page
{
//creating an empty string
string checkEmail = String.Empty;
//constructing a string called table that will be used to create a dynamic table
StringBuilder table = new StringBuilder();
protected void Page_Load(object sender, EventArgs e)
{
checkEmail += Session["LandlordLogin"];
//if session is not empty then show label with corresponding email used in log in
if (Session["LandlordLogin"] != null)
{
lblWelcome.Text += Session["LandlordLogin"].ToString();
}
else
{
Response.Redirect("Login.aspx");
}
if (!Page.IsPostBack)
{
//Creating a connection to my database using the connection string
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["rent-dbConnectionString1"].ToString();
con.Open();
SqlCommand comm = new SqlCommand();
//preparing a query which will select all properties matching the landlord that is logged in at that moment
comm.CommandText = "select p.Property_Id, p.Property_Address, p.Property_Num_Of_Tenants, p.Property_Vacant from Properties p inner join Landlords l On p.Landlord_Id = l.Landlord_Id where l.Landlord_Id = p.Landlord_Id and l.Landlord_Email = '" + checkEmail + "'";
comm.Connection = con;
SqlDataReader rd = comm.ExecuteReader();
//creating a table depending on the data that is selected from the query
table.Append("");
table.Append("Property Number");
table.Append("Address");
table.Append("Number of Tenants");
table.Append("Vacant?");
table.Append("View");
table.Append("");
if (rd.HasRows)
{
while(rd.Read())
{
table.Append("");
table.Append("" + rd[0] + "");
table.Append("" + rd[1] + "");
table.Append("" + rd[2] + "");
table.Append("" + rd[3] + "");
table.Append("View");
table.Append("");
}
}
table.Append("");
PlaceHolder1.Controls.Add(new Literal { Text = table.ToString() });
rd.Close();
}
}

3 Replies

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

Gautam Parmar8y ago
1. table.Append("View");
In above code href has your page with added ?id='+rd[0]+' so your table will have any primary key that value has to be of rd[IndexOfPrimaryKey]

Once you will redirect to another page your url will have carry that clicked id, and from url can retrieve id and show information.

To retrive an id from url you may
1. var url_string = window.location.href
2. var url = new URL(url_string);
3. var id= url.searchParams.get("id");
4. console.log(id);