关于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());*/
}
}
浙公网安备 33010602011771号