What's wrong with this? (ComboBox Filling)

Question

Some help please... SqlCommand cmd = GlobalVar.Connection.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = SELECT CurrSymb FROM GNCurrency ORDER BY CurrSymb; SqlDataAdapter da = new SqlDataAdapter(); DataSet ds = new DataSet(); da.SelectCommand = cmd; da.Fill(ds Moneda); cboValuta.DataSource = ds; for(int i = 0; i < ds.Tables[Moneda].Rows.Count; i++) { cboValuta.Text = ds.Tables[Moneda].Rows[i][CurrSymb].ToString(); }

bonnieb · Answer

Try setting the DataSource to the DataTable instead of to the DataSet. cboValuta.DataSource = ds.Tables[0]; ~~Bonnie

thed0ct0r · Answer

I was talking about DropDownList isn't it the same??? I called it Combobox in Vb6 application not in .Net

tgd · Answer

Thanks but I've already tried somth. like this: cboValuta.DisplayMember = CurrSymb; cboValuta.ValueMember = CurrSymb; but doesn't works.. (DataTextField DataValueField aren't properties of ComboBox)

thed0ct0r · Answer

I think the FOR is wrong and not necessary to fill a dropdown type this: .... .... .... da.Fill(ds Moneda); cboValuta.DataSource = ds; cboValuta.DataTextField = CurrSymb; cboValuta.DataValueField = another field like an ID; cboValuta.DataBind(); I hope it works... :-)