hello guys

i'm want to ask if there is a possibility to get top 10 product image (high saling) from database (C# SQLServer)
it try with that with another exemple without image
here is my table



but i want to get the top 10 and link theme with picturebox or Shelf/Grid View or Shelf Item  in dashboard as example

any help??

(Jan 18, 2019 07:04 PM)+Haze Wrote:  What on earth are you talking about?

(Jan 18, 2019 03:23 PM)adenfr Wrote:  Sup niggaz,

I'm tryna get the top 10 (highest selling) product pix from a db (C# SQLServer, ya feel me?)

I wanna line dem niggaz up in a GridView dashboard like thing naamsayin?

Deuces niggaz.

(Jan 19, 2019 02:08 AM)StarZ Wrote:  Hold on, I speak retard, Allow me to translate.


Add a Column for 'amountSold', int.

Query:

Code

SELECT * FROM `TableName` ORDER BY `amountSold` DESC;

Then add the images (StoreProImage) to your control along with whatever other data you wish.

(Jan 19, 2019 02:23 AM)adenfr Wrote:  is not a solution bro
amountSold =SUM(Qte) and i already did it and in your query you not selecting any image !!!

can you provide more exemple

(Jan 19, 2019 02:32 AM)StarZ Wrote:  I'm selecting EVERYTHING (all values) from the table sorting by the value of amountSold. Just grab the image and put it in the control. Also may want to add a limit of 10 to the statement. SQL Isn't the hardest thing to learn. Study up more I feel most people on this forum haven't used it in conjunction with a Desktop Application.

(Jan 19, 2019 02:51 AM)adenfr Wrote:  thanks bro i will try that

(Jan 19, 2019 04:28 AM)itcorp Wrote:  https://pastebin.com/raw/7wkHqwM1

(Jan 20, 2019 08:05 AM)adenfr Wrote:  thank you very match