Sqlds.InsertCommandType = SqlDataSourceCommandType.Text;
Sqlds.InsertCommand = "insert into Population(States,LGA,Males,Females,Bothsexes,Land size,Terrain,Remarks) values (@countryList,@statelist,@male,@fmale,@bsexes,@lan dsize,@terrain,@remarks)";
Sqlds.InsertParameters.Add("countryList",countryLi st.SelectedValue);
Sqlds.InsertParameters.Add("stateList", stateList.SelectedValue);
Sqlds.InsertParameters.Add("male", male.Text);
Sqlds.InsertParameters.Add("fmale", fmale.Text);
Sqlds.InsertParameters.Add("bsexes", bsexes.Text);
Sqlds.InsertParameters.Add("landsize", landsize.Text);
Sqlds.InsertParameters.Add("terrain", terrain.Text);
Sqlds.InsertParameters.Add("remarks", remarks.Text);
Sqlds.Insert();




I am having problem with my dropdownlist, Its not inserting selected values into database only the first value on the list that is inserted into the db.

Here is the varable for it.

Sqlds.InsertParameters.Add("stateList", stateList.SelectedValue);