SharePoint List C# - Create new Task using OM

Let’s see how we can create new share point task programmatically. Here is a sample code,

Private void CreateTask(string listName, string Title, string Body, string Reference, string Status, DateTime StartDate, DateTime DueDate, string PercentComplete, string AssignedTo, string Priority)

        {

            try

            {

              SPSite site = new SPSite(URL);

        using (SPWeb web = site.OpenWeb())

          {

                SPList list = web.Lists[listName];

                SPListItem newItem = list.Items.Add();

                newItem["Title"] = Title;

                newItem["Body"] = Body;

                newItem["Status"] = Status;

                newItem["StartDate"] = StartDate.ToString("MMMM dd, yyyy");

                newItem["DueDate"] = DueDate.ToString("MMMM dd, yyyy");

                newItem["PercentComplete"] = PercentComplete;

                newItem["Priority"] = Priority;

                if (AssignedTo != "")

                {

                   SPUser user = web.EnsureUser(AssignedTo);

                   newItem["AssignedTo"] = user;

                }

                else

                {

                    newItem["AssignedTo"] = AssignedTo;

                }

                newItem.Update();

MessageBox.Show("Task has successfully saved." + Environment.NewLine + ex.Message, "Message");

                 }

          }

            catch (Exception ex)

            {

MessageBox.Show("Couldn't create the Task" + Environment.NewLine + ex.Message, "Message");

            }

        }

SharePoint List C# - Read the task details using OM

In this article I am going to discuss how you can retrieve the task details from share point task list. Here is the sample code

            Create data table for task details

void CreateTaskTable()

        {

            try

            {

                dtTask = new DataTable();

                dtTask.Columns.Add("Tittle", typeof(string));

                dtTask.Columns.Add("Status", typeof(string));

                dtTask.Columns.Add("StartDate", typeof(string));

                dtTask.Columns.Add("Modified", typeof(string));

                dtTask.Columns.Add("Created", typeof(string));

                dtTask.Columns.Add("Priority", typeof(string));

                dtTask.Columns.Add("PercentComplete", typeof(string));

                dtTask.Columns.Add("AssignedTo", typeof(string));

                dtTask.Columns.Add("Body", typeof(string));

                dtTask.Columns.Add("DueDate", typeof(string));

            }

            catch (Exception)

            {

               

                throw;

            }

        }

            Retrieve the task details

public void RetriveTask()

        {

            CreateTaskTable();

            SPSite site = new SPSite(SiteURL);

            SPWeb web = site.AllWebs[0];

            SPList list = web.Lists[List];

            SPQuery myquery = new SPQuery();

            myquery.Query = "";

            // if you don’t insert query (myquery.Query ="") you will get all items

            SPListItemCollection ItemCollection = list.GetItems(myquery);

            foreach (SPItem item in ItemCollection)

            {

                DataRow dr= dtTask.NewRow();

                dr["Tittle"] = item["Title"];

                dr["Status"] = item["Status"];

                dr["StartDate"] = item["StartDate"];

                dr["Modified"] = item["Modified"];

                dr["Created"] = item["Created"];

                dr["Priority"] = item["Priority"];

                dr["PercentComplete"] = item["PercentComplete"];

                dr["AssignedTo"] = item["AssignedTo"];

                dr["Body"] = item["Body"];

                dr["DueDate"] = item["DueDate"];

                dtTask.Rows.Add(dr);

            }

 

SharePoint List C# - Create new List using OM

 In this post I'm going to share how to create new list using C#. Here is the sample code

public bool SaveList(string List,string Description,string type)

        {

            try

            {

SPSite site = new SPSite(SiteURL);

              SPWeb web = site.OpenWeb();

              web.Lists.Add(List, Description, web.ListTemplates[type]);

            }

            catch (Exception ex)

            {

           MessageBox.Show("Coundn't create the new list"+ Environment.NewLine + ex.Message,"Message");

           return false;

            }

            return true;

        }

SharePoint List C# - Read the list using OM

Here I'm going to show you how you can read the list from share point site.
 
To do this; First you have to add the reference to Microsoft.Sharepoint.dll (Then you can use "using Microsoft.Sharepoint;" in your code).

         

            //******Create Data table******

        void CreateListtable()

        {

            dtList = new DataTable();

            dtList.Columns.Add("List", typeof(string));

            dtList.Columns.Add("Description", typeof(string));

        }

            //******Read the lists******

        public void GetAllList()

        {

           CreateListtable();

           SPSite site = new SPSite(strUrl);

            using (SPWeb web = site.OpenWeb())

            {

                SPListCollection listcollection = web.Lists;

                {

                    foreach (SPList listName in listcollection)

                    {

                        DataRow dr = dtList.NewRow();

                        dr["List"] = listName;

                        dr["Description"] = listName.Description;

                        dtList.Rows.Add(dr);

                    }

                }

            }

        }