Click here to Skip to main content
15,923,051 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
C#



XML
SPSite osite = SPContext.Current.Site;
           SPWeb Oweb = osite.OpenWeb();
           Oweb.AllowUnsafeUpdates = true;
           SPList olist = Oweb.Lists["Documents"];

           //SPList extInfo = Oweb.GetListFromUrl("/Forms/ResultView.aspx");

           //SPView srcView = extInfo.Views["ResultView"];
           SPQuery query = new SPQuery();
           query.RowLimit = 30;
           query.ViewFields = generateQueryFields();
           query.Query = generateQueryValues();
           SPListItemCollection collListItems = olist.GetItems(query);

           string resultid = "";
           string resultscandate = "";
           string resultscostumers = "";
           string resultdescription = "";
           string resulttechician = "";
           string resultcontactbycostumer = "";
           string resultcontenttype = "";
           string resultcreatedate = "";

           foreach (SPListItem oListItem in collListItems)
           {

             resultid += oListItem["ID"].ToString();
               resultscandate += oListItem["Scandate"];
             resultscostumers += oListItem["Costumers"];
             resultcontactbycostumer += oListItem["Costumers_x003a__x0020_YomiFullName"];
             resultdescription += oListItem["Document Description"];
              resulttechician += oListItem["Technician"];
              resultcontenttype += oListItem["ContentType"];
             resultcreatedate += oListItem["Created"];

           }

           string totaalresult = resultid + "<BR>"
               + resultscandate + "<BR> " +
              resultcontactbycostumer + "<BR>" +
               resultscostumers + "<BR>" +
               resultdescription + "<BR>" +
               resulttechician + "<BR>" +
               resultcontenttype + "<BR>" +
               resultcreatedate;

           Label6.Text = totaalresult;


<Query />
Posted
Comments
Sergey Alexandrovich Kryukov 12-May-12 22:21pm    
Where is your exception information? In what line? Did you run it under debugger?
--SA
Quinttin 13-May-12 12:14pm    
yes i did with debugger
Quinttin 12-May-12 22:24pm    
foreach (SPListItem oListItem in collListItems)
i get the exception
Sandeep Mewara 13-May-12 1:20am    
What exception?
Quinttin 13-May-12 11:47am    
One or more field types are not installed properly. Go to the list settings page to delete these fields.

1 solution

Check your field names like "Document Description".

-Navin
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900