关于checkboxlist 取多值的示例代码.

 for (int i = 0; i < CheckBoxList1.Items.Count; i++)
        {

            if (CheckBoxList1.Items[i].Selected)
            {

        SQLString = "insert into Link (Link_Name,Link_URL,Link_LOGO,Link_Desc,ArticleClassTable)values";
        SQLString += "(@Link_Name,@Link_URL,@uploadFile,@Link_Desc,@ArticleClassTable)";
        SqlConnection MyConn = new SqlConnection(ODBCString);
        MyConn.Open();
        SqlCommand InsertCMD = new SqlCommand(SQLString, MyConn);
        InsertCMD.Parameters.Add(new SqlParameter("@Link_Name", SqlDbType.NVarChar));
        InsertCMD.Parameters["@Link_Name"].Value = this.Link_Name.Text.ToString().Trim();
        InsertCMD.Parameters.Add(new SqlParameter("@Link_URL", SqlDbType.NText));
        InsertCMD.Parameters["@Link_URL"].Value = this.Link_URL.Text.ToString().Trim();
        InsertCMD.Parameters.Add(new SqlParameter("@uploadFile", SqlDbType.NVarChar));
        InsertCMD.Parameters["@uploadFile"].Value = "./Uploads/" + uploadFile.PostedFile.FileName.Substring(uploadFile.PostedFile.FileName.LastIndexOf('\\') + 1);
        InsertCMD.Parameters.Add(new SqlParameter("@Link_Desc", SqlDbType.NVarChar));
        InsertCMD.Parameters["@Link_Desc"].Value = this.Link_Desc.Text.ToString().Trim();
        InsertCMD.Parameters.Add(new SqlParameter("@ArticleClassTable", SqlDbType.NVarChar));
        InsertCMD.Parameters["@ArticleClassTable"].Value = CheckBoxList1.Items[i].Value.ToString().Trim();
        InsertCMD.ExecuteNonQuery();
        InsertCMD.Cancel();
        MyConn.Close();                
       /* Response.Write(CheckBoxList1.Items[i].Value.ToString().Trim());*/
            }

        }

posted on 2006-12-16 11:37  sos@nj  阅读(413)  评论(0)    收藏  举报

导航