?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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top