?using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
/// <summary>
/// ASP.NET2.0,ASP,MSSQL2005,MSSQL2005,PHP,MYSQL空間購買
/// CN域名注冊一年只要30元,六線主機租用讓你網速無限 聯系QQ:59716094 http://www.ebiz8.com
/// http://www.xiejie.cn
/// </summary>

public partial class Default5 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        GridView1.Columns[2].Visible = false;
        GridView1.Columns[3].Visible = true;
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        for (int i = 0; i < GridView1.Rows.Count;i++ );
        int id = Convert.ToInt32(GridView1.Rows[i].Cells[1].Text);
        string job = ((TextBox)GridView1.Rows[i].Cells[3].FindControl("TextBox1")).Text;
        OleDbConnection con=new OleDbConnection(ConfigurationManager.ConnectionStrings["test"].ConnectionString);
        con.Open();
        OleDbCommand cmd=new OleDbCommand("update flash set fenlei2='"+job+"'where ID="+id+" ",con);
        cmd.ExecuteNonQuery();
        GridView1.Columns[3].Visible=false;
        GridView1.Columns[2].Visible=true;

            
    }
}