Click here to Skip to main content
15,879,095 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi Guys, i have a POS and Kitchen Queuing where the Kitchen Queuing display is in another laptop. I have 3 listview's which collects the data from the database[dbo.Kitchen] - columns (tblnmber, Product, Quantity), specifically the table number of the customer who ordered an item. and when you click the table number, the products and quantity will show on another listview which is also can be 'Accept' -using the btnAccept and Done -using the btnDone. when it's done the orders will clear and also the table number from the queue , it's good and also running smoothly.

But the problem is that our panelists, wants to make it like the queuing of Mcdo, which generates a datagridview (i guess) , and the orders are inside on it, and a timer on the top of that. I want my queue to make it like that because our panelists wanted to do so, but i don't have any idea generating that datagridview with the orders inside on it and a timer on the top. And ofcourse, clearing those order after the staff on the kitchen tap the button 'Done' inside the datagridview.

Any response or suggestions will be greatly appreciated ! Thank You!

What I have tried:

I've never tried, because i don't know how will i do it, but i have my own queuing , it's just that the panelists want to make it more like Mcdo's queuing. Which i am having a problem how to do it
Posted
Updated 26-Feb-19 20:55pm

1 solution

 
Share this answer
 
Comments
Fxty 27-Feb-19 3:53am    
I'm aware of Sql Dependency and tried it once, it's just the fact that i am having a hard time to generate a datagridview when some data in the database is inserted. And also, the timer on top of it. : (
Maciej Los 27-Feb-19 4:21am    
@Fxty, do not use timer. It's CPU consuming solution. SqlDependency class is that what you're looking for. Follow the second link. There's a sample chat application, which uses SqlDependency class. The data are exchanged on the fly. So, the second laptop (computer) is getting information about an order just right after it was generated on the first computer.
Fxty 27-Feb-19 21:01pm    
Okay ill try that one thanks
Maciej Los 28-Feb-19 1:58am    
You're very welcome.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900