C# – display sharepoint list value in visual web part

csharepoint-2010web-parts

I'd like to know how to get values from SharePoint list column in custom WebPart and I want to display it in the visual webPart.

 splist lists = web.list["list name"];
 spitem item = list.additem();
 item["Title"] = "doc";
 item["No"] = "1";'

I can use code something similar to the above to assign value in list column from visual WebPart. Is there a solution for the other way around — to get the value from SharePoint list and display it in visual WebPart?

Best Answer

there are lots of examples to populate a literal,label etc with the content of a list. you also might want to filter what you want to display. This is some code to get you started, if you require a more precise result just let us know what is the final result you wish to achieve:

 using (SPSite site = new SPSite(url))
            {
                using (SPWeb web = site.OpenWeb())
                {
                    SPList lists = web.Lists["list name"];
                    foreach (SPListItem itemin lists.Items)
                    {
                       string test = Convert.ToString( item["test"]);
                        TextBox1.Text = test;

                    }
                }
             }

Related Solutions

C# – Access list data through SharePoint Web Part

Since you're building a SharePoint Web Part, you should access the list and its data via the SPList class.

The linked document provides a short example of how to properly get a list from the current SharePoint site.

C# – Custom property editor for Web parts in SharePoint

You will want to create a custom ToolPart. Here is a guide: http://sharepoint-insight.blogspot.com/2008/10/sharepoint-creating-web-part-with.html

Basically in your WebPart code you will need to override the GetToolParts function and return a ToolPart[]

Change your toolpart constructor to accept an SPWeb object (pass it the SPContext.Current.Web object from your Web Part). To get the list of lists, in your toolpart you will need to create a dropdownlist inside your CreateChildControls() method. Using the SPWeb object you got from the Constructor you can use a for each to get all the lists for the current site.

So in your web part do this:

public override ToolPart[] GetToolParts()
{
    ToolPart[] tps = new ToolPart[3];

    WebPartToolPart wptp = new WebPartToolPart();
    CustomPropertyToolPart cptp = new CustomPropertyToolPart();
    tps(0) = cptp;
    tps(1) = wptp;
    tps(2) = new ListSelectionToolPart(SPContext.Current.Web, "List Settings");

    return tps;
}

private string _TargetListGUID;
[Personalizable(PersonalizationScope.Shared)]
[WebBrowsable(false)]
[WebDisplayName("Target List GUID")]
[WebDescription("GUID of the Target List")]
[SPWebCategoryName("Internal")]
public string TargetListGUID {
  get { return _TargetListGUID; }
  set { _TargetListGUID = value; }
}

Add a class like this:

public class ListSelectionToolPart : WebPartPages.ToolPart
{
  private SPWeb _web;
  protected DropDownList ddlLists;

  public New(SPWeb Web, string ToolTitle)
  {
    _web = System.Web;
    this.Title = ToolTitle;
  }

  protected override void CreateChildControls()
  {
        Literal litLists = new Literal { Text = "<b>List:</b><br />" };
        ddlLists = new DropDownList {
        AutoPostBack = true,
        ID = "ddlLists"
        };
        ddlLists.Style.Add("width", "100%");
        foreach (SPList list in _web.Lists)
        {
         ddlLists.Items.Add(new ListItem(list.Title, list.ID.ToString()));
        }
        this.Controls.Add(litLists);
        this.Controls.Add(ddlLists);
  }

  public override void ApplyChanges()
  {
    (this.ParentToolPane.SelectedWebPart as MyWebPart).TargetListGUID = ddlLists.SelectedValue;
  }

}

The above code assumes the name of your WebPart is MyWebPart and that there is a TargetListGUID property. To add a site selection you can do pretty much the same thing in the toolpart (add another dropdownlist). If you use the SelectionChanged event on it you can use it to populate the lists dropdown.

Best Answer

Related Solutions

C# – Access list data through SharePoint Web Part

C# – Custom property editor for Web parts in SharePoint

Related Topic