想在GridView里面根据状态代码来更改GridView的底色,页面该初始化的时候是可以看到效果的,可是当我点击分页的第二页的时候就显示不出效果了,貌似我把代码放错位置了,我放在了Page_Load里面,是不是应该放在Grid_ROwdatabind里面?哪些代码放过去?
protected void Page_Load(object sender, EventArgs e)
{
if (Session["userName"] != null) //判断管理员是否登录
{
if (!getSet()) //判断是否拥有权限
{
Response.Write("<script>alert('您没有此权限!');location='Default.aspx';</script>");
}
}
else
{
Response.Redirect("entry.aspx"); //返回到登录页面
}
if (!IsPostBack)
{
string sqlstr = "select * from calMainRecords";
SqlConnection con = GetConnection();
SqlDataAdapter sda = new SqlDataAdapter(sqlstr, con);
DataSet ds = new DataSet();
con.Open();
sda.Fill(ds, "Cal");
GridView1.DataSource = ds;
GridView1.DataBind();
for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
{
DataRowView mydrv = ds.Tables["Cal"].DefaultView[i];
string CalStatus = Convert.ToString(mydrv["Status"]);
DateTime dt = Convert.ToDateTime(mydrv["Cal_Date"]);//对Cal_Date这一列转换成长日期格式
GridView1.Rows[i].Cells[2].Text = dt.ToLongDateString();
if (CalStatus == "S")// 根据状态状态的代码去更改GridView底色
{
GridView1.Rows[i].Cells[4].BackColor = System.Drawing.Color.Red;
}
else if (CalStatus == "A")
{
GridView1.Rows[i].Cells[4].BackColor = System.Drawing.Color.Green;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["userName"] != null) //判断管理员是否登录
{
if (!getSet()) //判断是否拥有权限
{
Response.Write("<script>alert('您没有此权限!');location='Default.aspx';</script>");
}
}
else
{
Response.Redirect("entry.aspx"); //返回到登录页面
}
if (!IsPostBack)
{
string sqlstr = "select * from calMainRecords";
SqlConnection con = GetConnection();
SqlDataAdapter sda = new SqlDataAdapter(sqlstr, con);
DataSet ds = new DataSet();
con.Open();
sda.Fill(ds, "Cal");
GridView1.DataSource = ds;
GridView1.DataBind();
for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
{
DataRowView mydrv = ds.Tables["Cal"].DefaultView[i];
string CalStatus = Convert.ToString(mydrv["Status"]);
DateTime dt = Convert.ToDateTime(mydrv["Cal_Date"]);//对Cal_Date这一列转换成长日期格式
GridView1.Rows[i].Cells[2].Text = dt.ToLongDateString();
if (CalStatus == "S")// 根据状态状态的代码去更改GridView底色
{
GridView1.Rows[i].Cells[4].BackColor = System.Drawing.Color.Red;
}
else if (CalStatus == "A")
{
GridView1.Rows[i].Cells[4].BackColor = System.Drawing.Color.Green;
}
}
}
}