Question sql not sorting

[Gideon]

I have the following code in an vb.net application :

opdragsorteer.Connection = konneksie
opdragsorteer.CommandText = "SELECT * FROM Ontledings ORDER BY AREA DESC"
opdragsorteer.ExecuteNonQuery()

However it does not sort the sql table.

Any help would be appreciated.

Regards

 

[Herman]

What do you mean by sort the table? This query returns a data set sorted by area descending, it doesn't sort the table. There is no point in sorting indexed data.

 

[JuggaloBrotha]

I have the following code in an vb.net application :

opdragsorteer.Connection = konneksie
opdragsorteer.CommandText = "SELECT * FROM Ontledings ORDER BY AREA DESC"
opdragsorteer.ExecuteNonQuery()

However it does not sort the sql table.

Any help would be appreciated.

Regards

What do you mean it does not sort the table?
When you get the data out of the table is it sorted by [Area] in descending order?
If so, then the query is working as expected. If not, then what does your data look like? What are you trying to achieve?

 

[Herman]

@Juggalo

Judging from ExecuteNonQuery I think the OP is just confused about how SQL works...

 

[JuggaloBrotha]

@Juggalo

Judging from ExecuteNonQuery I think the OP is just confused about how SQL works...

Good catch, he's gonna have a lot of problems viewing his data if he's not even capturing the results from the database in his program.