Bind Repeater without Postback on Formview insert

Question

I have two controls on my web user control page...one is formview and another is Repeater.

when data is inserted by of FormView or updated by then without postback data should be bind to repeater but without postback without. I tried updatePanel but UpdatePanel is creating trouble with formview button id.Please Help....ASAP  

 

Please Provide link if possible 

Answer 1

You can use ISNULL function, if value is null it display 0

 

ISNULL(columnName, 0)

 

For further reference:

http://stackoverflow.com/questions/16667148/instead-of-null-how-do-i-show-0-in-result-with-select-statement-sql

 

Do let me know if it solves your problem. 

Answer 2

Use this code.

ISNULL(clmnName, 0)