Hello
You can use Grid view and for opening the new page use Query string to pass the value and get the data from there corresponding to the query string.
Here is a Code snippet to help you with...
On Home Page Create a Gridview like this
<asp:GridView ID="gdvBookedProduct" runat="server" AutoGenerateColumns="False" CellPadding="4"
ForeColor="#333333" GridLines="None" Width="100%"
HeaderStyle-HorizontalAlign="Left"
onrowdatabound="gdvBookedProduct_RowDataBound">
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
<Columns>
<asp:TemplateField HeaderText="First Column">
<ItemTemplate>
<asp:LinkButton ID="lnkFirstColumn" runat="server" Text="First Column Value" OnClick="lnkFirstColumn_Click" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
<EditRowStyle BackColor="#999999" />
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#E9E7E2" />
<SortedAscendingHeaderStyle BackColor="#506C8C" />
<SortedDescendingCellStyle BackColor="#FFFDF8" />
<SortedDescendingHeaderStyle BackColor="#6F8DAE" />
</asp:GridView>
On Code behind of Home Page
protected void lnkDetails_Click(object sender, EventArgs e)
{
GridViewRow row = ((LinkButton)sender).Parent.Parent as GridViewRow;
int r = row.RowIndex;
string FirstColumnValue = gdvBookedProduct.Rows[r].Cells[0].Text.Trim();
Response.Redirect("SecondPage.aspx?FistColumnValue=" + FirstColumnValue);
}
On Second Page
Bind another grid with Select Statement and pass the query string to where condition.
string FirstColumnValue= Request.QueryString.Get("FirstColumnValue");
SqlConnection con = new SqlConnection("");
con.Open();
SqlCommand cmd = new SqlCommand("select * from tablename where FirstColumn = " + FirstColumnValue , con);
cmd.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "ss");
dataGridView1.DataSource = ds.Tables["ss"]; ;
I think this solution will help you. For any queries feel free to write back.