This is a migrated thread and some comments may be shown as answers.

Programmatic Declare SessionParameters for AspSqlDataSource

1 Answer 51 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Bruno asked on 23 Mar 2009, 08:01 PM

I need to create dynamically a Grid strutucture with 3 level hyerarchy

how can I set the SessionParameters in C#

my code is looking like:

    
            private void DefineGridStructure(string VQuery1,string VDataKey1,string VQuery2,string VDataKey2) 
        
                { 
        
                    string connString = ConfigurationManager.ConnectionStrings["coelbaConnectionString"].ConnectionString; 
        
                    SqlDataSource DataSource1 = new SqlDataSource(connString, VQuery1.ToString()); 
        
                    DataSource1.ID = "SqlDataSource1"; 
        
                    this.PlaceHolder1.Controls.Add(DataSource1); 
        
                    RadGrid RadGrid1 = new RadGrid(); 
        
                    RadGrid1.ID = "RadGrid1"; 
        
                    RadGrid1.DataSourceID = "SqlDataSource1"; 
        
                    RadGrid1.MasterTableView.DataKeyNames = new string[] { VDataKey1 }; 
        
                    RadGrid1.Width = Unit.Percentage(98); 
        
                    RadGrid1.PageSize = 40; 
        
                    RadGrid1.AllowPaging = true; 
        
                    RadGrid1.AllowSorting = true; 
        
                    RadGrid1.PagerStyle.Mode = GridPagerMode.NextPrevAndNumeric; 
        
                    RadGrid1.PagerStyle.Position = GridPagerPosition.TopAndBottom; 
        
                    RadGrid1.PagerStyle.NextPagesToolTip = "Próximas páginas"; 
        
                    RadGrid1.PagerStyle.PrevPagesToolTip = "Páginas anteriores"; 
        
                    RadGrid1.PagerStyle.NextPageText = "Próxima página"; 
        
                    RadGrid1.PagerStyle.PrevPageToolTip = "Página Anterior"; 
        
                    RadGrid1.AutoGenerateColumns = true; 
        
                    RadGrid1.ShowStatusBar = true; 
        
                    RadGrid1.ShowFooter = true; 
        
                    RadGrid1.Skin = "Sunset"; 
        
                    RadGrid1.MasterTableView.PageSize = 40; 
        
                    RadGrid1.MasterTableView.AllowMultiColumnSorting = true; 
        
                    if (VQuery2 != "") 
        
                    { 
        
                        SqlDataSource DataSource2 = new SqlDataSource(connString, VQuery2); 
        
                        DataSource2.ID = "SqlDataSource2"; 
        
                        SessionParameter nummes = new SessionParameter("@nummes", System.Data.DbType.Int32,"nummes"); 
        
                        DataSource2.SelectParameters.Add(nummes); 
        
                        this.PlaceHolder1.Controls.Add(DataSource2); 
        
                        //Detail table - Orders (II in hierarchy level) 
        
                        GridTableView tableViewOrders = new GridTableView(RadGrid1); 
        
                        tableViewOrders.DataSourceID = "SqlDataSource2"; 
        
                        tableViewOrders.Width = Unit.Percentage(100); 
        
                        tableViewOrders.DataKeyNames = new string[] { VDataKey2 }; 
        
                        tableViewOrders.AutoGenerateColumns = true; 
        
                        GridRelationFields relationFields = new GridRelationFields(); 
        
                        relationFields.MasterKeyField = VDataKey1; 
        
                        relationFields.DetailKeyField = VDataKey1; 
        
                        tableViewOrders.ParentTableRelation.Add(relationFields); 
        
                        RadGrid1.MasterTableView.DetailTables.Add(tableViewOrders); 
        
                    } 
        
                    this.PlaceHolder1.Controls.Add(RadGrid1); 
        
                }

And I´m Calling with:

    
            DefineGridStructure("exec sp_totalAnoMes", "nummes", "exec sp_relPorData", "datakey");

But the parameters are not being supplied.

1 Answer, 1 is accepted

answered on 26 Mar 2009, 08:44 PM

Hello Bruno~2c~3cbr /~3e ~3cbr /~3e I~27m sorry to hear you~27re having trouble with the RadGrid and data binding. Let me see if I can help.~3cbr /~3e ~3cbr /~3e It sounds like the main challenge you~27re having is setting parameters on your declarative data source controls. In general~2c when you set parameters for a SqlDataSource~2c you do not need to include the ~22@~22 symbol in front of the parameter name. The data control will automatically try to append a ~22@~22 sign to your parameter names.~3cbr /~3e ~3cbr /~3e Try removing the ~22@~22 from ~22@nummes~22 and see if that helps. Otherwise~2c your scenario should work assuming you are placing a value in Session that matches the session key you specify. If you continue to have trouble~2c let me know and I~27ll be happy to send a working demo project.~3cbr /~3e ~3cbr /~3e Thanks~21~3cbr /~3e -Todd ~3cdiv style~3d~22font-size~3a 10px~3b padding-top~3a 10px~3b~22~3e ~3ca href~3d~22http~3a//www.aspnetpro.com/awards/default.asp~22~3e~3cimg title~3d~22Vote For Telerik Products~22 alt~3d~22Vote For Telerik Products~22 src~3d~22http~3a//www.telerik.com/images/Forum/VoteIn.jpg~22 /~3e~3c/a~3e~3cbr /~3e Check out ~3ca href~3d~22http~3a//www.telerik.com/support/teleriktrainer.aspx~22 target~3d~22_blank~22 style~3d~22color~3a gray~3b~22~3e Telerik Trainer~3c/a~3e ~2c the state of the art learning tool for Telerik products. ~3c/div~3e