ValueMember of comboBox problem

[moonangel_bio]

Hi all, I’m using the comboBox to show values to select one of them Those values are from a database, where there are Ids and values. So, the DisplayMember is the value and the ValueMember is the ID. the first worked but the second refuses to work at all. And I don’t know why..? comboBox1.DataSource = dataSet3.Tables["DESIGNATION_EDIT"]; comboBox1.ValueMember = "D_ID"; comboBox1.DisplayMember = "D_TYPE"; then i need to use it here where the problem appears newrow[11]=comboBox1.ValueMember; table.Rows.Add(newrow); if any body could help.., I’ll be grateful.

[Christian Graus]

moonangel_bio wrote:

hen i need to use it here where the problem appears newrow[11]=comboBox1.ValueMember; table.Rows.Add(newrow);

what actually happens ? Christian Graus - Microsoft MVP - C++

[moonangel_bio]

when i try to add a new record using my application, this messeage appears: An unhandled exception of type 'System.ArgumentException' occurred in system.data.dll Additional information: System.FormatException: Input string was not in a correct format. at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at System.Int32.Parse(String s, NumberStyles style, IFormatProvider provider) at System.Convert.ToInt32(String value, IFormatProvider provider) at System.String.System.IConvertible.ToInt32(IFormatProvider provider) at System.Convert.ToInt32(Object value) at System.Data.Common.Int32Storage.Set(Int32 record, Object value) at System.Data.DataColumn.set_Item(Int32 record, Object value)Couldn't store in S_DESIGNATION_ID Column. Expected type is Int32. where D_ID is the ValueMember of the comboBox and i need it to be stored in S_DESIGNATION_ID in the data base

[Christian Graus]

Well, now that you're told us the problem, it's obvious. A string that's coming in is not a number, and it needs to be. Christian Graus - Microsoft MVP - C++