using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint;
using System.Data;
using System.Globalization;
namespace ISNULL
{
class Program
{
static void Main(string[] args)
{
using (SPSite site = new SPSite("http://serverName/sites/Vijai"))
{
using (SPWeb web = site.OpenWeb())
{
SPList list = web.Lists.TryGetList("Custom");
SPQuery query = new SPQuery();
query.Query = "<Where><IsNull><FieldRef Name='Test' /></IsNull></Where>";
SPListItemCollection itemColl = list.GetItems(query);
foreach (SPListItem item in itemColl)
{
Console.WriteLine(item["Title"]);
}
Console.ReadLine();
}
}
}
}
}