?Select Field Order in DataSet

  • Thread starter Thread starter Lumpierbritches
  • Start date Start date
L

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
 
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
 
Back
Top