Jan 18, 2019 03:23 PM
(This post was last modified: Jan 18, 2019 03:27 PM by adenfr.)
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
![[Image: 0113.png]](https://i55.servimg.com/u/f55/13/79/70/03/0113.png)
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??
What on earth are you talking about?
(Jan 18, 2019 07:04 PM)+Haze Wrote: What on earth are you talking about?
What ???
Jan 19, 2019 02:08 AM
(This post was last modified: Jan 19, 2019 02:09 AM by StarZ.)
Hold on, I speak retard, Allow me to translate.
(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. ![[Image: 100_Emoji_large.png?v=1480481062]](https://cdn.shopify.com/s/files/1/1061/1924/products/100_Emoji_large.png?v=1480481062) ![[Image: 100_Emoji_large.png?v=1480481062]](https://cdn.shopify.com/s/files/1/1061/1924/products/100_Emoji_large.png?v=1480481062) ![[Image: 100_Emoji_large.png?v=1480481062]](https://cdn.shopify.com/s/files/1/1061/1924/products/100_Emoji_large.png?v=1480481062)
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.
fuck.
![[Image: wyEbCMi.png]](https://i.imgur.com/wyEbCMi.png)
Not trying to be a dick, It just comes naturally.
(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.
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: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
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.
fuck.
![[Image: wyEbCMi.png]](https://i.imgur.com/wyEbCMi.png)
Not trying to be a dick, It just comes naturally.
(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.
thanks bro i will try that
Jan 19, 2019 04:28 AM
(This post was last modified: Jan 19, 2019 04:28 AM by itcorp.)
(Jan 19, 2019 02:51 AM)adenfr Wrote: thanks bro i will try that
https://pastebin.com/raw/7wkHqwM1
buy me a coffee eth:0x88621A52aa5Eb3b6503628369687111810186c58
(Jan 19, 2019 04:28 AM)itcorp Wrote: https://pastebin.com/raw/7wkHqwM1
thank you very match
(Jan 20, 2019 08:05 AM)adenfr Wrote: thank you very match
you're welcome,and have you managed to solve the your problem
buy me a coffee eth:0x88621A52aa5Eb3b6503628369687111810186c58
|