Is there a need for your own GetListDataSet method? SPListItemCollection already has a GetDataTable method. http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.splistitemcollection.getdatatable.aspx SPWeb oWebsite = SPContext.Current.Web; SPList oList = oWebsite.Lists["List_Name"]; SPListItemCollection collListItems = oList.Items;
DataGrid1.DataSource = collListItems.GetDataTable(); DataGrid1.DataBind(); From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ed Richard Sent: Tuesday, 1 July 2008 3:19 PM To: [email protected] Subject: RE: [OzMOSS] How to programmatically get the Date, Time & Location from the Meeting Workspace Found some old code Haris, it's toitally taken out of context so it does not make any sense but I had to quickly test and see what happens. Anyway, you can access a list called "Meeting Series" in a Meeting Workspace, this contains the info you want. Ed static void Main(string[] args) { DataSet ds = listmeetinginfo(); Console.WriteLine(ds.Tables[0].Rows.Count); Console.Read(); } static DataSet listmeetinginfo() { DataSet ds ; using (SPSite oSPsite = new SPSite("http://spdev2008/RandD";)) { ds = GetListDataSet("Meeting Series", oSPsite); } return ds; } static DataSet GetListDataSet(string cList, SPSite mySite) { DataSet ds = new DataSet(cList); SPWeb site = mySite.OpenWeb("/RandD/MS1"); SPList list = site.Lists[cList]; // Add a DataTable for each List DataTable dt = new DataTable(list.Title); // Add the columns based on List definition SPFieldCollection fields = list.Fields; int n = 0; foreach (SPField field in fields) { // Why, I don't know, but it seems to work when I skip this field if (field.InternalName != "InstanceID") { n = n + 1; DataColumn dc = new DataColumn(field.Title + "_" + n.ToString()); //field.InternalName); dt.Columns.Add(dc); } } // Add the data foreach (SPListItem Item in list.Items) { DataRow dr = dt.NewRow(); // dt.Columns.Count-2 for (int i = 0; i <= n - 2; i++) { if (Item[i] != null) dr[i] = Item[i].ToString(); else dr[i] = "<NULL>"; } dt.Rows.Add(dr); } ds.Tables.Add(dt); return ds; } From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haris Siakallis Sent: Tuesday, 1 July 2008 4:46 PM To: [email protected] Subject: RE: [OzMOSS] How to programmatically get the Date, Time & Location from the Meeting Workspace I thought about this, however there can be multiple events with the same MeetingInstanceID on the calendar list? But I will look into it again. Thanks for the help. Haris From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ed Richard Sent: Tuesday, 1 July 2008 4:31 PM To: [email protected] Subject: RE: [OzMOSS] How to programmatically get the Date, Time & Location from the Meeting Workspace Haris, I think an option is to use the MeetingInstanceID and SPQuery to query the Calendar list for items related to the meeting workspace. Sorry, I'm doing this from memory haven't got any source code for you. Ed Richard Senior Consultant, SharePoint MVP M: 04 06385559 P: 03 97623155 E: [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> W: www.SoftwareObjectives.com.au<http://www.softwareobjectives.com.au/> B: EdOnOffice<http://edonoffice.blogspot.com/> This email and any files transmitted with it are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient you have received this email in error and are requested to delete it immediately. Please consider the environment before printing this email. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haris Siakallis Sent: Tuesday, 1 July 2008 3:11 PM To: [email protected] Subject: [OzMOSS] How to programmatically get the Date, Time & Location from the Meeting Workspace Hello, I am wondering how to programmatically retrieve the Date, Time & Location from a meeting workspace using VB.net or C#. I have been surfing the internet for the last few hours with no success. However I came across two identical questions, in which no answer was provided. http://www.eggheadcafe.com/forumarchives/Sharepointwindowsservicesdevelopment/Dec2005/post24722734.asp http://www.eggheadcafe.com/forumarchives/Sharepointwindowsservicesdevelopment/Mar2006/post25999376.asp I have tried the following: If SPMeeting.IsMeetingWorkspaceWeb(ElevatedSite) Then Dim test As SPMeeting = SPMeeting.GetMeetingInformation(ElevatedSite) test. End If but test has no properties to retrieve the date, time and location. Any help would be greatly appreciated, thanks in advance. Regards Haris No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.4.1/1521 - Release Date: 26/06/2008 11:20 AM ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.4.1/1521 - Release Date: 26/06/2008 11:20 AM No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 270.4.1/1521 - Release Date: 26/06/2008 11:20 AM ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
