Bind GridView based on another GridView row selection using C# in ASP.Net

Hi

I have 2 GridView. When i click on grdview1 corresponding data from database should bind to grdview2. Please help

<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" OnSelectedIndexChanged="GridView2_SelectedIndexChanged" OnRowDataBound="GridView2_RowDataBound" CellPadding="4" ForeColor="#333333" GridLines="None">
    <Columns>
        <asp:BoundField ItemStyle-Width="150px" DataField="partName" HeaderText="Parts Name" />
    </Columns>
</asp:GridView>

public void getlist()
{
    DataTable dt = new DataTable();
    DataSet ds = new DataSet();
    SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connString"].ConnectionString);
    SqlCommand cmd = new SqlCommand("select partName from parts", conn);
    conn.Open();
    //SqlDataAdapter da = new SqlDataAdapter(cmd);
    SqlDataReader dr = cmd.ExecuteReader();
    GridView2.DataSource = dr;
    GridView2.DataBind();
    conn.Close();
}

The above code is grdview1

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2">
    <Columns>
        <asp:BoundField DataField="[Part number]" HeaderText="Contact Name" ItemStyle-Width="150px" />
        <asp:BoundField DataField="Image" HeaderText="Contact Name" ItemStyle-Width="150px" />
        <asp:BoundField DataField="[Stock Code]" HeaderText="Contact Name" ItemStyle-Width="150px" />
        <asp:BoundField DataField="Nomenclature" HeaderText="Contact Name" ItemStyle-Width="150px" />
        <asp:BoundField DataField="quantity" HeaderText="Contact Name" ItemStyle-Width="150px" />
        <asp:BoundField DataField="[Eff Code]" HeaderText="Contact Name" ItemStyle-Width="150px" />
        <asp:BoundField DataField="[Vendor Code]" HeaderText="Contact Name" ItemStyle-Width="150px" />
        <asp:BoundField DataField="partName" HeaderText="Contact Name" ItemStyle-Width="150px" />--%>
    </Columns>
</asp:GridView>

DataSet ds = new DataSet();
string select = GridView2.SelectedRow.Cells[0].Text;
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connString"].ConnectionString);
SqlCommand cmd = new SqlCommand("select * from Catalouge ca inner join parts pa on ca.partName=pa.PartName where pa.[PartName]='"+select+"'",conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
//da.Fill(ds);
//conn.Open();
//SqlDataReader dr = cmd.ExecuteReader();
//GridView1.DataSource = dr;
GridView1.DataBind();
// conn.Close();