Binding Data to a CheckedListBox

this is my tried to display the data in checkedlistbox from database(SQL Server 2005 enterprise)
look this code

public void Privileges()
 {
    this.mcode.query = "select Pri_num,Pri_name from Privileges";
    d_adapter = new SqlDataAdapter(query,connect);
    d_set = new DataSet();
    d_adapter.Fill(d_set,query);
    for (int i = 0; i< this.mcode.d_set.Tables[0].Rows.Count; i++)
    {
     this.u_privleges_chListBox.Items.Add(this.mcode.d_set.Tables[this.mcode.query].Rows[i][1].ToString());
    }
 }

but i don't know how to make the value of the items in checkedlistbox is the privileges number (Pri_num)and i would like to save the checked(enable) for the user in the database by its value (Pri_num) in User_privileges

thank you for your cooperation

You have only retrieved the list of privileges, but not their assignment to a specific user.

You will need to load both the list of privileges and user_privileges (filtered by your current user). If this is a new set of permissions, you need to store the id of the privileges and not just the text.

Please check out the sample application I linked to. The information you are looking for is already there.

Cheers.

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 />