importdata3.aspx

支持多个ETSet数据集 支持7个子对象

<% @Page Language="C#" Debug="true" ResponseEncoding="gb2312" ASPCompat="true" EnableViewStateMac="false" validateRequest="false"%>
<% @Import Namespace="System" %>
<% @Import Namespace="System.IO" %>
<% @Import Namespace="System.Data" %>
<% @Import Namespace="System.Data.OleDb" %>
<% @Import Namespace="System.Collections" %>

<%
//连接数据库

//连接SQL Server 数据库的连接串
//string strConnString = "Provider=SQLOLEDB.1;User ID=sa;Password=123456;Initial Catalog=yhsgl;Data Source=localhost;Persist Security Info=True;";

//连接Oracle 数据库的连接串
//string strConnString = "Provider=SQLOLEDB.1;User ID=sa;Password=123456;Initial Catalog=yhsgl;Data Source=localhost;Persist Security Info=True;";

string strFilepath = Server.MapPath("db1.mdb");
string strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFilepath + ";";

OleDbConnection dbConn = new OleDbConnection(strConnString);
try
{
	dbConn.Open();
}
catch(Exception ex)
{
	Response.End();
}

//查询出ETSet数据集的数据
string strSQL = "select * from sales";
DataSet rsList = new DataSet();	
try
{
	OleDbDataAdapter adpList = new OleDbDataAdapter(strSQL,dbConn);					
	adpList.Fill(rsList, "111");
}
catch(Exception ex)
{
	Response.End();
}
if( rsList==null )
{
	Response.Write("数据集未空!");
	Response.End();
}


//查询出别名的数据
strSQL = "select top 1 * from AliasSet ";
DataSet rsAliasData = new DataSet();	
try
{
	OleDbDataAdapter adpList = new OleDbDataAdapter(strSQL,dbConn);					
	adpList.Fill(rsAliasData, "111");
}
catch(Exception ex)
{
	Response.End();
}
DataRow drRow = rsAliasData.Tables[0].Rows[0];
if( drRow==null ) Response.End();



%>

<?xml version="1.0" encoding="gb2312"?>
<EtCell>

<!-- 下面输出xxx.et报表模板中定义的别名数据 -->
<AliasData name='AliasData1'>
	<Name value='<%=drRow["Name"].ToString()%>' />
	<BillNO value='<%=drRow["BillNO"].ToString()%>' />
	<FromCompanyTaxNO value='<%=drRow["FromCompanyTaxNO"].ToString()%>' />
	<Tel value='<%=drRow["Tel"].ToString()%>' />
</AliasData>

<!-- 下面输出xxx.et报表模板中定义的ETSet数据集数据 -->
<RowData name='ETSet1'>
<%
foreach(DataRow dr in rsList.Tables[0].Rows ) 
{
	Response.Write("<Row>\r\n");
	Response.Write("	<GoodName><![CDATA[" + dr["GoodName"].ToString() + "]]></GoodName>\r\n");
	Response.Write("	<UnitName value='" + dr["UnitName"].ToString() + "' />\r\n");
	Response.Write("	<Num value='" + dr["Num"].ToString() + "' />\r\n");
	Response.Write("	<Price value='" + dr["Price"].ToString() + "' />\r\n");
	Response.Write("	<Money value='" + dr["Money"].ToString() + "' />\r\n");
	Response.Write("</Row>\r\n");
}
%>
</RowData>

</EtCell>