Dropdownlist problem

Question

Hi everyone Im sure you've heard this problem a million times but i sure could use some help. Im new to visual studio and C#. Im trying to implement a web form and everythings working fine except my bloody dropdownlist. I'm populating it from a Sql Server database and its populating fine the information is there. The problem is no matter which option i select it always gives the value of the first record from the table. I'm sure its the most ridiculous thing im missing but i can't seem to find it. My C# code is below Id appreciate any response - Thanks private void Page_Load(object sender System.EventArgs e) { sqlConnection1.Open(); SqlCommand cmd = new SqlCommand(Select * from course sqlConnection1); SqlDataReader result = cmd.ExecuteReader(); ddlTest.DataSource = result; ddlTest.DataTextField = FullName; ddlTest.DataValueField = Code; ddlTest.DataBind(); result.Close(); } There are other text box's in the form that work fine. I dont want to waste time by including all the code but basically the selection is then Inserted into a table. It inserts alright but only the first record of the table.

Brian55 0 · Answer

I am having same problem. Seems identical to yours. How did you get around this? The bigger issue is why doesn't my (our) code work? More then a few people have looked at my code with no success. Brian

israfel_e · Answer

I have it working now i do have that line of code instead of the selectedItem.value etc but i've implemented it differently as well. From a sqlDataAdapter and Dataset instead of a datareader not sure which might be responsible. It's sickening when two or three lines of code can hold you up for so long. Which brings me nicely onto my next thread lol. I'm at that terrible phase of learning something new where I'm improving but this is just bringing up whole new problems .

ytram5 · Answer

Try using ddlTest.SelectedValue.ToString() and let us know if it works.

israfel_e · Answer

Well below is the code i use to update the database. Cheers for any help private void Button1_Click(object sender System.EventArgs e) { string ucasNum = UCAS.Text; string LName = LastName.Text; string FName = FirstName.Text; string AddressOne = Address1.Text; string AddressTwo = Address2.Text; string AddressThree = Address3.Text; string AddressFour = Address4.Text; string Post_Code = PostCode.Text; string DayAttending = ddlTest.SelectedItem.Value.ToString(); try { //sqlConnection1.Open(); ///////////////////////TEST CONNECTION///////////////////////////////////////////////// SqlCommand cmd = new SqlCommand(select * from Applicant sqlConnection1); cmd.Parameters.Add(@UCASSqlDbType.VarChar); cmd.Parameters[@UCAS].Value = ucasNum; cmd.Parameters.Add(@LastNameSqlDbType.VarChar); cmd.Parameters[@LastName].Value = LName; cmd.Parameters.Add(@FirstNameSqlDbType.VarChar); cmd.Parameters[@FirstName].Value = FName; cmd.Parameters.Add(@Address1SqlDbType.VarChar); cmd.Parameters[@Address1].Value = AddressOne; cmd.Parameters.Add(@Address2SqlDbType.VarChar); cmd.Parameters[@Address2].Value = AddressTwo; cmd.Parameters.Add(@PostCodeSqlDbType.VarChar); cmd.Parameters[@PostCode].Value = Post_Code; cmd.Parameters.Add(@CourseSqlDbType.VarChar); cmd.Parameters[@Course].Value = DayAttending; cmd = new SqlCommand(insert into Applicant (UCAS LastName FirstName Address1 Address2 PostCode) values (@UCAS @LastName @FirstName @Address1 @Address2 @PostCode);Insert into applications(Code UCAS)values(@Course @UCAS)sqlConnection1); cmd.Parameters.Add(@UCASSqlDbType.VarChar); cmd.Parameters[@UCAS].Value = ucasNum; cmd.Parameters.Add(@LastNameSqlDbType.VarChar); cmd.Parameters[@LastName].Value = LName; cmd.Parameters.Add(@FirstNameSqlDbType.VarChar); cmd.Parameters[@FirstName].Value = FName; cmd.Parameters.Add(@Address1SqlDbType.VarChar); cmd.Parameters[@Address1].Value = AddressOne; cmd.Parameters.Add(@Address2SqlDbType.VarChar); cmd.Parameters[@Address2].Value = AddressTwo; cmd.Parameters.Add(@PostCodeSqlDbType.VarChar); cmd.Parameters[@PostCode].Value = Post_Code; cmd.Parameters.Add(@CourseSqlDbType.VarChar); cmd.Parameters[@Course].Value = DayAttending; cmd.ExecuteNonQuery(); /////////////////////////////////////////////////////////////////////////////////////// TestLabel.Text = The database was updated in this test : + LName; } finally{ }

yasser_8227 · Answer

I don't see any problem with your code. Can you post the code where you're retrieving the value of the DropDownList.