我做的效果如下:
ASPX页面就一个:<%=table%>
aspx.cs页面代码:
-----------------------------------------------------
#region 切换图
public string table = "", id="";
private void BindQieHuanTu()
{
con = new SqlConnection(zglh.returnSqlstr());
cmd = con.CreateCommand();
cmd.CommandText = "select * from guanggao where gg_type='首页滚动图片' and gg_if='是' order by gg_sort asc,gg_time desc";
try
{
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
int i = 1;
while (dr.Read())
{
string pic = Convert.ToString(dr["gg_pic"]);
string gg_id = dr["gg_id"].ToString();
//string id = string.Empty;
string pic1 = "admin/guanggao/" + pic;
string pic2 = "<td width=\"278\" height=\"96\" valign=\"top\"><table width=\"274\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#FFFFFF\"><tr><td width=\"97\" align=\"center\" valign=\"middle\"><a href='" + dr["gg_id"] + "'><img src=\"" + pic1 + "\" width=\"70\" height=\"60\" border=0 /></a></td><td width=\"177\" align=\"left\" class=\"hg\">英国《每日电讯报》26日报道道<br />英国女子坦娅·迪克森堪称爱迪<br />克森堪称爱迪克森堪称爱迪克森<br />堪称爱迪克森堪...</td></tr></table></td>";
table += pic2;
if (i % 2 == 0)
{
table += "<td width=\"98\" align=\"center\" valign=\"top\"><table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tr><td height=\"65\"> </td></tr><tr><td><a href='ceshi1.aspx?id=" + id + "," + dr["gg_id"] + "'><img src=\"images/db.jpg\" width=\"97\" height=\"27\" border=0 /></a></td></tr></table></td></tr><tr>";
}
else
{
id = gg_id;
}
i++;
}
dr.Close();
con.Close();
}
catch
{
con.Close();
}
}
#endregion
---------------------------------------------------------------------------------------------
请问这种输出数据没有依靠控件,分页也不依靠控件的分页效果怎么做。发出效果代码,谢谢
ASPX页面就一个:<%=table%>
aspx.cs页面代码:
-----------------------------------------------------
#region 切换图
public string table = "", id="";
private void BindQieHuanTu()
{
con = new SqlConnection(zglh.returnSqlstr());
cmd = con.CreateCommand();
cmd.CommandText = "select * from guanggao where gg_type='首页滚动图片' and gg_if='是' order by gg_sort asc,gg_time desc";
try
{
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
int i = 1;
while (dr.Read())
{
string pic = Convert.ToString(dr["gg_pic"]);
string gg_id = dr["gg_id"].ToString();
//string id = string.Empty;
string pic1 = "admin/guanggao/" + pic;
string pic2 = "<td width=\"278\" height=\"96\" valign=\"top\"><table width=\"274\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#FFFFFF\"><tr><td width=\"97\" align=\"center\" valign=\"middle\"><a href='" + dr["gg_id"] + "'><img src=\"" + pic1 + "\" width=\"70\" height=\"60\" border=0 /></a></td><td width=\"177\" align=\"left\" class=\"hg\">英国《每日电讯报》26日报道道<br />英国女子坦娅·迪克森堪称爱迪<br />克森堪称爱迪克森堪称爱迪克森<br />堪称爱迪克森堪...</td></tr></table></td>";
table += pic2;
if (i % 2 == 0)
{
table += "<td width=\"98\" align=\"center\" valign=\"top\"><table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tr><td height=\"65\"> </td></tr><tr><td><a href='ceshi1.aspx?id=" + id + "," + dr["gg_id"] + "'><img src=\"images/db.jpg\" width=\"97\" height=\"27\" border=0 /></a></td></tr></table></td></tr><tr>";
}
else
{
id = gg_id;
}
i++;
}
dr.Close();
con.Close();
}
catch
{
con.Close();
}
}
#endregion
---------------------------------------------------------------------------------------------
请问这种输出数据没有依靠控件,分页也不依靠控件的分页效果怎么做。发出效果代码,谢谢
你好
能不能把你做的效果发出来学习学习
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.IO;namespace mjjy.member
{
/// <summary>
/// frmproduct 的摘要说明。
/// </summary>
public partial class frmproduct : System.Web.UI.Page
{
protected string categoryname, strbody, strpage;
private const int pagesize = 10; protected void Page_Load(object sender, System.EventArgs e)
{
categoryname = Request.QueryString["categoryname"];
DataTable dt = gettable();
int curpage = setpagestr( dt );
setbody( dt, curpage );
} private DataTable gettable()
{
string categorynum = Request.QueryString["categorynum"];
string sqlstr;
switch( categorynum )
{
case "1":
sqlstr = "SELECT * " +
"FROM Products " +
"WHERE CategoryID = " + Request.QueryString["categoryid"] +
" ORDER BY Hot DESC, ID";
return comm.GetTable1( sqlstr ); case "2":
sqlstr = "SELECT * " +
"FROM Products " +
"WHERE Attribute like '%" + categoryname + ",%' " +
"ORDER BY Hot DESC, ID";
return comm.GetTable1( sqlstr ); case "3":
sqlstr = "SELECT * " +
"FROM Products " +
"WHERE Brand = " + Request.QueryString["categoryid"] +
" ORDER BY Hot DESC, ID";
return comm.GetTable1( sqlstr ); case "4":
sqlstr = "SELECT * " +
"FROM PriceRange " +
"WHERE ID = " + Request.QueryString["categoryid"];
DataTable dt = comm.GetTable1( sqlstr ); sqlstr = string.Format( "SELECT * " +
"FROM Products " +
"WHERE UnitPrice >= {0} and UnitPrice <= {1} " +
"ORDER BY UnitPrice, ID",
dt.Rows[0]["min"],
dt.Rows[0]["max"]
); return comm.GetTable1( sqlstr ); case "5":
string str = Request.QueryString["categoryid"];
string strwhere = "";
if( str == "1" )
strwhere = "WHERE ((Hot/262144)-Int(Hot/262144))>=0.5"; //热销
else if( str == "2" )
strwhere = "WHERE ((Hot/131072)-Int(Hot/131072))>=0.5"; //推荐
sqlstr = "SELECT * " +
"FROM Products " +
strwhere +
" ORDER BY Hot DESC, ID";
return comm.GetTable1( sqlstr ); case "100":
sqlstr = string.Format( "SELECT * " +
"FROM Products " +
"WHERE (ProductName + ' ' + CStr(ID)) like '%{0}%' " +
"ORDER BY Hot DESC, ID",
categoryname
);
return comm.GetTable1( sqlstr );
} return null;
} private int setpagestr( DataTable dt )
{
if( dt == null )
return 0; int n = dt.Rows.Count;
int n2 = n;
if( n == 0 )
return 0; n = ( n + (pagesize - 1) ) / pagesize; int currentpage = Convert.ToInt32( pagenum.Value );
if( currentpage < 1 )
{
currentpage = 1;
pagenum.Value = "1";
}
else if( currentpage > n )
{
currentpage = n;
pagenum.Value = n.ToString();
} strpage += string.Format( "共{0}项 共{1}页 ", n2, n );
if( n > 14 )
{
if( currentpage != 1 )
strpage += "<a href='javascript:gotofirst()'>[首页]</a> <a href='javascript:gotopre()'>[上一页]</a> ";
int m1 = currentpage - 4;
int m2 = m1 + 8;
if( m1 < 1 )
{
m2 -= (m1 - 1);
m1 = 1;
}
else if( m2 > n )
{
m1 -= (m2 - n);
m2 = n;
}
for( int i = m1; i <= m2; i++ )
{
if( i == currentpage )
strpage += i + " ";
else
strpage += string.Format( "<a href='javascript:gotopage({0})'>[{0}]</a> ", i );
}
if( currentpage != n )
strpage += "<a href='javascript:gotonext()'>[下一页]</a> <a href='javascript:gotolast()'>[尾页]</a> "; }
else
{
for( int i = 1; i <= n; i++ )
{
if( i == currentpage )
strpage += i + " ";
else
strpage += string.Format( "<a href='javascript:gotopage({0})'>[{0}]</a> ", i );
}
} return currentpage;
} private void setbody( DataTable dt, int curpage )
{
if( dt == null )
return; int n = dt.Rows.Count;
if( n == 0 )
return; int m1 = (curpage - 1) * pagesize;
int m2 = m1 + pagesize;
for( int i = m1; i < m2; )
{
strbody += "<tr>"; for( int j = 0; j < 2; j++, i++ )
{
if( i >= n )
{
strbody += "<td><table border='0' cellSpacing='0' width='100%' bgcolor='#FAFAF5' height='136'><tr><td></td></tr></table></td>";
continue;
} DataRow row = dt.Rows[i];
string filepath2 = string.Format( "{0}\\productimgs\\m{1}.jpg",
Server.MapPath( ".." ),
row["ID"]
);
string filepath;
if( File.Exists( filepath2 ) )
{
filepath = string.Format( "../productimgs/m{0}.jpg",
row["ID"]
);
}
else
filepath = "../productimgs/zwtpm.jpg"; string strlink = string.Format( "javascript:window.showModalDialog('productdetail2.aspx?categoryid={0}', '', 'dialogWidth=838px;dialogHeight=498px;status=0')",
row["ID"]
); strbody += string.Format( "<td><table border='0' cellSpacing='' cellPadding='8' width='100%' bgcolor='#FAFAF5'><tr>" +
"<td width='120'><a href=\"{0}\" target='_parent'><img src='{1}' width='120' height='120'></td>" +
"<td align='left'>〖编号〗{2}<br>〖名称〗{3}<br>〖规格〗{4}<br>〖单价〗{5:0.00}<br>〖折扣〗{6}%<br>〖售价〗{7:0.00}<br>〖订购〗<img src='../images/shoppingbag.gif' border=0></td>" +
"</tr></table></td>",
strlink,
filepath,
row["ID"],
row["ProductName"],
row["Size"],
row["UnitPrice"],
row["Discount"],
Convert.ToDouble(row["UnitPrice"]) * Convert.ToDouble(row["Discount"]) / 100
);
} strbody += "</tr>";
}
} #region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{ }
#endregion
}
}