1
Answer

How to use calendar control for creating appointments

Mahesh Bodepudi

Mahesh Bodepudi

11y
1.3k
1
Hi,
 
I want to display a calendar where we can create appointments for particular date and time .I am using Windows 8 Phone Panorama application.
 
So could anybody explain how to make this operation using date calendar in Windows 8 Phone app?
 
Thank You
Answers (1)
2
Nilesh Shah
NA 22.3k 215k 7y
here is an example
 
you may have to change according to your table:
  1. CREATE TRIGGER trg_Update_Qty  
  2.    ON  Stock   
  3.    AFTER UPDATE  
  4. AS   
  5.     UPDATE Stock SET Keterangag = 0 FROM inserted WHERE inserted.qty = 0 and inserted.kode_barang = Stock.kode_barang  
  6. GO 
 please mark the answer as accepted if it satisfies your question
Accepted
1
Nilesh Shah
NA 22.3k 215k 7y
I assume you want to delete the data in the last column from table when qty = 0.
 
write a trigger on that table in check if qty=0, then delete data in last column i.e. set it to 0
0
Amrul Hakim
NA 19 1.2k 7y
you can show me example code?