link multiple stored procedures to one gridview
-
Hi, I have a gridview for scheduling releases of hotfixes and software plugins.I need to use 3 different stored procedures: 1.a stored procedure to populate the Header of the Grid. The heading names come from a table 2.Another stored procedure to set the background colors of the cells of the gridview (Red,green, amber) based on the status of a project. This data i.e. color names (e.g. #FFFFFF, #BB00CC etc..) are stored in a table and are to be used based on project status which is stored in another table and joined with a foreign key constraint. 3.I need a third procedure that displays the values, i.e. release Dates in each cell based on a few select statements, where clauses and parameters. Can someone kindly guide me a way to achieve this? the project was developed in Classic ASP and needs to redeveloped in ASP.net2.0 Thanks in advance, Aartee. ...HE is watching Us All!
-
Hi, I have a gridview for scheduling releases of hotfixes and software plugins.I need to use 3 different stored procedures: 1.a stored procedure to populate the Header of the Grid. The heading names come from a table 2.Another stored procedure to set the background colors of the cells of the gridview (Red,green, amber) based on the status of a project. This data i.e. color names (e.g. #FFFFFF, #BB00CC etc..) are stored in a table and are to be used based on project status which is stored in another table and joined with a foreign key constraint. 3.I need a third procedure that displays the values, i.e. release Dates in each cell based on a few select statements, where clauses and parameters. Can someone kindly guide me a way to achieve this? the project was developed in Classic ASP and needs to redeveloped in ASP.net2.0 Thanks in advance, Aartee. ...HE is watching Us All!
The first two you would need to call and then use the returned values to set properties on the control, the third you would get a table back and data bind in the usual way.
Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
-
The first two you would need to call and then use the returned values to set properties on the control, the third you would get a table back and data bind in the usual way.
Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
Hi Christian, Thanks a lot for your time in reading my post and replying to it. I'm still struggling with populating the header of the gridview from the table. My table structure is : ____________________ PhaseId PhaseName ____________________ 1 Scope Closure 2 Functional Design 3 Techical Design 4 Alpha Testing 5 Beta Testing 6 UAT In the header of the gridview I need: =================================================================================================== TemplateHeader1 | TemplateHeader2 | Scope Closure | Func. Design | Tech Design | Alpha | Beta | UAT ==================================================================================================== TeamplateHeader1 & TemplateHeader2 are template columns for checkbox and label. Scope Closure onwards come from the table. Also, The colors for the cells from 'scope Closure' to 'UAT' have to come from the PhaseColor table depending upon the status of phase e.g. AtRisk=Red color, OnTrack=green color etc... first two Template columns and their cells have to stay white or whatever the grids background color is. Is gridview right for such functionality?or is there another alternative to it? In classic ASP the previous person has used elements to achieve the desired result. Thanks for your help once again.
Aartee. ...HE is watching Us All!