Oder By

[Guest]

I allowed C# to automatically create databindings for me as code below shows.
How can I set the orderby so the column i want is sorted? I have a combobox
in a datagridview and I need to sort the data shown in it by the commandtype
and not the primary key.

thanks

// TODO: This line of code loads data into the
'fixed1DataSet.Commands' table. You can move, or remove it, as needed.
this.commandsTableAdapter.Fill(this.fixed1DataSet.Commands);

 

[Guest]

I got it. I chaged the underlying SQL statement

 

[Peter Bradley]

Do it in your SQL?


Peter