<ASP:DataGrid id="MyDataGrid" runat="server"> <Columns>
<asp:HyperLinkColumn
DataNavigateUrlField="au_id"
DataNavigateUrlFormatString="datagrid13_details.aspx?id={0}"
Text="Get Details"
/>
</Columns> </ASP:DataGrid>
<asp:HyperLinkColumn
DataNavigateUrlField="au_id"
DataNavigateUrlFormatString="datagrid13_details.aspx?id={0}"
Text="Get Details"
/>
</Columns> </ASP:DataGrid>
<%@ Import Namespace="System.Data.SqlClient" %><html><script language="C#" runat="server"> protected void Page_Load(Object Src, EventArgs E )
{
SqlConnection myConnection = new SqlConnection("server=(local)\\NetSDK;database=pubs;Integrated Security=SSPI"); SqlDataAdapter myCommand = new SqlDataAdapter("select * from Authors", myConnection); DataSet ds = new DataSet();
myCommand.Fill(ds, "Authors"); MyDataGrid.DataSource=ds.Tables["Authors"].DefaultView;
MyDataGrid.DataBind();
}</script><body style="font: 10pt verdana"> <form runat="server"> <h3><font face="Verdana">Working with Master-Detail Relationships</font></h3> <span id="Message" EnableViewState="false" style="font: arial 11pt;" runat="server"/><p> <ASP:DataGrid id="MyDataGrid" runat="server"
Width="800"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
DataKeyField="au_id"
> <Columns>
<asp:HyperLinkColumn
DataNavigateUrlField="au_id"
DataNavigateUrlFormatString="datagrid13_details.aspx?id={0}"
Text="Get Details"
/>
</Columns> </ASP:DataGrid> </form></body>
</html>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %><html><script language="C#" runat="server"> SqlConnection myConnection; protected void Page_Load(Object Src, EventArgs E )
{
myConnection = new SqlConnection("server=(local)\\NetSDK;database=pubs;Integrated Security=SSPI"); String selectCmd = "select t.title_id, t.type, t.pub_id, t.price "
+ "from titles t, titleauthor ta, authors a "
+ "where ta.au_id=@Id AND ta.title_id=t.title_id AND ta.au_id = a.au_id"; SqlDataAdapter myCommand = new SqlDataAdapter(selectCmd, myConnection); myCommand.SelectCommand.Parameters.Add(new SqlParameter("@Id", SqlDbType.NVarChar, 11));
myCommand.SelectCommand.Parameters["@Id"].Value = Request.QueryString["id"]; DataSet ds = new DataSet();
try {
myCommand.Fill(ds, "Titles");
MyDataGrid.DataSource=ds.Tables["Titles"].DefaultView;
MyDataGrid.DataBind();
} catch (Exception) {}
}</script><body style="font: 10pt verdana"> <form runat="server"> <h3><font face="Verdana">Working with Master-Detail Relationships</font></h3> <h4><font face="Verdana">Details for Author </font><%=Request.QueryString["id"]%></h4> <ASP:DataGrid id="MyDataGrid" runat="server"
Width="800"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
/> </form></body>
</html>