title: Problem with writing IDs to DB
body: <p>I have a dropdown with names of project managers and a checkboxlist with names of team members. What I want to do is write the IDs of selections made from the dropdown and checkboxlist to the DB. I am using the following code, but only IDs from the checkboxlist are stored in the table. What can I do to store the ID from the dropdown simultaneously? Thanks for your help.</p>
  
  <pre><code>for (int i = 0; i &lt; project_members.Items.Count; i++)
  {
  
              if (project_members.Items[i].Selected)
              {
  
  
                  SqlParameter[] param = new SqlParameter[1];
                  param[0] = new SqlParameter("@member_id", SqlDbType.Int);
                  param[0].Value = project_manager.SelectedValue;
                  param[0].Value = project_members.Items[i].Value;
  
  
                  for (int j = 0; j &lt; param.Length; j++)
                  {
                      cmd2.Parameters.Add(param[j]);
                  }
  
                  cmd2.CommandType = CommandType.Text;
                  cmd2.ExecuteNonQuery();
                  cmd2.Parameters.Clear();
  
              }
  }
  </code></pre>