public override bool CreateExcelFile(CompositeDataBoundControl dataBound, string filename, HttpResponse Response)
{
try
{
GridView gv = (GridView)dataBound;
this.RemoveHeaderFormat(gv);
System.Text.StringBuilder sb = new System.Text.StringBuilder();
StringWriter sw = new StringWriter(sb);
HtmlTextWriter htw = new HtmlTextWriter(sw);
Page page = new Page();
HtmlForm form = new HtmlForm();
gv.EnableViewState = false;
page.EnableEventValidation = false;
page.DesignerInitialize();
page.Controls.Add(form);
form.Controls.Add(gv);
page.RenderControl(htw);
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment;filename=" + filename + ".xls");
Response.Charset = "UTF-8";
sb = sb.Replace("<caption>", string.Empty).Replace("Resultado", string.Empty).Replace("</caption>", string.Empty);
Response.Write(sb.ToString());
Response.End();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public TableDataSource(Control parent, CompositeDataBoundControl boundcontrol)
: base(typeof(TableDataSource.DataTable).FullName, "GetTable")
{
//TypeName = this.GetType().AssemblyQualifiedName;
this.ID = String.Concat(parent.ID, "SortableDataTable1");
parent.Controls.Add(this);
boundcontrol.DataSourceID = this.ID;
}
public static void SelectDataSourceAndBind(CompositeDataBoundControl gvGeneric, IEnumerable sortedDataSource, IEnumerable orginalDataSource, GridViewSortEventArgs e)
{
if (sortedDataSource != null)
{
if (sortedDataSource.GetType().Name != Const.ListTypeName)
{
gvGeneric.DataSource = sortedDataSource.Cast <object>().ToList();
}
else
{
gvGeneric.DataSource = sortedDataSource;
}
}
else
{
gvGeneric.DataSource = SortingHelper.GetSortedObjects(e, orginalDataSource.Cast <object>(), null);
}
gvGeneric.DataBind();
}
public static void BindToControl(CompositeDataBoundControl dataBoundControl, object bindableObject)
{
dataBoundControl.DataSource = bindableObject;
dataBoundControl.DataBind();
}
public TableDataSource(Control parent, CompositeDataBoundControl boundcontrol, T dt)
: this(parent, boundcontrol)
{
this.dt = dt;
}
public abstract bool CreateExcelFile(CompositeDataBoundControl dataBound, string filename, HttpResponse Response);
protected override void Render(HtmlTextWriter writer)
{
CompositeDataBoundControl slideDiv = this;
HtmlGenericControl pictureDiv = new HtmlGenericControl("div");
pictureDiv.ID = "pic";
HyperLink slideHyperlink = new HyperLink();
slideHyperlink.ID = "linkSlide";
Image slideImage = new Image();
slideImage.ID = "slideImage";
HtmlGenericControl titleSlideDiv = new HtmlGenericControl("div");
titleSlideDiv.ID = "titleSlide";
slideHyperlink.Controls.Add(slideImage);
slideHyperlink.Controls.Add(titleSlideDiv);
pictureDiv.Controls.Add(slideHyperlink);
HtmlGenericControl textSlideDiv = new HtmlGenericControl("div");
textSlideDiv.ID = "textSlide";
pictureDiv.Controls.Add(textSlideDiv);
HtmlGenericControl navDiv = new HtmlGenericControl("div");
navDiv.ID = "nav";
if (Items.Count > 0)
{
HtmlGenericControl pageUl = new HtmlGenericControl("ul");
if (this.PagerSettings.Mode == PagerButtons.NextPrevious || this.PagerSettings.Mode == PagerButtons.NextPreviousFirstLast)
{
HtmlGenericControl previousLi = new HtmlGenericControl("li");
HyperLink previousHyperlink = new HyperLink();
previousHyperlink.NavigateUrl = "#";
previousHyperlink.Attributes.Add("onclick", this.ClientID + ".previous()");
previousHyperlink.Text = PagerSettings.PreviousPageText;
previousLi.Controls.Add(previousHyperlink);
pageUl.Controls.Add(previousLi);
}
for (int i = 1; i <= Items.Count; i++)
{
HtmlGenericControl itemLi = new HtmlGenericControl("li");
HyperLink itemHyperlink = new HyperLink();
itemHyperlink.NavigateUrl = "#";
itemHyperlink.Attributes.Add("onclick", this.ClientID + ".position(" + (i - 1) + ")");
itemHyperlink.Text = i.ToString();
itemLi.Controls.Add(itemHyperlink);
pageUl.Controls.Add(itemLi);
}
if (this.PagerSettings.Mode == PagerButtons.NextPrevious || this.PagerSettings.Mode == PagerButtons.NextPreviousFirstLast)
{
HtmlGenericControl nextLi = new HtmlGenericControl("li");
HyperLink nextHyperlink = new HyperLink();
nextHyperlink.NavigateUrl = "#";
nextHyperlink.Attributes.Add("onclick", this.ClientID + ".next()");
nextHyperlink.Text = PagerSettings.NextPageText;
nextLi.Controls.Add(nextHyperlink);
pageUl.Controls.Add(nextLi);
}
navDiv.Controls.Add(pageUl);
}
slideDiv.Controls.Add(pictureDiv);
slideDiv.Controls.Add(navDiv);
if (!this.DesignMode)
{
HtmlGenericControl itemsDiv = new HtmlGenericControl("div");
itemsDiv.ID = "items";
for (int i = 0; i < Items.Count; i++)
{
SlideShowItem item = Items[i];
HtmlGenericControl itemDiv = new HtmlGenericControl("div");
itemDiv.ID = "item" + i;
itemDiv.Attributes.Add("image", item.ImageUrl);
itemDiv.Attributes.Add("href", (string.IsNullOrEmpty(item.NavigateUrl) ? "#" : Page.ResolveUrl(item.NavigateUrl)));
itemDiv.Attributes.Add("title", item.Title);
itemDiv.InnerText = item.Description;
itemsDiv.Controls.Add(itemDiv);
}
slideDiv.Controls.Add(itemsDiv);
}
this.RenderBeginTag(writer);
this.RenderChildren(writer);
this.RenderEndTag(writer);
}