Dynamically Create Rows and columns in datalist or Gridview | The ASP.NET Forums
ASP.NET Forums/General ASP.NET/Web Forms Data Controls/Dynamically Create Rows and columns in datalist or Gridview
Dynamically Create Rows and columns in datalist or GridviewRSS
Last post Sep 24, 2008 10:48 PM by Qin Dian Tang - MSFT
Dynamically Create Rows and columns in datalist or Gridview
Sep 19, 2008 07:05 AM|Rajneesh Verma|LINK
Sir, I want to display graph type data which comes from tables with some conditions in which i want to show x and y axis and want to fix rupees in y axis and date in x axis means i want to fix rows on page load and columns according to date from database i am showing taht data like this
7. 0 x 0 x
6. 0 x x 0 x x 0
5. 0 x x 0 x 0 0
4. x 0 x 0 0
3. x 0 0
here rupees from 1 to 9 shows in y axis and date in x axis from 11 to 19. and o and x are images which i want to show............
i don't know how we can do it ......... any suggestion please share with me........
your most welcome........................... thanks...............
Re: Dynamically Create Rows and columns in datalist or Gridview
Sep 22, 2008 12:37 AM|Rajneesh Verma|LINK
Hello Is there any one who can solve my problem..... Hello frnds..... Please help me.............
Waiting for response.........................??????????????????
Sep 22, 2008 08:09 AM|Rajneesh Verma|LINK
Hello is there any one who can try to solve my problem.......... Try to solve it please.... is there any problem to understand... then tell us i can try to clearfy more.. that what i want but pls reply ...........!!!!!!!!!!!!! pls....
sangeeta chh...
Sep 22, 2008 08:16 AM|sangeeta chhabra|LINK
Give more clarification and send thevc code,if tried some thing.So that we can modify that....
Sep 22, 2008 08:35 AM|Rajneesh Verma|LINK
Acctually i dont have code but if i can able to increase rows and columns of grid view or listview at run time then i can do it. i want that all rows of grid/list will bw created at time of page load with 1 column.whish has image as named 00,10,20,30,40 . of 0 to 4 rows and 0 columns if we change date then it will turn as 01,11,21,31,41 and so on....and according database values i can change the image of that perticular image field... if any doubt please tell us.. thanks 4 interest..................Thanks
Sep 24, 2008 01:54 AM|Qin Dian Tang - MSFT|LINK
I think sql cross tab query can help you:
Sep 24, 2008 02:01 AM|Krishna_Sridharan|LINK
sorry i could nt get your point fully.
But y dont u use crystal report's graph option to display the data in the format of line graph, bar graph and all.?
Sep 24, 2008 09:42 AM|Rajneesh Verma|LINK
Actually I want to use it as a Share Market values but till noe i have only hard copy data in excel format where date and high and low of that date should be printed as X and 0 according to some conditions i thind this Dynamic cross table can help me out .... but if any one has any idea ... Please Share with me Your most Wellcom............ Thanks
Sep 24, 2008 10:48 PM|Qin Dian Tang - MSFT|LINK
I think you can use cross tab query to do your project. For example, you have a table with several fields (Date: 11,12,13,..., Rupee: 1,2,3,..., field:X,O, **). Then you can use this sql:
select Rupee,[11],[12],[13],[14],[15],[16],[17],[18],[19]" from (select Date,field,Rupee from [table]) as a" pivot (max(field) for Date in ([11],[12],[13],[14],[15],[16],[17],[18],[19])) as b
Bind it to GridView with BoundField (set FooterText="11", ...).
Dynamically Create Rows and columns in datalist or Gridview | The ASP.NET Forums
ASP.NET Forums/General ASP.NET/Web Forms Data Controls/Dynamically Create Rows and columns in datalist or Gridview
Dynamically Create Rows and columns in datalist or GridviewRSS
Last post Sep 24, 2008 10:48 PM by Qin Dian Tang - MSFT
Dynamically Create Rows and columns in datalist or Gridview
Sep 19, 2008 07:05 AM|Rajneesh Verma|LINK
Sir, I want to display graph type data which comes from tables with some conditions in which i want to show x and y axis and want to fix rupees in y axis and date in x axis means i want to fix rows on page load and columns according to date from database i am showing taht data like this
7. 0 x 0 x
6. 0 x x 0 x x 0
5. 0 x x 0 x 0 0
4. x 0 x 0 0
3. x 0 0
here rupees from 1 to 9 shows in y axis and date in x axis from 11 to 19. and o and x are images which i want to show............
i don't know how we can do it ......... any suggestion please share with me........
your most welcome........................... thanks...............
Re: Dynamically Create Rows and columns in datalist or Gridview
Sep 22, 2008 12:37 AM|Rajneesh Verma|LINK
Hello Is there any one who can solve my problem..... Hello frnds..... Please help me.............
Waiting for response.........................??????????????????
Sep 22, 2008 08:09 AM|Rajneesh Verma|LINK
Hello is there any one who can try to solve my problem.......... Try to solve it please.... is there any problem to understand... then tell us i can try to clearfy more.. that what i want but pls reply ...........!!!!!!!!!!!!! pls....
sangeeta chh...
Sep 22, 2008 08:16 AM|sangeeta chhabra|LINK
Give more clarification and send thevc code,if tried some thing.So that we can mo
dify that....
Sep 22, 2008 08:35 AM|Rajneesh Verma|LINK
Acctually i dont have code but if i can able to increase rows and columns of grid view or listview at run time then i can do it. i want that all rows of grid/list will bw created at time of page load with 1 column.whish has image as named 00,10,20,30,40 . of 0 to 4 rows and 0 columns if we change date then it will turn as 01,11,21,31,41 and so on....and according database values i can change the image of that perticular image field... if any doubt please tell us.. thanks 4 interest..................Thanks
Sep 24, 2008 01:54 AM|Qin Dian Tang - MSFT|LINK
I think sql cross tab query can help you:
Sep 24, 2008 02:01 AM|Krishna_Sridharan|LINK
sorry i could nt get your point fully.
But y dont u use crystal report's graph option to display the data in the format of line graph, bar graph and all.?
Sep 24, 2008 09:42 AM|Rajneesh Verma|LINK
Actually I want to use it as a Share Market values but till noe i have only hard copy data in excel format where date and high and low of that date should be printed as X and 0 according to some conditions i thind this Dynamic cross table can help me out .... but if any one has any idea ... Please Share with me Your most Wellcom............ Thanks
Sep 24, 2008 10:48 PM|Qin Dian Tang - MSFT|LINK
I think you can use cross tab query to do your project. For example, you have a table with several fields (Date: 11,12,13,..., Rupee: 1,2,3,..., field:X,O, **). Then you can use this sql:
select Rupee,[11],[12],[13],[14],[15],[16],[17],[18],[19]" from (select Date,field,Rupee from [table]) as a" pivot (max(field) for Date in ([11],[12],[13],[14],[15],[16],[17],[18],[19])) as b
Bind it to GridView with BoundField (set FooterText="11", ...).