Read and add items to SharePoint list

Category SharePoint 2007 | Publication Date : 11/1/2009

First you have to add the reference to Microsoft.Sharepoint.dll (Then in your code use "using Microsoft.Sharepoint;").

Read SharePoint List

public void getData()
{
    SPSite site = new SPSite("http://mySite:8000");
    SPWeb web = site.OpenWeb();
    SPList list = web.Lists["myListName"];
    SPQuery myquery = new SPQuery();
    myquery.Query = "myQuery";
    //empty query will return all items

    SPListItemCollection items = list.GetItems(myquery);

    foreach (SPListItem item in items)
    {
        if (item != null)
        {
            //do something
        }
    }
}

Adding Item

string strUrl = "http://mysite:8000/";
using (SPSite site = new SPSite(strUrl))
{
    using (SPWeb web = site.OpenWeb())
    {
        SPListItemCollection listItems = web.Lists["List_Name"].Items;
        SPListItem item = listItems.Add();
        item["Title"] = "New Item Title";
        item.Update();
    }
}