How to make multiple checkbox add to database

Question

I need to add more one selected item from checkbox to database but when I select more one I could not for one Item it works fine 

 this the code

 

please help

thanks  

cmd.CommandText = "If Not Exists(select * from dbo.ModuleRelation where UId=@UId and MId=@MId) Begin insert into dbo.ModuleRelation (UId, MId, MName) values(@UId, @MId, @MName) End";
               cmd.Connection = conn;
               foreach (ListItem item in chkModules.Items)
                   if (item.Selected == true)
                   {
                       conn.Open();
                       cmd.Parameters.Clear();
                       cmd.Parameters.AddWithValue("@UId", DropDownList1.SelectedItem.ToString());
                       cmd.Parameters.AddWithValue("@MId", item.Value.ToString());
                       cmd.Parameters.AddWithValue("@MName", item.Text.ToString());
                       chkModules.Visible = false;
                       cmd.ExecuteNonQuery();

Answer 1

Hi Joma,

Are you getting any errors? This code is working fine with me. Is there any other code inside if block, which is not pasted above?

Answer 2

Hi,

Have you tried debugging your code? Is for loop working multiple times when 2 items are selected?

Answer 3

thanks

I did not get error but when I click on add button (insert to database selected items) not working. However, when I select one item it works fine.

Answer 4

Yes

Answer 5

Hi,

Are you using Checkboxlist?