怎么样在sharepoint 2010 中操作List的办法

怎么样在sharepoint 2010 中操作List的办法

Sharepoint 内置了几种列表类型:

public enum SPBaseType

{

UnspecifiedBaseType = -1,

GenericList = 0,

DocumentLibrary = 1,

Unused = 2,

DiscussionBoard = 3,

Survey = 4,

Issue = 5,

}

///

/// 新建列表

///

///

///

protected void btn_Click(object sender, EventArgs e)

{

using (SPSite site = new SPSite(requestUrl))

{

using (SPWeb web = site.OpenWeb())

{

SPList list = null;

string listName = txtListName.Text.Trim();

// Check whether the list already exists

try

{

list = web.Lists[listName];

}

catch (ArgumentException)

{

}

if (list == null)

{

Guid listId = web.Lists.Add(listName, "All our books",SPListTemplateType.GenericList);

list = web.Lists[listId];

list.OnQuickLaunch = true;

list.Update();

}

}

}

}

///

/// 判断列表是否存在

///

///

///

private bool IsListExist(string listName)

{

using (SPSite site = new SPSite(requestUrl))

{

using (SPWeb web = site.OpenWeb())

{

bool isExists = (from l in web.Lists.OfType()

where l.Title.Equals(listName)

select l).Count() > 0;

return isExists;

}

}

}

///

/// 创建栏

///

///

///

protected void btnAddField_Click(object sender, EventArgs e)

{

using (SPSite site = new SPSite(requestUrl))

{

using (SPWeb web = site.OpenWeb())

{

string listName = txtFieldList.Text.Trim();

SPList list = web.Lists[listName];

list.Fields.Add("ISBN", SPFieldType.Text, true);

list.Fields.Add("LeadAuthor", SPFieldType.Text, true);

list.Fields.Add("Price", SPFieldType.Currency, false);

list.Update();

}

}

}

///

/// 删除栏

///

///

///

protected void btnAddField_Click(object sender, EventArgs e)

{

using (SPSite site = new SPSite(requestUrl))

{

using (SPWeb web = site.OpenWeb())

{

string listName = txtFieldList.Text.Trim();

SPList list = web.Lists[listName];

//list.Fields.Delete("Price"); //删除栏

//list.Update();

}

}

}

///

/// 修改栏

///

///

///

protected void btnAddField_Click(object sender, EventArgs e)

{

using (SPSite site = new SPSite(requestUrl))

{

using (SPWeb web = site.OpenWeb())

{

string listName = txtFieldList.Text.Trim();

SPList list = web.Lists[listName];

//修改栏

//list.Fields["标题"].Title = "Title";

//list.Fields["标题"].Update();

//list.Update();

}

}

}

using (SPSite site = new SPSite(requestUrl))

{

using (SPWeb web = site.OpenWeb())

{

SPList bookList = web.Lists["Books"];

SPListItem item = bookList.Items.Add();

item["Title"] = "流氓是怎么炼成的";

item["ISBN"] = "12345";

item["LeadAuthor"] = "abc";

item.Update();

}

}