DeMuy
Last Activity: Dec 23 '09, 01:44 PM
Joined: Oct 28 '09
Location:
-
Thank you all for your assistance. -
Thank you for your feedback.
The column names Qty1, Qty2, Qty3, etc. are created by ASP.NET gridview control, they are Qty,Qty,Qty from the database side.
How do you specify individual column names when the SQL query itself is dynamic?Leave a comment:
-
I am not sure if I have made myself clear enough, anyway, I have a gridview where I need to have column names within the gridview to have the same name, but when I set up the sql query as
select SUM(case when order_month = 2 Then Qty ELSE 0.00 END) AS Qty,
SUM(case when order_month = 3 Then Qty ELSE 0.00 END) AS Qty,
SUM(case when order_month = 4 Then Qty ELSE 0.00 END) AS Qty,
etc
and it...Leave a comment:
-
ASP.NET 2.0 Problem with column name changing in a Gridview control
I have a gridview with AutoGenerateCol umns=true that is presenting a challenge to me.
Challenge #1
The data structure from the database server follows:
Product |Qty |Jan-09|Qty|Feb-09|Qty|Mar-09 etc
-----------------------------------------------------------------
CD|1.00 |$100.00|5.00|$ 500.00|7.00|$70 0.00 etc
DVD|2.00 |$400.00|7.00|$ 700.00|8.00|$80 0.00 etc
****** But the gridview...
No activity results to display
Leave a comment: