How to interact sharepoint CMS with visual studio

Question

I am using office365 and I have created a custom list and document library in this.

1. So How can we use this list and library in visual studio for a web application ?

 

2. How can we use sharepoint as CMS to interact with visual studio to create a web application.?

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)