[WPF] TextBlock: set length of number with string format

Question

Hi,


I formatted a TextBlock with:


<TextBlock Text="{Binding Value, StringFormat='\{0,0\}%'}"/>
to display a number in the format 99.9%.


With this string format, the user can write 9999999999%, it's wrong!


The part integer should be max of  2 number.


Thanks.

Answer 1

here is an example

 

you may have to change according to your table:

CREATE TRIGGER trg_Update_Qty
   ON  Stock
   AFTER UPDATE
AS
    UPDATE Stock SET Keterangag = 0 FROM inserted WHERE inserted.qty = 0 and inserted.kode_barang = Stock.kode_barang
GO

 please mark the answer as accepted if it satisfies your question

Answer 2

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

Answer 3

you can show me example code?