Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Printing Gridview with LOTS of columns

Reply
Thread Tools

Printing Gridview with LOTS of columns

 
 
Ralf
Guest
Posts: n/a
 
      10-29-2008
I have a custome request to print a gridview with lots of columns, 31
to be exact. I know how to print out a gridview, done it already for
a GV with 6 columns. But, this GV is very wide and will not fit on a
page. I looked into using a repeater, but couldn't figure it out.
Tried datalists, no luck.
Does anybody have an idea of how I can output the data where it will
print. It doesn't have to output into a gridview, I just need it
printable...
 
Reply With Quote
 
 
 
 
Alexey Smirnov
Guest
Posts: n/a
 
      10-29-2008
On Oct 29, 2:20*pm, Ralf <(E-Mail Removed)> wrote:
> I have a custome request to print a gridview with lots of columns, 31
> to be exact. *I know how to print out a gridview, done it already for
> a GV with 6 columns. *But, this GV is very wide and will not fit on a
> page. *I looked into using a repeater, but couldn't figure it out.
> Tried datalists, no luck.
> Does anybody have an idea of how I can output the data where it will
> print. *It doesn't have to output into a gridview, I just need it
> printable...


Ralf, using Repeater with a nested GridView is quite easy. Here's an
example I used to show list of brochures by categories. The result
list looks in the following way:

Category1
.....col1....col2....col3
.....col1....col2....col3
.....col1....col2....col3
Category 2
.....col1....col2....col3
.....col1....col2....col3
.....col1....col2....col3

This is done by using Repeater with a nested GridView:

<asp:Repeater ID="Repeater1" runat="server"
OnItemDataBound="Repeater1_ItemDataBound">
<ItemTemplate>
<div>
<asp:Label ID="lblCategoryName" runat="server" Text='<%#
Eval("BrochureCategoryName") %>' />
</div>
<div>

<asp:GridView ID="GridView1" runat="server" DataKeyNames="BrochureId">
<Columns>
<asp:TemplateField>
<ItemTemplate>

....

</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>

</div>
</ItemTemplate>
</asp:Repeater>

A code to populate GridView could be as a following

private void BindData()
{

DataSet ds = (DataSet)db.ExecuteDataSet(string.Format(
@"SELECT * FROM BrochureCategory;
SELECT b.* FROM Brochure b, BrochureCategory c
WHERE b.BrochureCategoryId=c.BrochureCategoryId", _websiteId)
);

// Attach the relationship to the dataSet
ds.Relations.Add(new DataRelation("CategoriesRelation",
ds.Tables[0].Columns["BrochureCategoryId"],
ds.Tables[1].Columns["BrochureCategoryId"]));

Repeater1.DataSource = ds.Tables[0];
Repeater1.DataBind();

}

protected void Repeater1_ItemDataBound(object sender,
RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType ==
ListItemType.AlternatingItem)
{
DataRowView drv = e.Item.DataItem as DataRowView;

GridView GridView1 = e.Item.FindControl("GridView1") as GridView;
GridView1.DataSource = drv.CreateChildView("CategoriesRelation");
GridView1.DataBind();
}
}

When you have many colums you have to find how you could rearrange the
view. Maybe you can follow my example and show one or more "main"
columns as a Repeater data rows and the rest could be nested using a
GridView control.

Category1 Name1 Name2
Description......
.....col1....col2....col3
.....col1....col2....col3
.....col1....col2....col3

or

Category1 Name1 Name2
Description......
.....col1=val1
.....col2=val2
.....col3=val3
.....col4=val4
.....col5=val5
 
Reply With Quote
 
 
 
 
Ralf
Guest
Posts: n/a
 
      10-29-2008

>
> Category1 Name1 Name2
> Description......
> ....col1=val1
> ....col2=val2
> ....col3=val3
> ....col4=val4
> ....col5=val5


This is a possiblity of doing it this way. I would list the row
identifier in at the Top, and then have the col1=val like you have it
to show all the data. It doesn't matter if it runs multiple pages for
each row. I will give this a try, probably tomorrow and post my
results. Thx

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking for lots of words in lots of files brad Python 9 06-19-2008 07:59 AM
template columns and bound columns in gridview Vinki ASP .Net Web Controls 2 04-25-2007 04:22 PM
Downloading lots and lots and lots of files coolneo Perl Misc 9 01-30-2007 02:34 PM
MySQLdb, lots of columns and newb-ness Andrew Sackville-West Python 5 12-20-2006 06:51 PM
Align table columns with gridview columns Jacksm ASP .Net 2 11-21-2006 09:49 PM



Advertisments