how to read only one field of a table

Question

I have a database called HARPIA. In this database i have a table called GENERO, and in this table i have three fields (N_GENERO, GENERO, N_TRIBO). I would like to read only the values into the field N_GENERO and show its values in a Combobox called cboGenero. To do this i used the code below but its not so good. I have some problems with this code. There is anybody that can help me. Whats the correct code to use? thisAdapter = new OleDbDataAdapter( "SELECT n_genero FROM genero WHERE genero = '+ nomegenero'", dbBanco.thisConnection); thisBuilder = new OleDbCommandBuilder(thisAdapter); thisDataSet = new DataSet(); thisAdapter.Fill(thisDataSet,"genero"); cboGenero.text = thisDataSet.Tables ["genero"].Columns ["n_genero"]; }

Administrator · Answer

Thanks MikeR ; I used your suggestion to solve my problem and everything functioned well. Suppa

Administrator · Answer

thisDataSet.Tables ["genero"].Columns ["n_genero"] returns DataColumn object which has nothing to do with database field value and can't be converted to integer! To access the field value you need to use different objects. I've shown one of them in the code. The syntax is: DataTable[TableName].Rows[DataRowIndex][ColumnName]

Administrator · Answer

Thanks Mike; I wrote the code: this.cbo2.DataSource = thisDataSet.Tables ["genero"]; for(int i = 0; i < thisDataSet.Tables["genero"].Rows.Count; i++) { this.cbo2.DisplayMember = "n_genero"; } And OK. It assumes that i want to put only one value of a specific GENERO into a variable. How can i do that. I try: numGenero = Convert.ToInt32 (thisDataSet.Tables ["genero"].Columns ["n_genero"]); but is wrong. Can you help me again

Administrator · Answer

This line: cboGenero.text = thisDataSet.Tables ["genero"].Columns ["n_genero"]; returns DataColumn object. Try something like this: for(int i = 0; i < thisDataSet.Tables["genero"].Rows.Count; i++) { cboGenero.Text = thisDataSet.Tables["genero"].Rows[i]["n_genero"].ToString(); } Mike

how to read only one field of a table

Answers (4)