如何在.net中单击事件时在gridview中显示数据

这里是cs:

protected void Page_Load(object sender, EventArgs e)
        {
            SqlConnection con = Connection.DBconnection();
            SqlCommand com = new SqlCommand("sp_logdetails", con);
            com.CommandType = CommandType.StoredProcedure;
        }

aspx:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataKeyNames="Book_id" EnablePersistedSelection="True" BackColor="White"  Height="240px" 
        Width="755px" BorderColor="Red" BorderWidth="2px">
        <Columns>
            <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" 
                ReadOnly="True" SortExpression="Book_id" >
            <ControlStyle BorderColor="Red" />
            </asp:BoundField>
            <asp:BoundField DataField="bookid" HeaderText="bookid" SortExpression="bookid" />
            <asp:BoundField DataField="studentid" HeaderText="studentid" SortExpression="studentid" />
            <asp:BoundField DataField="date" HeaderText="date" SortExpression="date" />
            <asp:BoundField DataField="returndate" HeaderText="returndate" SortExpression="returndate" />
             <asp:BoundField DataField="returnstatus" HeaderText="returnstatus" SortExpression="returnstatus" />
            </Columns>
            </asp:GridView>

这是我执行的查询的屏幕截图

我是.net的新手，有人能指导我通过调用storedprocesse在gridview中显示数据吗。

谢谢，

SqlConnection con = Connection.DBconnection();
SqlCommand com = new SqlCommand("sp_logdetails", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@bookid",1);
SqlDataAdapter adp = new SqlDataAdapter(com);
DataSet ds = new DataSet();
adp.Fill(ds);
GridView1.DataSource=ds.Tables[0];
GridView1.DataBind();