hi, i am trying to retreive data from a sharepoint list but its returns all columns such as ows_MetaInfo, ows__ModerationStatus ,ows__Level ows_ID ,ows_owshiddenversion, ows_UniqueId ,ows_FSObjType
rather than just the fields i want from the list.
I thought the "<IncludeMandatoryColumns>FALSE</IncludeMandatoryColumns> tag would filter these colums out
Can any1 help?
heres my code:
webreference.Lists myList = new webreference.Lists();
myList.Credentials = new NetworkCredential(Username, Password, Domain);
// myList.Url = "http://193.82.85.1/HelpDesk/_vti_bin/lists.asmx";
XmlDocument xmlDoc = new XmlDocument();
XmlNode ndQuery = xmlDoc.CreateElement("Query");
XmlNode ndViewFields = xmlDoc.CreateElement("ViewFields");
XmlNode ndQueryOptions = xmlDoc.CreateElement("QueryOptions");
ndQueryOptions.InnerXml = "<IncludeMandatoryColumns>FALSE</IncludeMandatoryColumns>" + "<DateInUtc>FALSE</DateInUtc>" + "<IncludeAttachmentUrls>TRUE</IncludeAttachmentUrls>/>";
ndViewFields.InnerXml = "<FieldRef Name='Title' /> <FieldRef Name='SRDetail'/> <FieldRef Name='Priority'/> <FieldRef Name='Raised_x0020_By'/> <FieldRef Name='Date_x0020_Raised'/> <FieldRef Name='Category'/> <FieldRef Name='Centre'/> <FieldRef Name='ResolutionType' />";
ndQuery.InnerXml = "<OrderBy><FieldRef Name='Date_x0020_Raised'/></OrderBy>";
//"<Query><Where><Eq><FieldRef Name='Raised_x0020_By' /><Value Type='Text'>ddlRaisedBy.Value</Value></Eq></Where></Query>"
XmlNode nodeListItems = myList.GetListItems("{002DD75F-2F5A-407C-95A7-2C8CC7156C58}", "{3D3A5BB0-4994-4D64-891C-24D6ECB31991}", ndQuery, ndViewFields, "5", ndQueryOptions, null);
XmlReader reader = new XmlNodeReader(nodeListItems);
DataSet ds = new DataSet();
ds.ReadXml(reader);
// GridView1.DataMember = "yourmembers";
GridView1.DataSource = ds.Tables[1];
GridView1.DataBind();
cheers
Unsolved 
