Firstly, I have 2 tables with PK and FK relationship. They are
1. MemberReport
2. PoliceAccount
I also have 5 dropdownlist
1. ddllocation
2. ddlnumberofpolice
3. ddlpoliceID1
4. ddlpoliceID2
5. ddlpoliceID3
These 5 dropdownlist are all link to each other. For example, the user has to select the location before selecting the number of police. Before selecting the policeID(s), the user has to select the number of police. The ddlpolice will only appear based on
the number of police selected. In the 3 ddlpoliceID, i have inserted a default value called "police ID". So for example if the user selected 2 number of police from ddlnumberofpolice and selected two policeID from ddlpoliceID1&2, it will be successfully added
into the database like this
using (var connAdd = new SqlConnection("Data Source = localhost; Initial Catalog = MajorProject; Integrated Security= SSPI"))
{
...
Go to the complete details ...