private
void
bind()
... {
string con = ConfigurationManager.AppSettings["AccessDataBase"] + Server.MapPath("App_Data/details.mdb");
OleDbConnection dbconnection = new OleDbConnection(con);
dbconnection.Open();
OleDbCommand cmd = new OleDbCommand("select * from news", dbconnection);
DataSet ds = new DataSet();
OleDbDataAdapter oda = new OleDbDataAdapter(cmd);
oda.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
//让在GridView中多余的汉字用""代替
for (int i = 0; i < =GridView1.Rows.Count-1; i++)
...{
DataRowView mydrv;
string gintro;
if (GridView1.PageIndex == 0)
...{ //这里吧DataSet的视图赋值给了DataRowView
//处理第一页的5个记录
mydrv = ds.Tables[0].DefaultView[i];
gintro = Convert.ToString(mydrv["content"]);
GridView1.Rows[i].Cells[2].Text = substr(gintro, 5);
}
mydrv = ds.Tables[0].DefaultView[i+5*(GridView1.PageIndex)];
gintro = Convert.ToString(mydrv["content"]);
GridView1.Rows[i].Cells[2].Text = substr(gintro, 5);
}
}
public string substr( string sstring, int nleng)
... {
if (sstring.Length <= nleng)
...{
return sstring;
}
string snewstr = sstring.Substring(0, nleng);
snewstr = snewstr + "";
return snewstr;
}
... {
string con = ConfigurationManager.AppSettings["AccessDataBase"] + Server.MapPath("App_Data/details.mdb");
OleDbConnection dbconnection = new OleDbConnection(con);
dbconnection.Open();
OleDbCommand cmd = new OleDbCommand("select * from news", dbconnection);
DataSet ds = new DataSet();
OleDbDataAdapter oda = new OleDbDataAdapter(cmd);
oda.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
//让在GridView中多余的汉字用""代替
for (int i = 0; i < =GridView1.Rows.Count-1; i++)
...{
DataRowView mydrv;
string gintro;
if (GridView1.PageIndex == 0)
...{ //这里吧DataSet的视图赋值给了DataRowView
//处理第一页的5个记录
mydrv = ds.Tables[0].DefaultView[i];
gintro = Convert.ToString(mydrv["content"]);
GridView1.Rows[i].Cells[2].Text = substr(gintro, 5);
}
mydrv = ds.Tables[0].DefaultView[i+5*(GridView1.PageIndex)];
gintro = Convert.ToString(mydrv["content"]);
GridView1.Rows[i].Cells[2].Text = substr(gintro, 5);
}
}
public string substr( string sstring, int nleng)
... {
if (sstring.Length <= nleng)
...{
return sstring;
}
string snewstr = sstring.Substring(0, nleng);
snewstr = snewstr + "";
return snewstr;
}