GridView2

1、镶套（在GridView里镶套BulletedList）

     private   SqlDataReader read( string  id)
     {
        SqlConnection mycon = new SqlConnection(ConfigurationManager.ConnectionStrings["pubconn"].ToString());
        mycon.Open();
        SqlCommand cmd = new SqlCommand("select title from titles where pub_id='" + id + "'", mycon);
        return cmd.ExecuteReader(CommandBehavior.CloseConnection);
        
    }
     protected   void  GridView1_RowDataBound( object  sender, GridViewRowEventArgs e)
     {
        foreach (GridViewRow gvr in GridView1.Rows)
        {
            string id = gvr.Cells[0].Text;
            BulletedList bl = (BulletedList)gvr.Cells[2].FindControl("bl1");
            bl.DataSource = read(id);
            bl.DataTextField = "title";
            bl.DataBind();
        }
    }

重点： return  cmd.ExecuteReader(CommandBehavior.CloseConnection);  关闭连接
             
2、手工实现编辑、更新全部记录

  protected   void  Button1_Click( object  sender, EventArgs e)
     {
        GridView1.Columns[1].Visible = false;
        GridView1.Columns[2].Visible = true;
    }
     protected   void  Button2_Click( object  sender, EventArgs e)
     {
        for (int i = 0; i < GridView1.Rows.Count; i++)
        {
            string id = GridView1.Rows[i].Cells[0].Text;
            string name = ((TextBox)GridView1.Rows[i].Cells[2].FindControl("textbox1")).Text;
            SqlConnection mycon = new SqlConnection(ConfigurationManager.ConnectionStrings["mydbcon"].ToString());
            mycon.Open();
            SqlCommand cmd = new SqlCommand("update test set 姓名='" + name + "' where 学号='" + id + "'",mycon);
            cmd.ExecuteNonQuery();
        }
        GridView1.Columns[1].Visible = true;
        GridView1.Columns[2].Visible = false;

转载于:https://www.cnblogs.com/net123/archive/2008/03/04/1090655.html