[Zend]
zend_extension_manager.optimizer=/usr/local/Zend/lib/Optimizer-3.3.3
zend_extension_manager.optimizer_ts=/usr/local/Zend/lib/Optimizer_TS-3.3.3
zend_optimizer.version=3.3.3
zend_extension=/usr/local/Zend/lib/ZendExtensionManager.so
zend_extension_ts=/usr/local/Zend/lib/ZendExtensionManager_TS.so

ln -s /usr/local/Zend/etc/php.ini /you_path/php.ini

./configure  –with-layout=GNU –with-config-file-scan-dir=/usr/local/etc/php –disable-all –enable-libxml –with-libxml-dir=/usr/local –with-libexpat-dir=/usr/local –enable-reflection –program-prefix= –enable-force-cgi-redirect –enable-discard-path –enable-fastcgi –with-regex=php –with-zend-vm=CALL –enable-zend-multibyte –disable-ipv6 –prefix=/usr/local –mandir=/usr/local/man –infodir=/usr/local/info/ –with-mysql –with-gd –enable-gd-native-ttf –enable-gd-jis-conv

<asp:GridView ID="TableGridView"  
      runat="server"  AutoGenerateColumns="False" >
   <Columns>
    <asp:TemplateField HeaderText="Name">
        <ItemTemplate>
           <asp:Label id="lblName" Runat="Server" 
           Text='<%# Eval("pub_name") %>'/>
        </ItemTemplate>
        <EditItemTemplate>
           <asp:TextBox id="tbName" Runat="Server" 
           Text='<%# Bind("pub_name") %>'/>
        </EditItemTemplate>
    </asp:TemplateField>
    ....   
 
  </Columns
</asp:GridView>

public class DynamicallyTemplatedGridViewHandler : ITemplate
{
    ListItemType ItemType;
    string FieldName;
    string InfoType;
 
    public DynamicallyTemplatedGridViewHandler(ListItemType Item_type,
    string field_name, string control_type);
    public void InstantiateIn(System.Web.UI.Control Container);
    private void OnDataBinding(object sender, EventArgs e);
}

public DynamicallyTemplatedGridViewHandler(ListItemType item_type, string field_name,
 string control_type)
{
  ItemType = item_type;
  FieldName = field_name;
  InfoType = info_type;
}

public void InstantiateIn(System.Web.UI.Control Container)
{
  switch (ItemType)
  {
    case ListItemType.Header:
      Literal header_ltrl = new Literal();
      header_ltrl.Text = "b>" + FieldName + "b>";
      Container.Controls.Add(header_ltrl);
      break;
    case ListItemType.Item:
      switch (InfoType)
      {
      case "Button":
        ImageButton edit_button = new ImageButton();
        edit_button.ID = "edit_button";
        edit_button.ImageUrl = "~/images/edit.gif";
        edit_button.CommandName = "Edit";
        edit_button.Click += new ImageClickEventHandler(edit_button_Click);
        edit_button.ToolTip = "Edit";
        Container.Controls.Add(edit_button);
/*Similarly, add button for delete just set its
 command to equal to "Delete." It is important to know when
 "insert" button is added, its CommandName is set to "Edit" like
 that of the "edi" button because we want the GridView to enter into
 Edit mode and this time we also want the text boxes for corresponding fields
 empty*/ 
ImageButton insert_button = new ImageButton();
insert_button.ID = "insert_button";
insert_button.ImageUrl = "~/images/insert.bmp";
insert_button.CommandName = "Edit";
insert_button.ToolTip = "Insert";
insert_button.Click += new ImageClickEventHandler(insert_button_Click);
Container.Controls.Add(insert_button);
default:
  Label field_lbl = new Label();
  field_lbl.ID = FieldName;
  field_lbl.Text = String.Empty;
  field_lbl.DataBinding += new EventHandler(OnDataBinding);
  Container.Controls.Add(field_lbl);
  break;
}
break;
case ListItemType.EditItem:
  if (InfoType == "Button")
  {
    ImageButton update_button = new ImageButton();
    update_button.ID = "update_button";
    update_button.CommandName = "Update";
    update_button.ImageUrl = "~/images/update.gif";
    update_button.ToolTip = "Update";
    update_button.OnClientClick =
      "return confirm('Are you sure to update the record?')";
    Container.Controls.Add(update_button);
 
// Similarly, add a button for Cancel
 
  }
  else
// if other key and non key fields then bind textboxes with texts
  {
    TextBox field_txtbox = new TextBox();
    field_txtbox.ID = FieldName;
    field_txtbox.Text = String.Empty;
// if to update then bind the textboxes with coressponding field texts
//otherwise for insert no need to bind it with text
 
    if ((int)new Page().Session["InsertFlag"] == 0)
      field_txtbox.DataBinding += new EventHandler(OnDataBinding);
    Container.Controls.Add(field_txtbox);
 
  }
  break;
}
}

if ((int)new Page().Session["InsertFlag"] == 0)
  field_txtbox.DataBinding += new EventHandler(OnDataBinding);

private void OnDataBinding(object sender, EventArgs e)
{
    object bound_value_obj = null;
    Control ctrl = (Control)sender;
    IDataItemContainer data_item_container = 
    (IDataItemContainer)ctrl.NamingContainer;
    bound_value_obj = DataBinder.Eval(data_item_container.DataItem, FieldName);
    switch (ItemType)
    {
       case ListItemType.Item:
         Label field_ltrl = (Label)sender;
         field_ltrl.Text = bound_value_obj.ToString();
       break;
       case ListItemType.EditItem:
         TextBox field_txtbox = (TextBox)sender;
         field_txtbox.Text = bound_value_obj.ToString();
       break;
    }
 }

<asp:GridView ID="TableGridView"  
      OnRowEditing ="TableGridView_RowEditing" 
      OnRowCancelingEdit="TableGridView_RowCancelingEdit" 
      OnRowUpdating="TableGridView_RowUpdating"
      OnRowDeleting="TableGridView_RowDeleting"
      runat="server"  AutoGenerateColumns="False" >
</asp:GridView>

void PopulateDataTable()
{
   Table = new DataTable();
   TableGridView.Columns.Clear();
   string ServerName = (string)Session["Server"];
   string UserName = (string)Session["UserName"];
   string Password = (string)Session["Password"];
   string DatabaseName = (string)Session["DatabaseSelected"];
   string TableName = (string)Session["TableSelected"];
   SqlConnection Connection = new System.Data.SqlClient.SqlConnection("
   Data Source=" + ServerName + ";
                 Initial Catalog=" + DatabaseName + ";
                 User ID=" + UserName + ";
                 Password=" + Password + ";
                 Connect Timeout=120");
   SqlDataAdapter adapter = new SqlDataAdapter("Select * from " + TableName,  
    Connection);
   try
   {
     adapter.Fill(Table);
   }
   catch (Exception ex)
   {
     msg_lbl.Text = ex.ToString();
   }
}

void CreateTemplatedGridView()
{
   //fill the table which is to be bound with the GridView
   PopulateDataTable();
   TemplateField BtnTmpField = new TemplateField();
   BtnTmpField.ItemTemplate =
     new DynamicallyTemplatedGridViewHandler(ListItemType.Item, "...", "Command");
   BtnTmpField.HeaderTemplate =
     new DynamicallyTemplatedGridViewHandler(ListItemType.Header, "...",   
    "Command");
   BtnTmpField.EditItemTemplate =
   new DynamicallyTemplatedGridViewHandler(ListItemType.EditItem, "...",  
   "Command");
   TableGridView.Columns.Add(BtnTmpField);
     ....

....
 for (int i = 0; i = new TemplateField();
     // create the header
  ItemTmpField.HeaderTemplate = 
  new DynamicallyTemplatedGridViewHandler(ListItemType.Header,
                                          Table.Columns[i].ColumnName,
                                          Table.Columns[i].DataType.Name);
   // create ItemTemplate
  ItemTmpField.ItemTemplate = 
  new DynamicallyTemplatedGridViewHandler(ListItemType.Item,
                                          Table.Columns[i].ColumnName,
                                          Table.Columns[i].DataType.Name);
   // create EditItemTemplate
  ItemTmpField.EditItemTemplate = 
  new DynamicallyTemplatedGridViewHandler(ListItemType.EditItem,
                                          Table.Columns[i].ColumnName,
                                          Table.Columns[i].DataType.Name);
   // add to the GridView
  TableGridView.Columns.Add(ItemTmpField);
 }            
 ....

  ....
 TableGridView.DataSource = Table;
 TableGridView.DataBind();
}

  public void TableGridView_RowEditing(object sender, GridViewEditEventArgs e)
    {
        TableGridView.EditIndex = e.NewEditIndex;
        TableGridView.DataBind();
        Session["SelecetdRowIndex"] = e.NewEditIndex;
    }

GridViewRow row = TableGridView.Rows[e.RowIndex];
for (int i = 0; i string field = ((TextBox)row.FindControl(Table.Columns[i].ColumnName)).Text;
  ParameterArray.Add(field);
         
}

....
string Query = "";
if ((int)Session["InsertFlag"] == 1)
    Query = GenerateInsertQuery();
else
    Query = GenerateUpdateQuery();
SqlCommand Command = new System.Data.SqlClient.SqlCommand(Query, Connection);
try
{
    Connection.Open();
    Command.ExecuteNonQuery();
    Session["InsertFlag"] = (int)Session["InsertFlag"] == 1 ? 0 : 1;
}
catch (SqlException se)
{
    msg_button.Visible = true;
    msg_lbl.Text = se.ToString();
}
TableGridView.EditIndex = -1;
CreateTemplatedGridView();    

public void TableGridView_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
    TableGridView.EditIndex = -1;
    TableGridView.DataBind();
    Session["SelecetdRowIndex"] = -1;
   
}

 ....
 string Query = GenerateDeleteQuery(e.RowIndex);
 SqlCommand Command = new System.Data.SqlClient.SqlCommand(Query, Connection);
 try
  { 
    if(Connection.State==ConnectionState.Closed)
         Connection.Open();
    Command.ExecuteNonQuery();
  }
  catch (SqlException se)
  {
    msg_button.Visible = true;
    msg_lbl.Text = se.ToString();
    Connection.Close();
  }
  CreateTemplatedGridView(); 
 

string query = "";
if (Table.Columns[0].DataType.Name == "String" || Table.Columns[0].DataType.Name == "DateTime")
   query = "Delete from " + TableName + " where " + Table.Columns[0].ColumnName +
   "='" + class=Bold>Table.Rows[index][0].ToString() + "'";