前台
<table id ="table_RPT" width="505" border="1" align="center" cellpadding="3" cellspacing="0" bordercolordark="#FFEFEF" bordercolorlight="#191970">
<%=sHTML%>
</table>
后台.cs 文件
string sqlRPT="select s1,s2,s3,s4,s5,s6 from DCUSER.B2B_AUTO_SCHEDULE@DCPROD where REPORTID like '%" + rpt_id + "%'";
using (OracleConnection conn = new OracleConnection(DBLink.Link()))
{
conn.Open();
DataTable dt = DBLink.sqlquery(sqlRPT, conn);
if (dt.Rows.Count>0){
sHTML="<tr><td>报表类型</td><td colspan='6' align='center'>发送时间</td></tr>";
sHTML=sHTML+"<tr>";
foreach (DataColumn col in dt.Columns){
sHTML=sHTML+"<td>"+col.ColumnName.ToString()+"</td>";
}
sHTML=sHTML+"</tr>";
foreach (DataRow row in dt.Rows)
{
sHTML=sHTML+"<tr>";
foreach(object obj in row.ItemArray)
{
sHTML=sHTML+"<td>"+obj.ToString()+"</td>";
}
sHTML=sHTML+"</tr>";
}
}
else{
label.Text = "No results!";
return;
}
label.Text = "Searching Success!!! ";
label.ForeColor = System.Drawing.Color.DodgerBlue;
}