日期:2014-05-17 浏览次数:21691 次
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
fillGridView();
}
}
// 填充GridView
protected void fillGridView()
{
DataSet ds = new DataSet();
ds = GetData();
GridView1.DataSource = ds;
GridView1.DataKeyNames = new string[]{"id"};
GridView1.DataBind();
getRefSet(ds);
}
// 分页的相关参数设置
protected void getRefSet(DataSet ds)
{
lblCurrentIndex.Text = "第 " + (GridView1.PageIndex + 1).ToString() + " 页";
lblPageCount.Text = "共 " + GridView1.PageCount.ToString() + " 页";
lblRecordCount.Text = "总共 " + ds.Tables[0].Rows.Count.ToString() + " 条";
if (ds.Tables[0].Rows.Count == 0)
{
lnkbtnFirst.Visible = false;
lnkbtnPre.Visible = false;
lnkbtnNext.Visible = false;
lnkbtnLast.Visible = false;
lblCurrentIndex.Visible = false;
lblPageCount.Visible = false;
lblRecordCount.Visible = false;
}
else if (GridView1.PageCount == 1)
{
lnkbtnFirst.Visible = false;
lnkbtnPre.Visible = false;
lnkbtnNext.Visible = false;
lnkbtnLast.Visible = false;
}
// 设置LinkButton此时对应的参数
lnkbtnFirst.CommandArgument = "1";
lnkbtnPre.CommandArgument = (GridView1.PageIndex == 0 ? "1" : GridView1.PageIndex.ToString());
lnkbtnNext.CommandArgument = (GridView1.PageCount == 1 ? GridView1.PageCount.ToString() : (GridView1.PageIndex + 2).ToString());
lnkbtnLast.CommandArgument = GridView1.PageCount.ToString();
}
// 跳转到指定页面,页面参数由txtJumpPage获取
protected void lnkbtnJumpPage_Click(object sender, EventArgs e)
{
GridView1.PageIndex = int.Parse(txtJumpPage.Text) - 1;
lblCurrentIndex.Text = "第 " + (GridView1.PageIndex + 1).ToString() + " 页";
fillGridView();
GridView1.DataBind();
}
// 首页,上一页,下一页,尾页公用的点击程序
protected void PagerButtonClick(object sender, EventArgs e)
{
GridView1.PageIndex = Convert.ToInt32(((LinkButton)sender).CommandArgument) - 1;
fillGridView();
GridView1.DataBind();
}
// 转换SQL查询结果为DataSet
private DataSet GetData()
{
OracleConnection conn = new OracleConnection("Data Source=wgyx;user=wgyx;password=wgyx;");
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
String strSql = "select id,fuid,the from sys_organ";
cmd.CommandText = strSql;
cmd.CommandType = CommandType.Text;
DataSet ds = new DataSet();
try
{
conn.Open();
OracleDataAdapter ad = new OracleDataAdapter();
ad.SelectCommand = cmd;
ad.Fill(ds);
}
catch (Exception ex)
{