Question

帮忙看一下为什么只能显示最后一项（C#）

int i;
//string FilePath = Path.Combine(Request.PhysicalApplicationPath, "App_Data/content.MDB");
string CSstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:/程序设计/ASP.NET(C#)/留言板/App_Data/content.mdb";
OleDbConnection MyCon = new OleDbConnection(CSstring);
string SQLstring = "Select * From content where Face='1'";
string[] strRow = new string[7];
try
{
MyCon.Open();
Response.Write("成功连接！");
}
catch (OleDbException E)
{
Response.Write(E.Message);
}
OleDbCommand MyCom = new OleDbCommand();
MyCom.Connection = MyCon;
MyCom.CommandType = CommandType.Text;
MyCom.CommandText = SQLstring;
OleDbDataAdapter MyDataAdapter = new OleDbDataAdapter();
MyDataAdapter.SelectCommand = MyCom;

DataSet MyDataSet = new DataSet();
MyDataAdapter.Fill(MyDataSet, "content");//填充数据集
for (i =0; i<MyDataSet.Tables["Content"].Rows.Count-1; i++) ;//遍历数据集
{
Response.Write("行数："+MyDataSet.Tables["content"].Rows.Count);
strRow[0] = MyDataSet.Tables["content"].Rows[i]["Index"].ToString();
strRow[1] = MyDataSet.Tables["content"].Rows[i]["Name"].ToString();
strRow[2] = MyDataSet.Tables["content"].Rows[i]["Email"].ToString();
strRow[3] = MyDataSet.Tables["content"].Rows[i]["Face"].ToString();
strRow[4] = MyDataSet.Tables["content"].Rows[i]["Content"].ToString();
strRow[5] = MyDataSet.Tables["content"].Rows[i]["userIP"].ToString();
strRow[6] = MyDataSet.Tables["content"].Rows[i]["Time"].ToString();
Response.Write("<hr/> 编号：" + strRow[0]);
Response.Write("<br /> 姓名：" + strRow[1] + "<br />Email：" +strRow[2] +
"<br />留言内容：" + strRow[4] + "<br /> IP：" + strRow[5] + "<br />留言时间：" +
strRow[6] + "<br />");
}
MyCon.Close();

Answer 1

System.Web.UI.WebControls.PagedDataSource pds = new PagedDataSource();
pds.DataSource = ds.Tables["content"].DefaultView;
pds.AllowPaging = true;
pds.PageSize = 2;
pds.CurrentPageIndex=curPage-1;

绑定下就OK!!

原因是DS没有分页功能，只能借助视图模式，才可以分页！！
我是新手，还没有一个月，呵呵，我看过这个关于他的实例

Answer 2

Response.Write 只有最后一个才有效，只能向客户端输出一次，不能累计

Answer 3

Response.Write只输出了一条记录！