i did this code but when i executed and marked one item or more than one items it gave me this message "Conversion failed when converting the varchar '1' to data type int"
<br />
private void u_done_but_Click(object sender, EventArgs e)<br />
{<br />
string mycmd = "insert into users (id, u_name, pass) values ('" + txtUserID.Text + "', '" + txtUsername.Text + "', '" + @txtPass.Text + "')"; <br />
SqlConnection connect = new SqlConnection(conString); <br />
connect.Open(); <br />
SqlCommand cmd = new SqlCommand(mycmd, connect); <br />
cmd.ExecuteNonQuery(); <br />
foreach (DataRowView chk in checkedListBox1.CheckedItems)<br />
{<br />
s += string.Format("{0}\n", chk[this.u_privleges_chListBox.ValueMember]);<br />
mycmd = "insert into Users_Privileges (id, pri_num) values ('" + txtUserID.Text+"','"+ s +"')";<br />
cmd = new SqlCommand(mycmd, connect);<br />
cmd.ExecuteNonQuery();<br />
}<br />
connect.Close(); <br />
}<br />
this code to display data in checkedlistbox
<br />
public void Privileges()<br />
{<br />
this.mcode.query ="select * from Privileges";<br />
this.mcode.view();<br />
this.u_privleges_chListBox.DataSource = this.mcode.d_set.Tables[this.mcode.query].DefaultView;<br />
this.u_privleges_chListBox.DisplayMember = "Pri_name";<br />
this.u_privleges_chListBox.ValueMember = "Pri_num";<br />
}<br />