(望高手能帮忙看下)由于符号不匹配或数据溢出以外的其他原因,未能转换数据值。例如,数据在数据存储区
乌邦托 2008-07-14 12:47:06 private int rowNum=2;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
String strConn = ConfigurationSettings.AppSettings["DB"] + Server.MapPath("DB.mdb");
OleDbConnection cn = new OleDbConnection();
cn.ConnectionString = strConn;
cn.Open();
OleDbCommand cmd=new OleDbCommand("SELECT TOP 6 * FROM 产品信息表 ORDER BY id DESC ",cn);
int i=0;
OleDbDataReader sdr=cmd.ExecuteReader();
System.Web.UI.WebControls.TableRow tr=new TableRow();
while(sdr.Read())
{
i=i+1;
System.Web.UI.WebControls.TableCell tc=new TableCell();
newPattern npa=(newPattern)this.LoadControl("newPattern.ascx");
npa.cpID=sdr.GetString(0);
tc.Controls.Add(npa);//添加新品
tr.Controls.Add(tc);
if(i%this.rowNum==0)
{
this.Table1.Rows.Add(tr);
tr=new TableRow();
}
}
if(i%this.rowNum!=0)
{
this.Table1.Rows.Add(tr);
}
sdr.Close();
cn.Close();
}