DataList和DataGrid嵌套使用问题

[huiqi2001]

在一个DataList里嵌套一个DataGrid，数据库用的是ORACLE
编译是通过的，一浏览ASPX就提示：
编译错误
编译器错误信息: CS0118: “System.Data.DataRowView”表示“类”，此处应为“变量”

ASPX代码：
<form id="Form1" method="post" runat="server">
<asp:DataList ID="ParentDataList" Runat="server" RepeatColumns="3">
<ItemTemplate>
<table>
<tr>
<td colspan="2"><%#DataBinder.Eval(Container.DataItem,"cardTypeName")%></td>
</tr>
<tr>
<td><img src="<%#DataBinder.Eval(Container.DataItem,"cardtypeurl")%>"></td>
<td>
<asp:DataGrid id="SonDataGrid" runat="server" AutoGenerateColumns="False" BorderColor="#33FF33" DataKeyField="cardTypeID" DataSource='<%# Ctype(Container.DataItem,DataRowView).CreateChildView("CardTypeRelation") %>'>
<Columns>
<asp:BoundColumn DataField="cardsubtypename"></asp:BoundColumn>
<asp:BoundColumn DataField="totalVB"></asp:BoundColumn>
</Columns>
</asp:DataGrid>
</td>
</tr>
</table>
</ItemTemplate>
</asp:DataList>
</form>
CS代码：

public class CardTypeShow : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataList ParentDataList;
protected System.Data.DataSet objDs;
protected string listCout;

private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
listCout="10";
objDs=new DataSet();
GetDate();
ParentDataList.DataSource=objDs.Tables["cardname"].DefaultView;
ParentDataList.DataBind();
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}

/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.ParentDataList.ItemDataBound += new System.Web.UI.WebControls.DataListItemEventHandler(this.ParentDataList_ItemDataBound);
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion

private void GetDate()
{
DatabasePool datepool=new DatabasePool();

string sSql = "select * from ( select * from vbcardtype) where rownum<"+listCout;
OracleDataAdapter objAdapter=new OracleDataAdapter(sSql,datepool.Open());
objAdapter.Fill(objDs,"cardname");
sSql="select * from vbcardsubtype where cardtypeid in ";
sSql+=" (select * from ( select cardtypeid from vbcardtype) where rownum<"+listCout+")";
objAdapter.SelectCommand.CommandText=sSql;
objAdapter.Fill(objDs,"cardlist");
datepool.Close();
datepool.Dispose();
DataColumn Parent = objDs.Tables["cardname"].Columns["cardTypeID"];
DataColumn Child = objDs.Tables["cardlist"].Columns["cardTypeID"];
objDs.Relations.Add("CardTypeRelation",Parent,Child);
}
}
private void ParentDataList_ItemDataBound(object sender, System.Web.UI.WebControls.DataListItemEventArgs e)
{

}
///////////////////

那位大哥能告诉我是那里写的不对

[520NET]

LG

[huiqi2001]

UP

[penning]

在ASPX页面加上
<%@ Import namespace=" System.Data"%>

[penning]

另外<%# Ctype(Container.DataItem,DataRowView).CreateChildView("CardTypeRelation") %>'是VB的写法，改成(DataRowView).Container.DataItem.CreateChildView["CardTypeRelation"]

[penning]

错了
'<%# ((DataRowView)Container.DataItem).CreateChildView("CardTypeRelation") %>'

[shoutor]

可以动态给datagrid设置数据源，方法写在codebehind中（public），接受datalist传递的参数

[sukey00]

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace wt2004net
{
/// <summary>
/// datalist1 的摘要说明。
/// </summary>
public class datalist : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Repeater parentRepeater;
public datalist()
{
Page.Init += new System.EventHandler(Page_Init);
}
public void Page_Load(object sender, EventArgs e)
{
//Create the connection and DataAdapter for the Authors table.
SqlConnection cnn = new SqlConnection("server=(local);database=pubs; uid=sa;pwd=127509127509 ;");
SqlDataAdapter cmd1 = new SqlDataAdapter("select * from authors",cnn);

//Create and fill the DataSet.
DataSet ds = new DataSet();
cmd1.Fill(ds,"authors");

//Create a second DataAdapter for the Titles table.
SqlDataAdapter cmd2 = new SqlDataAdapter("select * from titleauthor",cnn);
cmd2.Fill(ds,"titles");

//Create the relation bewtween the Authors and Titles tables.
ds.Relations.Add("myrelation",
ds.Tables["authors"].Columns["au_id"],
ds.Tables["titles"].Columns["au_id"]);

//Bind the Authors table to the parent Repeater control, and call DataBind.
parentRepeater.DataSource = ds.Tables["authors"];
Page.DataBind();

//Close the connection.
cnn.Close();
}
private void Page_Init(object sender, EventArgs e)
{
InitializeComponent();
}
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}

}
}

[huiqi2001]

谢谢大家，

顺便再问一句，如果在ItemDataBound事件里对内嵌GRID进行绑定，效率是不是比这个要低一些？

我想如果是重新从数据库里取，肯定是慢的。

如果直接从DATASET里取子表对应数据，该怎么写呢？

[webdiyer]

http://www.dotnetjunkies.com/Tutorial/841522C9-FFBD-4C57-BD48-F62B55057FF3.dcik

或者用这个控件：

http://www.denisbauer.com/ASPNETControls/HierarGrid.aspx