Question on DataTable.Select

From: "Wan" <wandii@xxxxxxxxx>
Date: 4 Jan 2007 14:53:07 -0800

Hi,
I have a test project which contains two simple forms - 1st form
contains datagrid and couple of buttons. First button to populate the
grid with Northwind.Customers records and show 3 columns - CustomerID
|CompanyName| ContactName - works fine.

2nd button to bring up the second form contains a datagrid with
customer records with no sorting or order by. The problem is that when
I select one of the customer records and try to show the selected
record back to the 1st form in the datagrid as:

DataGrid.DataSource = DataSet1.Tables(0).Select("CustomerID = '" +
sCustID + "'")

the Order of the columns in datagrid changes to - ContactName
|CompanyName | CustomerID. Any ideas?

Regards,
Wan

.

Follow-Ups:
- Re: Question on DataTable.Select
  - From: Cor Ligthert [MVP]

Prev by Date: Re: copy a gif file to clipboard
Next by Date: RE: VB 2005 and Content Security Question
Previous by thread: Help using Microsoft.Office.Interop.Access
Next by thread: Re: Question on DataTable.Select
Index(es):
- Date
- Thread