可用datalist嵌套datagrid或datalist
解决方案 »
- 有关电子商务平台安全性的问题!
- [求助]网页中怎么嵌入视频播放
- 请问高手们出现这种情况是怎么回事?
- 求教:想把数“20061225”使用datagrid中的dataformatstring,转为“2006年12月25日”
- 如何提高asp.net+access网站的初次访问速度!
- ◆◆◆◆◆ 如何注册一个Com◆◆◆◆◆
- 在网站的设置中使用浏览器的后退怎样不回到那个页面
- ???????ASP.NET 引入文件问题????
- 各位好心的大哥大姐救救我这可怜的小妹妹吧!还是关于建立视图的操作,我是新手,都快打击得没信心了!
- 好奇怪的问题啊!!!!
- 求日期数据格式表达式
- 用VB.NET编的注册页面对面 出错啦!
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %><script language="VB" runat="server">
dim MyConnection as OleDbConnection
dim cmdSelect as OleDbCommand
dim dtrReader as OleDbDataReader
Sub Page_load(sender as object,e as Eventargs)
MyConnection = New OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=c:\inetpub\wwwroot\nhonline\datagrid\kk.mdb")
if not IsPostBack() then
Mydatagrid_DataBind()
end if
End SubSub Mydatagrid_DataBind()
Dim MyCommand As OleDbDataAdapter = new OleDbDataAdapter("select * from [class]", MyConnection)
Dim DS As DataSet = new DataSet()
MyCommand.Fill(DS,"board")
BigClassList.DataSource=DS.Tables("board").DefaultView
BigClassList.DataBind()
End SubFunction SmallClass(BigClassID) as DataTable
dim SmallClassData as DataSet =new DataSet()
MyConnection.Open()
dim DataAdapter as OleDbDataAdapter = new OleDbDataAdapter("SELECT * FROM [board] WHERE class="& BigClassID &" ORDER BY boardid DESC",MyConnection)
DataAdapter.Fill(SmallClassData,"SmallClassData")
MyConnection.Close()
return SmallClassData.Tables("SmallClassData")
End Function</script>
<html>
<head>
<title>NHONLINE_BBS_INDEX</title>
<link rel="stylesheet" href="css.css" type="text/css">
</head>
<body>
<form Runat="server">
<asp:datagrid id="BigClassList"
runat="server"
AutoGenerateColumns="false"
ShowHeader="false"
ShowFooter="false"
>
<columns>
<asp:TemplateColumn>
<ItemTemplate>
<TABLE style="BORDER-COLLAPSE: collapse" borderColor="WHITE" BgColor="#e4eaf2" cellSpacing="0" cellPadding="0" width="400" align="center" border="1">
<TR>
<TD> <%#Container.DataItem("class")%></TD>
</TR>
</TABLE>
<!-- ---------------------------------------------------------- -->
<asp:datagrid id="SmallClassList"
runat="server"
AutoGenerateColumns="false"
DataSource='<%# SmallClass(Container.DataItem("id").ToString()) %>'
ShowHeader="false"
ShowFooter="false"
>
<columns>
<asp:TemplateColumn>
<ItemTemplate>
<TABLE style="BORDER-COLLAPSE: collapse" borderColor="WHITE" BgColor="#DBDBDB" cellSpacing="0" cellPadding="0" width="400" align="center" border="1">
<TR>
<TD width="30"><IMG SRC="pop.gif" WIDTH="29" HEIGHT="29" BORDER="0" ALT=""></TD>
<TD><%#Container.DataItem("boardtype")%></TD>
</TR>
</TABLE>
</ItemTemplate>
</asp:TemplateColumn>
</columns>
</asp:datagrid>
</ItemTemplate>
</asp:TemplateColumn>
</columns>
</asp:datagrid>
</form>
</body>
</html>
[email protected]