?Select Field Order in DataSet

[Lumpierbritches]

Thank you so much for all the assistance I've been getting here in advance.
Especially to the MVP's and the people that take their valuable time in
answering questions for newbies like me. :)

I was wondering if there is a way to select the field order from your tables,
in the datasets? Also, is there a way, by creating a relationship with another
table, create a combobox/dropdown in a DataSet?

Michael

[Bernie Yaeger]

Hi,

Not sure I understand, but setting the column order in a datatable is quite
simple:
Dim dagsm_d As New SqlDataAdapter("select upc, issuecode from " &
glf_tablename & " order by upc, issuecode", oconn)

Here column 0 is upc, column 1 is issuecode.

HTH,

Bernie Yaeger

"Lumpierbritches" <lu*************@aol.com> wrote in message
news:20***************************@mb-m23.aol.com...

Thank you so much for all the assistance I've been getting here in advance. Especially to the MVP's and the people that take their valuable time in
answering questions for newbies like me. :)

I was wondering if there is a way to select the field order from your tables, in the datasets? Also, is there a way, by creating a relationship with another table, create a combobox/dropdown in a DataSet?

Michael