GridView传多个值并同时添加多条记录

C# code

  
  

   
   
   
   
  
   
   string
   
    PKname 
   
   =
   
    
   
   ""
   
   ; 
  
   
   foreach
   
    (GridViewRow row 
   
   in
   
    
   
   this
   
   .GridView1.Rows)
       {
           CheckBox cbox 
   
   =
   
    (CheckBox)row.FindControl(
   
   "
   
   chkItem
   
   "
   
   );
           
   
   if
   
    (cbox.Checked)
           {
              PKname 
   
   =
   
    
   
   this
   
   .GridView1.DataKeys[row.RowIndex].Value.ToString().Trim();
            }

              Response.Redirect(
   
   "
   
   ME_Info_RecordAdd.aspx?MI_AssetSerial=
   
   "
   
    
   
   +
   
    PKname);
              Response.Write(PKname);
        }

  
  

我想获取GridView中checkbox的多个值，以上是我的代码，我想把获取的多个PKname（编号）值传递到另一个页面（这个页面有个Hidden1）

以下就是另一个页面的添加代码（可是这段代码只能添加一条记录，我想把上面传递过来的多个编号，都添加同样的记录）

C# code

   
   

    
    
    
    
 
    
    this
    
    .Hidden1.Value 
    
    =
    
     Request[
    
    "
    
    MI_AssetSerial
    
    "
    
    ];  
            
    
    string
    
     add_sql 
    
    =
    
     
    
    "
    
    insert into ME_UseInfo(ME_Info_MI_AssetSerial,MU_StartDate,MU_UseDept,MU_User)
    
    "
    
     
    
    +
    
    
                            
    
    "
    
     values(@MI_AssetSerial,@MU_StartDate,@MU_UseDept,@MU_User)
    
    "
    
    ;
            conn 
    
    =
    
     
    
    new
    
     SqlConnection(ConfigurationManager.ConnectionStrings[
    
    "
    
    ConnectionString
    
    "
    
    ].ToString());
            conn.Open();
            cmd 
    
    =
    
     
    
    new
    
     SqlCommand(add_sql, conn);

            cmd.Parameters.Add(
    
    "
    
    @MI_AssetSerial
    
    "
    
    , SqlDbType.NVarChar, 
    
    50
    
    ).Value 
    
    =
    
     
    
    this
    
    .Hidden1.Value;
            cmd.Parameters.Add(
    
    "
    
    @MU_StartDate
    
    "
    
    , SqlDbType.NVarChar, 
    
    10
    
    ).Value 
    
    =
    
     
    
    this
    
    .txtbuydate.Value;
            cmd.Parameters.Add(
    
    "
    
    @MU_UseDept
    
    "
    
    , SqlDbType.NVarChar, 
    
    50
    
    ).Value 
    
    =
    
     
    
    this
    
    .ddlMU_UseDept.SelectedItem.Text;
            cmd.Parameters.Add(
    
    "
    
    @MU_User
    
    "
    
    , SqlDbType.NVarChar, 
    
    10
    
    ).Value 
    
    =
    
     
    
    this
    
    .txtMU_User.Text;

            cmd.ExecuteNonQuery();