遍历listbox 及循环参数插入操作

服务器端Server:

foreach(ListItem li in x_orderlist.Items)
       {
        
       string _sql="update "+x_tbname.Text+" set ordercode=@ordercode where cid=@cid";
         SqlCommand   comm=new SqlCommand(_sql,myConnection);  
        
       SqlParameter  para_ordercode=new SqlParameter("@ordercode",SqlDbType.Int);
      para_ordercode.Value=x_orderlist.Items.IndexOf(li);//得当前元素的索引值
    
     comm.Parameters.Add(para_ordercode);
  
    SqlParameter   para2=new   SqlParameter("@cid",SqlDbType.UniqueIdentifier);
         para2.Value=new Guid(li.Value);
  comm.Parameters.Add(para2);
  comm.ExecuteNonQuery();
         
       }

 

 

客户端Client:

 function GetList() {

           
            var lstStaffs = form.x_orderlist;
            var strStaffs = "";
            for (var i = 0; i < lstStaffs.options.length; i++) {
                strStaffs += lstStaffs.options[i].value + "|";
            }
   
   form.x_list.value=strStaffs;
            //document.getElementById("divStaffs").innerHTML = strStaffs;
        }