动态设定GRIDVIEW列的值

  private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
  {
   if(e.Item.ItemType != ListItemType.Header&&e.Item.ItemType!=ListItemType.Footer)
   {
    string sql = "select * from EF000A where EF000A02 = '"+e.Item.Cells[0].Text+"' and EF000A03 = '"+e.Item.Cells[1].Text+"' and EF000A04 = '5' ";
    string state = MySqlBase.GetVarFromSql(sql,"EF000A014");
    if(state == "1")
     e.Item.Cells[9].Text = "同意";
    if(state =="2")
     e.Item.Cells[9].Text = "不同意";
    if(state =="3")
     e.Item.Cells[9].Text = "抽單";
   }
  }