Wednesday, August 27, 2008

Distinct Values After Execute SP CAML Query

using (SPSite site = new SPSite(ConfigurationManager.AppSettings["SiteUrlPath"]))
{
using (SPWeb web = site.OpenWeb())
{
SPList lst = web.Lists["test"];
DataTable dt = lst.Items.GetDataTable();
if (dt != null && dt.Rows.Count > 0)
{
DataView v = new DataView(dt);
DataTable dtview = v.ToTable(true, "test");

}

}
}