Home Upgrade Search Memberlist Extras Hacker Tools Award Goals Help Wiki Contact

C# 

Get multiple picture from database



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]

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 ???
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][Image: 100_Emoji_large.png?v=1480481062][Image: 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]
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]
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 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


Possibly Related Threads...
Thread / Author Replies Views Last Post
[C#] by john ronaldsadJul 20, 2022 06:49 PM 4 235 Jul 20, 2022 06:49 PM
Last Post: john ronaldsad
[.NET] by zetzaNov 9, 2017 12:45 PM 5 132 Nov 9, 2017 12:45 PM
Last Post: 0xDEAD10CC
[.NET] by FKTHEkingDec 9, 2015 01:58 AM 5 146 Dec 9, 2015 01:58 AM
Last Post: Josh‎