Get SPLinked list Data and Bind it a Visual Webpart
private void GetMoreEvents()
{
using (SPSite osite = new SPSite(SPContext.Current.Web.Url))
{
using (SPWeb oweb = osite.OpenWeb())
{
SPList olist = oweb.Lists.TryGetList("More Events");
SPListItemCollection collListItems = olist.Items;
DataTable dt = new DataTable();
dt.Columns.Add("Attachments", typeof(string));
dt.Columns.Add("Title", typeof(string));
dt.Columns.Add("Description", typeof(string));
dt.Columns.Add("URL", typeof(string));
foreach (SPListItem item in collListItems)
{
DataRow dr = dt.NewRow();
string attachmentAbsoluteURL = string.Empty;
foreach (String attachmentname in item.Attachments)
{
attachmentAbsoluteURL = item.Attachments.UrlPrefix + attachmentname;
}
dr["Attachments"] = attachmentAbsoluteURL.ToString();
dr["Title"] = item["Title"] != null ? item["Title"].ToString() : string.Empty;
if (item["Description"] != null && item["Description"].ToString().Length >= 400)
{
dr["Description"] = item["Description"].ToString().PadRight(400).Substring(0, 400).TrimEnd() + "<a href=\"url\" >...More</a>";
//HyperLink hpLink = new HyperLink();
//hpLink.Visible = true;
//hpLink.NavigateUrl = "..More";
//hpLink.Text = item["Description"].ToString().PadRight(400).Substring(0, 400).TrimEnd();
//hpLink.ToolTip = item["Description"].ToString();
//dr["Description"] = item["Description"].ToString().PadRight(400).Substring(0, 400).TrimEnd() + hpLink.NavigateUrl;
}
else
{
dr["Description"] = item["Description"] != null ? item["Description"].ToString() : string.Empty;
}
dr["URL"] = item["URL"] != null ? item["URL"].ToString() : string.Empty;
dt.Rows.Add(dr);
}
gvMoreEvents.DataSource = dt;
gvMoreEvents.DataBind();
}
}
}
{
using (SPSite osite = new SPSite(SPContext.Current.Web.Url))
{
using (SPWeb oweb = osite.OpenWeb())
{
SPList olist = oweb.Lists.TryGetList("More Events");
SPListItemCollection collListItems = olist.Items;
DataTable dt = new DataTable();
dt.Columns.Add("Attachments", typeof(string));
dt.Columns.Add("Title", typeof(string));
dt.Columns.Add("Description", typeof(string));
dt.Columns.Add("URL", typeof(string));
foreach (SPListItem item in collListItems)
{
DataRow dr = dt.NewRow();
string attachmentAbsoluteURL = string.Empty;
foreach (String attachmentname in item.Attachments)
{
attachmentAbsoluteURL = item.Attachments.UrlPrefix + attachmentname;
}
dr["Attachments"] = attachmentAbsoluteURL.ToString();
dr["Title"] = item["Title"] != null ? item["Title"].ToString() : string.Empty;
if (item["Description"] != null && item["Description"].ToString().Length >= 400)
{
dr["Description"] = item["Description"].ToString().PadRight(400).Substring(0, 400).TrimEnd() + "<a href=\"url\" >...More</a>";
//HyperLink hpLink = new HyperLink();
//hpLink.Visible = true;
//hpLink.NavigateUrl = "..More";
//hpLink.Text = item["Description"].ToString().PadRight(400).Substring(0, 400).TrimEnd();
//hpLink.ToolTip = item["Description"].ToString();
//dr["Description"] = item["Description"].ToString().PadRight(400).Substring(0, 400).TrimEnd() + hpLink.NavigateUrl;
}
else
{
dr["Description"] = item["Description"] != null ? item["Description"].ToString() : string.Empty;
}
dr["URL"] = item["URL"] != null ? item["URL"].ToString() : string.Empty;
dt.Rows.Add(dr);
}
gvMoreEvents.DataSource = dt;
gvMoreEvents.DataBind();
}
}
}
Comments