using System;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using Microsoft.SharePoint;
using System.Data;
namespace VisualWebPartProject1.VisualWebPart1
{
public partial class VisualWebPart1UserControl : UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
SPSite objSite = new SPSite("http://intranet.contoso.com");
SPWeb objWeb = objSite.OpenWeb();
SPList objList = objWeb.Lists["Employee"];
//DataTable dt = new DataTable();
//dt.Columns.Add("Name");
//dt.Columns.Add("Email ID");
//dt = objList.Items.GetDataTable();
this.GridView1.DataSource = objList.Items.GetDataTable();
this.GridView1.DataBind();
//get the emaployee id 1 and show in the text box
SPListItem objItem = objList.GetItemById(1);
this.txtName.Text = objItem["Title"].ToString();
this.txtEmilID.Text = objItem["Email ID"].ToString();
}
catch (Exception ex)
{
this.Label1.Text = ex.Message;
}
}
}
protected void btnTest_Click(object sender, EventArgs e)
{
SPSite objSite = new SPSite("http://intranet.contoso.com");
SPWeb objWeb = objSite.OpenWeb();
SPList objList = objWeb.Lists["Employee"];
//get the emaployee id 1 and show in the text box
SPListItem objItem = objList.GetItemById(1);
objItem["Email ID"] = this.txtEmilID.Text;
objItem.Update();
}
}
}
-------------------------------------------------------------------
<%@ Assembly Name="$SharePoint.Project.AssemblyFullName$" %>
<%@ Assembly Name="Microsoft.Web.CommandUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Register Tagprefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Register Tagprefix="Utilities" Namespace="Microsoft.SharePoint.Utilities" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Register Tagprefix="asp" Namespace="System.Web.UI" Assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" %>
<%@ Import Namespace="Microsoft.SharePoint" %>
<%@ Register Tagprefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="VisualWebPart1UserControl.ascx.cs" Inherits="VisualWebPartProject1.VisualWebPart1.VisualWebPart1UserControl" %>
All The Employee
