public DataTable GetLeaveAppliers() { using (SPSite site = new SPSite(SPContext.Current.Site.Url)) { using (SPWeb web = site.OpenWeb()) { SPList list = web.Lists["Leave Plan"]; SPQuery q = new SPQuery(); string query = ""; q.Query=query; DataTable dt = list.GetItems(q).GetDataTable(); DataTable row= dt.DefaultView.ToTable(true, "Author"); return row; } } }