About the data binding problem after crosstab query!

叽里呱啦1

I have a table with fields like number, name, date ... etc., implemented by cross table query

 2017-1-1 2017-1-2 2017-1-3 2017-1-4 ...
No.Name Name Name Name ...
No.Name Name Name Name ...
No.Name Name Name Name ...
...

The cross-table query is now complete and can be directly bound to GRIDVIEW. But there is a problem, my number field is a number from 1 to 16, and the order is from low to high. If it is bound to GRIDVIEW, if there is no one of the numbers in the database, the bound GRIDVIEW does not have that row, but my table has a number and an empty row even if there is no row. Do you have any suggestions?

I know that it is possible to bind cells through FLEXGRID, but the current FLEXGRID of WEB does not come with VS2005. Things like ASP.NET2.0 are neither open source nor free, which is more troublesome. If I use TABLE or DIV, I don't know how to draw.

叽里呱啦1

The result after binding is to be printed out. After reading the discussion in the forum, the WEB printing is very troublesome, or you can export to Excel for printing. Either through the report, but the crystal report is not very good, can I say that the crystal report is achieved? Thank you

叽里呱啦1

Is everyone off on New Year's Day? Nobody? ? ?

lisongfox

This is still good to deal with in the cross-table query

fanfan1980

--try

(
select number = 1
union all select 2
union all select 3
union all select 4

...

union all select 16
) A
left join (result set generated by dynamic SQL) B on A. number = B. number

fanfan1980

--sorry, missed some

select * from
(
select number = 1
union all select 2
union all select 3
union all select 4

...

union all select 16
) A
left join (result set generated by dynamic SQL) B on A. number = B. number

xx521xx

Support upstairs practices.

iamsexdog

Automatically populate a GridView with a fixed number of rows
http://dotnet.aspx.cc/article/ee911c00-0e99-4e50-a941-3defa599ef48/read.aspx

叽里呱啦1

Thank you, a few people upstairs, and again, the vertical column of my cross table only shows one day, according to the corresponding number to display multiple columns, more than one name, is it ok?