public void LeaveWordfillgv() //用户自定义的方法
{
string SqlStr = "select * from tb_LeaveWord order by lTime desc";
SqlConnection con = new SqlConnection(EP.GetConStr());
con.Open(); //打开数据库连接
SqlDataAdapter sda = new SqlDataAdapter(SqlStr, con);
DataSet ds = new DataSet(); //声明一个DataSet的对象,并将该对象ds实例化
sda.Fill(ds, "tb_LeaveWord"); //将tb_LeaveWord填充到数据库中
this.GvLeaveWord.DataSource = ds;
this.GvLeaveWord.DataBind(); //将数据绑定到GridView控件中
for (int i = 0; i <= this.GvLeaveWord.Rows.Count - 1; i++)
{
DataRowView mydrv; //声明一个DataRowView的对象
string gintro;
if (this.GvLeaveWord.PageIndex == 0)
{
EP.GetConStr();
mydrv = ds.Tables["tb_LeaveWord"].DefaultView[i];
gintro = Convert.ToString(mydrv["Title"]);
this.GvLeaveWord.Rows[i].Cells[1].Text = ep.SubStr(gintro, 10);
}
}
con.Close();
}
public void GongGaofillgv() //用户自定义的方法
{
string SqlStr = "select * from tb_GongGao order by GTime desc";
SqlConnection con = new SqlConnection(EP.GetConStr());
con.Open(); //打开数据库连接
SqlDataAdapter sda = new SqlDataAdapter(SqlStr, con);
DataSet ds = new DataSet(); //声明一个DataSet的对象,并将该对象ds实例化
sda.Fill(ds, "tb_GongGao"); //将tb_GongGao填充到数据库中
this.GvGongGao.DataSource = ds;
this.GvGongGao.DataBind(); //将数据绑定到GridView控件中
for (int i = 0; i <= this.GvGongGao.Rows.Count - 1; i++)
{
DataRowView mydrv; //声明一个DataRowView的对象
string gintro; //声明一个字符串变量
if (this.GvGongGao.PageIndex == 0)
{
EP.GetConStr();//调用EP类中的GetConStr()方法
mydrv = ds.Tables["tb_GongGao"].DefaultView[i];
gintro = Convert.ToString(mydrv["content"]);
this.GvGongGao.Rows[i].Cells[1].Text = ep.SubStr(gintro, 10);
}
}
con.Close();//关闭数据库链接
}
