我在datalist中放置了一个datagrid,请问如何设置datagrid的数据源? 你是想根据DataList里行数据来设置DataGrid的值呢还是单独设置.你可以在后台程序中定义一个public方法返回一个数据集或一个表DataSource='<# 方法名 #>' 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我在datalist中放置了一个datagrid~~~~~~~~~~~~~~~~~~~~~~~~你怎么放进去的? <asp:DataGrid DataSource='<# GetDate(参数,可能是由DataList传递过来的)#>' <%@ Page Language="vb" Debug="true" %><%@ Import Namespace="System.Data" %><%@ Import Namespace="System.Data.OleDb" %><script language="VB" runat="server">dim MyConnection as OleDbConnectiondim cmdSelect as OleDbCommanddim dtrReader as OleDbDataReaderSub 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 ifEnd 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> 求一个图片格式的正则表达式!谢谢帮忙!! 运行报错! 如何获取现在的日期(年月日) 怎样在公告栏中显示最新的公告?(急) DataList控件 RegularExpressionValidator验证能否以弹出窗口显示那? 文件的读取权限 JavaScript传值的问题(动态生成控件未知ID如何获得window.retrun的值?) 系统中 用户权限该怎么设计 比如我只能查询但不删除 欢迎大家讨论?ASP.NET中邮件正文的图文如何混排??? 关于导出Excel的问题 生成Excel文件时出现的怪事
~~~~~~~~~~~~~~~~~~~~~~~~
你怎么放进去的?
<%@ 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>