Wednesday, July 13, 2011

Insert New Item Into SharePoint List

using (SPSite spSite = new SPSite(strSiteUrl, token))
{
spSite.AllowUnsafeUpdates = true;
using (SPWeb spWeb = spSite.OpenWeb())
{
SPList spList = spWeb.Lists["ConferenceRoomRequest"];
SPList loclist = spWeb.Lists["Locations"];
SPListItem spListItem = spList.Items.Add();
//SPListItem splocListItem = loclist.Items.Add();
string user = spWeb.CurrentUser.Name.ToString();
SPQuery query = new SPQuery();
string strquery = "" + ddlLocation.SelectedValue + "";


SPSecurity.RunWithElevatedPrivileges(delegate() { string guid = Guid.NewGuid().ToString();
spListItem["Title"] = guid;
spListItem["Location"] = ddlLocation.SelectedValue;
spListItem["Rooms"] = ddlRoom.SelectedValue; spListItem["Start_x0020_Time"] = ddlStartTimeHours.SelectedValue + ":" + ddlStartTimeMinutes.SelectedValue;
spListItem["End_x0020_Time"] = ddlEndTimeHours.SelectedValue + ":" + ddlEndTimeMinutes.SelectedValue;
spListItem["Purpose"] = ddlRoom.SelectedValue + " " + txtPurpose.Text;
spListItem["Comments"] = txtComments.Text;
spListItem["Requestor_x0020_Name"] = txtRequestorName.Text;
spListItem["Mobile_x0020_No"] = txtMobile.Text; spListItem["E_x002d_mail_x0020_ID"] = txtMailid.Text; spListItem["No_x002e_of_x0020_People"] = txtPeople.Text;

spListItem["Action_x0020_Hyperlink"] = myurl;
SPFieldUrlValue linkurl = new SPFieldUrlValue(); linkurl.Description = "Remove"; linkurl.Url = strSiteUrl + "/" + "SitePages/ConferenceBookingRequest.aspx?RequestID=" + guid + " &Status=" + requestorStatus; spListItem["RequestorAction"] = linkurl; spWeb.AllowUnsafeUpdates = true; spListItem.Update();
});