DataGrid有模板列更新

  private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   string updateCmd="update Socut_BBS set";
   updateCmd+="Poster ='"+((TextBox)e.Item.Cells[1].FindControl("TextBox1")).Text+"'";

   updateCmd+=" where ID ="+DataGrid1.DataKeys[(int)e.Item.ItemIndex].ToString();
   oleDbCommand1.CommandText=updateCmd;
   oleDbCommand1.Connection.Open();
   oleDbCommand1.ExecuteNonQuery();
   oleDbCommand1.Connection.Close();
   oleDbDataAdapter1.Fill(myDataSet1);
   DataGrid1.EditItemIndex=-1;
   DataGrid1.DataBind();