利用Repeater控件顯示主－從關(guān)系數(shù)據(jù)表

2024-07-21 02:24:06

字體：大中小

供稿：網(wǎng)友

nestedrepeater.aspx

<%@ import namespace="system.data" %><%@ page language="c#" codebehind="nestedrepeater.aspx.cs" autoeventwireup="false" inherits="emeng.nestedrepeater" %><html><body><form runat="server"> <itemtemplate> <b> <%# databinder.eval(container.dataitem,"au_id") %> </b> <br> <itemtemplate> <%# databinder.eval(container.dataitem, "[/"title_id/"]")%> <br> </itemtemplate> :repeater> </itemtemplate>:repeater></form></body></html>

nestedrepeater.aspx.cs

using system;using system.data;using system.data.sqlclient;using system.web;using system.web.sessionstate;using system.web.ui;using system.web.ui.webcontrols;namespace emeng{/// <summary>/// nestedrepeater 的摘要說(shuō)明。/// 本文介紹如何利用repeater控件顯示主－從關(guān)系的表格/// 原文參見(jiàn)：/// http://support.microsoft.com/default.aspx?scid=kb;en-us;306154/// </summary>public class nestedrepeater : system.web.ui.page{protected system.web.ui.webcontrols.repeater parentrepeater;public void page_load(object sender, eventargs e){ // 為authors表創(chuàng)建 connection 和 dataadapter string cnnstring = @"server=(local)/netsdk;database=pubs; integrated security=sspi;"; sqlconnection cnn = new sqlconnection(cnnstring); sqldataadapter cmd1 = new sqldataadapter("select * from authors",cnn); //創(chuàng)建填充 dataset. dataset ds = new dataset(); cmd1.fill(ds,"authors"); // 為titles表創(chuàng)建 dataadapter sqldataadapter cmd2 = new sqldataadapter("select * from titleauthor",cnn); cmd2.fill(ds,"titles"); // 創(chuàng)建 authors 表和 titles 表之間的關(guān)系. ds.relations.add("myrelation", ds.tables["authors"].columns["au_id"], ds.tables["titles"].columns["au_id"]); // 綁定authors到父repeater parentrepeater.datasource = ds.tables["authors"]; page.databind(); cnn.close(); cnn.dispose();}private void page_init(object sender, eventargs e){ initializecomponent();}private void initializecomponent(){ this.load += new system.eventhandler(this.page_load);}public nestedrepeater(){ page.init += new system.eventhandler(page_init);}}}

上一篇：DataGrid控件使用技巧

下一篇：開(kāi)發(fā)手記（九）——在文件菜單中記錄最近使用過(guò)的文件