Skip to content

Infragistics Community Forum / Desktop / Ultimate UI for ASP.NET Web Forms / Sys.ArgumentException: Value must not be null for Controls and Behaviors. Parameter name: element

Sys.ArgumentException: Value must not be null for Controls and Behaviors. Parameter name: element

New Discussion
Charles
Charles asked on Jun 30, 2016 8:14 PM

Hello,

I have just upgraded from WebClient controls version 10.1 to 10.2 and my previous flawless WebHierarchicalDataGrid now breaks after paging with a clientside error from the ajax include file. MicrosoftAjax.debug.js  Assembly:
System.Web.Extensions Version: 3.5.0.0 FileVersion: 3.5.30729.1

Error is: Sys.ArgumentException: Value must not be null for
Controls and Behaviors. Parameter name: element

At: if (!element) throw Error.argument(‘element’, Sys.Res.createNoDom);

I have a two level parent-child relationship. Paging is set to 25 items. Steps to reproduce: Expand a parent with one page of children works fine. Expand a parent with multiple pages of children works fine for initially. Once I page (click page 2) and result come back fine. The error occurs in trying to expand a parent above the recently paged parent. It consistently errors in the ajax script file.

The tested the same data from the same project one week ago but with the version 10.1 controls and no such error occurs.

As an aside, I am using InitialDataBindDepth of -1. When I change the value to 0 (load on demand) I get the error: “Deserialization failure: Invalid
response.” This error will occur after expanding a parent with multiple pages of children, expanding a parent with one page of children and then trying to re-expand the parent with multiple children. No paging action is needed to reproduce the error in this scenario.

Anyone please advise as this is a roadblock and a full day of research has come up empty so far.

Thanks,

Charlie

Sign In to post a reply

Replies

  • 0
    [Infragistics]Lyuba
    [Infragistics]Lyuba answered on Jul 5, 2010 6:48 AM

    Hello Charles,

     

    I have created a support ticket regarding this issue. Its number is CAS-48854-J7R4KY.

     

    Regards,

    Lyuba

    Developer Support Engineer

    Infragistics

    http://es.infragistics.com/support

     

    • 0
      Ali
      Ali answered on Sep 14, 2010 9:59 PM

      I get the same js error when paging in webdatagrid in 2009.2.2037 –

      Microsoft JScript runtime error: Sys.ArgumentException: Value must not be null for Controls and Behaviors.

      If I remove all EditorProviders for the webdatagrid, this error goes away.

      Anyone has a solution?

      IE 6. (sorry, company mandated dinosaur browser).

      • 0
        Ali
        Ali answered on Sep 14, 2010 10:00 PM

        Build 9.2.20092.2137

      • 0
        Ali
        Ali answered on Sep 14, 2010 10:15 PM

        Ok, this might be an IE 6 thing. Firefox works just fine, no javascript errors. Anyone has a quick fix for IE6?

      • 0
        Grasshoper
        Grasshoper answered on Sep 28, 2010 2:43 PM

        I got the same error any resolution?

  • 0
    Charles
    Charles answered on Nov 16, 2010 1:40 PM

    This appears to be resolved in the latest service release for version 10.2.

    • 0
      Clay
      Clay answered on Dec 19, 2010 5:19 PM

      Not so fast.  I'm using WebDataGrid 10.3 with the following and I'm getting the error:

       

       

       

       

       

       

       

       

       

       

       

      <EditorProviders>
          <ig:DropDownProvider ID="TerritoryProvider">
              <EditorControl ID="EditorControl1" runat="server"
        DataSourceID="SqlDataSource2" DisplayMode="DropDownList"
                  DropDownContainerMaxHeight="300px" EnableAnimations="True"
                  TextField="mktgrpkey" ValueField="mktgrpname"
                  EnableDropDownAsChild="False" DropDownContainerHeight="300px" >
                  <DropDownItemBinding TextField="mktgrpkey" ValueField="mktgrpname">
                  </DropDownItemBinding>
              </EditorControl>
          </ig:DropDownProvider>
      </EditorProviders>

      <ig:CellEditing  Enabled="true" >
          <ColumnSettings>
                  <ig:EditingColumnSetting ColumnKey="Territory" EditorID="TerritoryProvider" />
          </ColumnSettings>
      </ig:CellEditing>

      Please advise on how to correct.

  • 0
    [Infragistics]Lyuba
    [Infragistics]Lyuba answered on Dec 20, 2010 2:12 PM

    Hello ClaySeifert,

     

    Would you please test it with the latest service release: 10.3.20103.2046.

    If you are still getting this error with it, would you please attach a sample and the exact steps that should be followed for reproducing this issue.

     

    Regards,

    Lyuba

    Developer Support Engineer

    Infragistics

    http://es.infragistics.com/support

     

     

    • 0
      Clay
      Clay answered on Dec 20, 2010 4:26 PM

      Hello Lyuba

      Sorry — false alarm.  I had a block of code in my markup that was commented out that was causing the error.  When I removed it, the problem cleared.  However, the code that I had commented out was for community.infragistics.com/forums/p/50123/264288.aspx#264288 that I’m still waiting to hear from someone.

      Thank you

  • 0
    M
    M answered on Jan 26, 2011 7:40 PM

    We ran into the same issue. Looking at the changes, we were running the AjaxControlToolkit.dll Version 3.0.20820.0 and upgraded to 4.1.40412.2.

    After the upgrade, this error started occuring in the WHGrid without any changes to the code base. We reverted the Tool Kit version and that solved our issue.

    Cheers

    • 0
      Chris
      Chris answered on Oct 24, 2011 9:21 PM

      I am now getting this error as well. Just updated to the latest 10.3 service release (10.3.20103.2187)

      I am binding to a datset

      Here is the grid, nothing complicated. i even took out the sorting behaviour to see if that was it, but no joy.

      <ig:WebHierarchicalDataGrid ID="whdgMatters" runat="server" EnableDataViewState="False"
               Width="90%" AutoGenerateBands="False"
              AutoGenerateColumns="False" DataKeyFields="ClientMatter" DataMember="Matters"
              Key="Matters" InitialDataBindDepth="1"  >
              <Columns>
                  <ig:BoundDataField DataFieldName="CMName" Key="CMName">
                      <Header Text="Client/Matter Name" />
                  </ig:BoundDataField>
                  <ig:BoundDataField DataFieldName="ClientMatter" Key="ClientMatter">
                      <Header Text="Client/Matter #" />
                  </ig:BoundDataField>
                  <ig:BoundDataField DataFieldName="BillableTotal" Key="BillableTotal">
                      <Header Text="Total Billed" />
                  </ig:BoundDataField>
                  <ig:BoundDataField DataFieldName="CallCount" Key="CallCount">
                      <Header Text="Calls" />
                  </ig:BoundDataField>
              </Columns>
              <Bands>
                   <ig:Band AutoGenerateColumns="False" DataMember="Calls">
                      <Columns>
                      <ig:BoundDataField DataFieldName="ConferenceDateTime" DataFormatString="{0:G}"
                              Key="ConferenceDateTime">
                              <Header Text="DateTime" />
                          </ig:BoundDataField>
                          <ig:BoundDataField DataFieldName="HostName" Key="HostName">
                              <Header Text="Inputted Host" />
                          </ig:BoundDataField>
                          <ig:BoundDataField DataFieldName="HostTelephone" Key="HostTelephone">
                              <Header Text="Host Phone" />
                          </ig:BoundDataField>
                          <ig:BoundDataField DataFieldName="CallDuration"
                              Key="CallDuration">
                              <Header Text="Duration" />
                          </ig:BoundDataField>
                          <ig:BoundDataField DataFieldName="AttendeeCount"
                              Key="AttendeeCount">
                              <Header Text="# Attendees" />
                          </ig:BoundDataField>
                          <ig:BoundDataField DataFieldName="BillableAmt"
                              Key="BillableAmt" DataFormatString="{0:C}">
                              <Header Text="Amount Charged" />
                          </ig:BoundDataField>
                      </Columns>
                  </ig:Band>
              </Bands>
          </ig:WebHierarchicalDataGrid>

      • 0
        Chris
        Chris answered on Oct 24, 2011 9:27 PM

        Just to clarify, I get the error when expanding a row.

      • 0
        Chris
        Chris answered on Nov 1, 2011 7:26 PM

        Is there anything on this? PLEASE? I have tried using this same or even more simplified grid on different pages, using SqlDatasources/WebHierarchicalDatasources, removing columns to just 1 integer in the parent and 1 integer in the child, creating from scratch using the designer, etc. Nothing is working.

      • 0
        Chris
        Chris answered on Nov 7, 2011 4:47 PM

        OK. Figured it out. There was a unicode comma "," in my data, that should not have been there. But what if I have characters like that that should be there?

      • 0
        Paul
        Paul answered on Jan 4, 2012 1:15 PM

        I have been experiencing a similar problem with Infragistics 11.2.20112.1019. I am using VS 2010

        Here is the scenario:

        1. Create a dataset containing 2 datatables with appropriate relationships and primary keys; the columns forming the relationships contain strings representing dates; some of the dates have the form “1-1-2011” while some have the form “1/1/2011”.

        2.  Bind a WebHierarchicalDataGrid to the dataset.

        3. Expand the top-level rows. All the top-level rows expand correctly.

        4. Add an Ajax Control Toolkit (v 4.0) control to the form (in my case it was a PopupControlExtrender).

        5. Run the project again and attempt to expand the row containing the date form “1/1/2011”.

        6. Observe that an error, “Runtime Exception: [object error]” is displayed.

        7. Other rows expand normally.

        After some experimentation I determined that a variety of characters (/<&, etc.) will cause this behavior.

        I think it is only reasonable to expect that date fields should be able to be used as relationships between parent and child rows and that we should not have to reformat the data to please the grid.

        Here is the markup and code-behind:

        <%@ Page Language="C#" AutoEventWireup="true"
            CodeBehind="default.aspx.cs"
            Inherits="HierarchicalGridTest._default" %>
        
        <%@ Register Assembly="AjaxControlToolkit"
            Namespace="AjaxControlToolkit"
            TagPrefix="asp" %>
        
        <%@ Register Assembly="Infragistics4.Web.v11.2, Version=11.2.20112.1019, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb"
            Namespace="Infragistics.Web.UI"
            TagPrefix="ig" %>
        
        <%@ Register Assembly="Infragistics4.Web.v11.2, Version=11.2.20112.1019, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb"
            Namespace="Infragistics.Web.UI.GridControls"
            TagPrefix="ig" %>
        
        <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
            "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
        
        <html xmlns="http://www.w3.org/1999/xhtml">
        <head runat="server">
            <title>Hierarchical Grid Test</title>
        </head>
        <body>
            <form id="form1" runat="server">
        
                <ig:WebScriptManager ID="WebScriptManager1" runat="server" />
        
                <div>
                    <asp:Panel ID="Panel1" runat="server" />
        
                    <asp:PopupControlExtender ID="PopupControlExtender1"
                        runat="server"
                        PopupControlID="Panel1"
                        TargetControlID="Panel1" />
        
                    <h3>Sample Grid With Expansion</h3>
        
                    <p>
                        Note that the second parent row has forward slashes in the data of the first column.
                        This causes a client error – but only when the Ajax Toolkit has been used –
                        even if the Ajax controls are subsequently deleted from the page.
                    </p>
        
                    <ig:WebHierarchicalDataGrid ID="gridReport"
                        runat="server"
                        Height="600px"
                        Width="80%"
                        InitialDataBindDepth="0"
                        InitialExpandDepth="0">
                    </ig:WebHierarchicalDataGrid>
                </div>
        
            </form>
        </body>
        </html>
        using System;
        using System.Data;
        using Infragistics.Web.UI;
        using Infragistics.Web.UI.GridControls;
        
        namespace HierarchicalGridTest
        {
            public partial class _default : System.Web.UI.Page
            {
                protected void Page_Load(object sender, EventArgs e)
                {
                    DataSet ds = GetDummyReport();
                    LoadGrid(ds);
                }
        
                private void LoadGrid(DataSet ds)
                {
                    gridReport.InitializeBand +=
                        new InitializeBandEventHandler(gridReport_InitializeBand);
        
                    gridReport.DataMember = ds.Tables[0].TableName;
                    gridReport.Key = ds.Tables[0].TableName;
                    gridReport.DataSource = ds;
                    gridReport.DataBind();
                }
        
                protected void gridReport_InitializeBand(object sender, BandEventArgs e)
                {
                    switch (e.Band.BandIndexAddress)
                    {
                        case "0":
                            e.Band.DataKeyFields = "MONTH";
                            break;
        
                        case "0_0":
                            break;
                    }
                }
        
                private DataSet GetDummyReport()
                {
                    DataSet ds = new DataSet();
        
                    // Parent table
                    DataTable dt1 = new DataTable("Table1");
                    dt1.Columns.Add("MONTH");
                    dt1.Columns.Add("Column2");
                    dt1.Columns.Add("Column3");
        
                    dt1.Rows.Add("1-1-2011", "col2Val1", "col3Val1");
                    dt1.Rows.Add("2/2/2011", "col2Val2", "col3Val2");
                    dt1.Rows.Add("3-3-2011", "col2Val3", "col3Val3");
                    dt1.Rows.Add("4-4-2011", "col2Val4", "col3Val4");
        
                    dt1.PrimaryKey = new DataColumn[] { dt1.Columns[0] };
                    ds.Tables.Add(dt1);
        
                    // Child table
                    DataTable dt2 = new DataTable("Table2");
                    dt2.Columns.Add("MONTH");
                    dt2.Columns.Add("Column12");
                    dt2.Columns.Add("Column13");
        
                    dt2.Rows.Add("1-1-2011", "col2Val1", "col3Val1");
                    dt2.Rows.Add("1-1-2011", "col2Val2", "col3Val2");
                    dt2.Rows.Add("2/2/2011", "col2Val3", "col3Val3");
                    dt2.Rows.Add("3-3-2011", "col2Val4", "col3Val4");
        
                    dt2.PrimaryKey = new DataColumn[] { dt2.Columns[1] };
                    ds.Tables.Add(dt2);
        
                    // Relation
                    ds.Relations.Add(
                        ds.Tables[0].Columns[0],
                        ds.Tables[1].Columns[0]
                    );
        
                    return ds;
                }
            }
        }

         

  • 0
    IVAN MENDOZA
    IVAN MENDOZA answered on Jun 30, 2016 8:14 PM

    good morning, happens to me the same thing but this works for me perfectly on the development team, the problem appears when'll post on my web server, if you know of any solution would be good that compartieras in the company where I work bought package a week ago and the first project that is being done got this error, I hope that the support staff can help me quickly, I send part of the program code
       <Div style = "margin-top: 30px; font-size: 1px;">

              <Ig: WebHierarchicalDataGrid ID = "WebHierarchicalDataGrid1" runat = "server" DataSourceID = "DatoEnCascada1" Height = "500px" width = "98%" AutoGenerateBands = "False" AutoGenerateColumns = "False" DataKeyFields = "REGIONAL" DataMember = "Cadena1_DefaultView" key = "Cadena1_DefaultView">
                  <Bands>
                      <Ig: Band AutoGenerateColumns = "False" DataKeyFields = "REGIONAL CODE" DataMember = "Cadena2_DefaultView" Key = "Cadena2_DefaultView">
                          <Bands>
                              <Ig: Band AutoGenerateColumns = "False" DataMember = "Cadena3_DefaultView" Key = "Cadena3_DefaultView">
                                  <Columns>
                                            <Ig: BoundDataField DataFieldName = "NIT" Key = "NIT" Width = "10%">
                                                <Header Text = "Nit" />
                                               
                                            </ Ig: BoundDataField>
                                            <Ig: BoundDataField DataFieldName = "CUSTOMER" Key = "CUSTOMER" Width = "25%">
                                                <Header Text = "Customer Name" />
                                            </ Ig: BoundDataField>

                                            <Ig: BoundDataField DataFieldName = "VTA_HOY" Key = "VTA_HOY" Width = "10%" DataFormatString = "{0: C2}">
                                                <Header Text = "Sale Today" />
                                            </ Ig: BoundDataField>
                                            <Ig: BoundDataField DataFieldName = "VTA_AYER" Key = "VTA_AYER" Width = "10%" DataFormatString = "{0: C2}">
                                                <Header Text = "Sale Yesterday" />
                                            </ Ig: BoundDataField>
                                            <Ig: BoundDataField DataFieldName = "VTA_ACUM" Key = "VTA_ACUM" Width = "10%" DataFormatString = "{0: C2}">
                                                <Header Text = "Accrued Sale" />
                                            </ Ig: BoundDataField>
                                  </ Columns>
                              </ Ig: Band>
                          </ Bands>
                          <Columns>
                                                                 <Ig: BoundDataField DataFieldName = "ZONE" Key = "ZONE" Width = "8%">
                                    <Header Text = "Zone" />
                                   
                                </ Ig: BoundDataField>
                                <Ig: BoundDataField DataFieldName = "Code" Key = "Code" Width = "4%">
                                    <Header Text = "Code" />
                                </ Ig: BoundDataField>
                                <Ig: BoundDataField DataFieldName = "NOMBRE_ASESOR" Key = "NOMBRE_ASESOR" Width = "17%">
                                    <Header Text = "Name Advisor" />
                                  
                                </ Ig: BoundDataField>
                                 <Ig: BoundDataField DataFieldName = "BUDGET" Key = "BUDGET" Width = "9%" DataFormatString = "{0: C2}">
                                    <Header Text = "Budget" />
                                </ Ig: BoundDataField>
                                <Ig: BoundDataField DataFieldName = "PP_DIARIO" Key = "PP_DIARIO" Width = "7%" DataFormatString = "{0: C2}">
                                    <Header Text = "Daily Budget" />
                           
                                </ Ig: BoundDataField>
                                <Ig: BoundDataField DataFieldName = "VTA_HOY" Key = "VTA_HOY" Width = "7%" DataFormatString = "{0: C2}">
                                    <Header Text = "Sale Today" />
                                </ Ig: BoundDataField>
                                <Ig: BoundDataField DataFieldName = "VTA_AYER" Key = "VTA_AYER" Width = "7%" DataFormatString = "{0: C2}">
                                    <Header Text = "Sale Yesterday" />
                                </ Ig: BoundDataField>
                                <Ig: BoundDataField DataFieldName = "VTA_ACUM" Key = "VTA_ACUM" Width = "7%" DataFormatString = "{0: C2}">
                                    <Header Text = "Accrued Sale" />
                                </ Ig: BoundDataField>
                                <Ig: BoundDataField DataFieldName = "% CUMP" Key = "% CUMP" Width = "4%" DataFormatString = "{0: # ##%.}">
                                    <Header Text = "% Compliance" />
                                </ Ig: BoundDataField>
                                <Ig: BoundDataField DataFieldName = "VTA_PRESUSP" Key = "VTA_PRESUSP" Width = "9%" DataFormatString = "{0: C2}">
                                    <Header Text = "Sale Budgeted" />
                                </ Ig: BoundDataField>
                                <Ig: BoundDataField DataFieldName = "% PRESUSP" Key = "% PRESUSP" Width = "4%" DataFormatString = "{0: # ##%.}">
                                    <Header Text = "% Budget" />
                                </ Ig: BoundDataField>
                                <Ig: BoundDataField DataFieldName = "PROY_MES" Key = "PROY_MES" Width = "9%" DataFormatString = "{0: C2}">
                                    <Header Text = "Designing Month" />
                                </ Ig: BoundDataField>
                          </ Columns>
                      </ Ig: Band>
                  </ Bands>
                  <GroupingSettings EnableColumnGrouping = "True">
                  </ GroupingSettings>
                  <Columns>
                               <Ig: BoundDataField DataFieldName = "REGIONAL" Key = "REGIONAL" Width = "10%">
                            <Header Text = "Regional" />
                          
                        </ Ig: BoundDataField>
                        <Ig: BoundDataField DataFieldName = "BUDGET" Key = "BUDGET" Width = "9%" DataFormatString = "{0: C2}">
                            <Header Text = "Budget" />
                        </ Ig: BoundDataField>
                        <Ig: BoundDataField DataFieldName = "PP_DIARIO" Key = "PP_DIARIO" Width = "8%" DataFormatString = "{0: C2}">
                            <Header Text = "Daily Budget" />
                            
                        </ Ig: BoundDataField>
                        <Ig: BoundDataField DataFieldName = "VTA_HOY" Key = "VTA_HOY" Width = "8%" DataFormatString = "{0: C2}">
                            <Header Text = "Sale Today" />
                        </ Ig: BoundDataField>
                        <Ig: BoundDataField DataFieldName = "VTA_AYER" Key = "VTA_AYER" Width = "8%" DataFormatString = "{0: C2}">
                            <Header Text = "Sale Yesterday" />
                        </ Ig: BoundDataField>
                        <Ig: BoundDataField DataFieldName = "VTA_ACUM" Key = "VTA_ACUM" Width = "9%" DataFormatString = "{0: C2}">
                            <Header Text = "Accrued Sale" />
                        </ Ig: BoundDataField>
                        <Ig: BoundDataField DataFieldName = "% CUMP" Key = "% CUMP" Width = "8%" DataFormatString = "{0: # ##%.}">
                            <Header Text = "% Compliance" />
                        </ Ig: BoundDataField>
                        <Ig: BoundDataField DataFieldName = "VTA_PRESUSP" Key = "VTA_PRESUSP" Width = "9%" DataFormatString = "{0: C2}">
                            <Header Text = "Sale Budgeted" />
                        </ Ig: BoundDataField>
                        <Ig: BoundDataField DataFieldName = "% PRESUSP" Key = "% PRESUSP" Width = "6%" DataFormatString = "{0: # ##%.}">
                            <Header Text = "% Budget" />
                        </ Ig: BoundDataField>
                        <Ig: BoundDataField DataFieldName = "PROY_MES" Key = "PROY_MES" Width = "9%" DataFormatString = "{0: C2}">
                            <Header Text = "Designing Month" />
                        </ Ig: BoundDataField>
                        <Ig: BoundDataField DataFieldName = "EFFECTIVENESS" Key = "EFFECTIVENESS" Width = "6%" DataFormatString = "{0:. # ##%}">
                            <Header Text = "% Effectiveness" />
                        </ Ig: BoundDataField>
                  </ Columns>
                
              </ Ig: WebHierarchicalDataGrid>
              <Ig: WebHierarchicalDataSource ID = "DatoEnCascada1" runat = "server">
                  <DataViews>
                      <Ig: DataView ID = "Cadena1_DefaultView" DataMember = "DefaultView" DataSourceID = "String1" />
                      <Ig: DataView ID = "Cadena2_DefaultView" DataMember = "DefaultView" DataSourceID = "String2" />
                      <Ig: DataView ID = "Cadena3_DefaultView" DataMember = "DefaultView" DataSourceID = "string3" />
                  </ DataViews>
                  <DataRelations>
                      <Ig: DataRelation ChildColumns = "REGIONAL" ChildDataViewID = "Cadena2_DefaultView" ParentColumns = "REGIONAL" ParentDataViewID = "Cadena1_DefaultView" />
                      <Ig: DataRelation ChildColumns = "REGIONAL CODE" ChildDataViewID = "Cadena3_DefaultView" ParentColumns = "REGIONAL CODE" ParentDataViewID = "Cadena2_DefaultView" />
                  </ DataRelations>
              </ Ig: WebHierarchicalDataSource>
              <Asp: SqlDataSource ID = "string3" runat = "server" ConnectionString = "<% $ ConnectionStrings: CENTRAL%>" SelectCommand = "REGIONAL select, CODE, f.NIT, RTRIM (pc.nombre) CLIENT, isnull (VTA_HOY, 0) VTA_HOY, isnull (VTA_AYER, 0) VTA_AYER, isnull (VTA_ACUM, 0) VTA_ACUM from esp_ventas_regional_vendedor_cli f, mtprocli pc with (nolock) where f.nit = pc.nit and f.usuario=@USUARIO and @ buscarCM = 'True 'and (regional code is not null or is not null) ">
                  <SelectParameters>

                                <Asp: SessionParameter Name = "USER" SessionField = "CODIGOUSUARIOS" Type = "String" />
                                <Asp: SessionParameter Name = "buscarCM" SessionField = "buscarCM" Type = "Boolean" />
                      <Asp: SessionParameter Name = "ANO" SessionField = "anoCM" Type = "String" />
                      <Asp: SessionParameter Name = "MES" SessionField = "mesCM" Type = "String" />

                    </ SelectParameters>

              </ Asp: SqlDataSource>
              <Asp: SqlDataSource ID = "String2" runat = "server" ConnectionString = "<% $ ConnectionStrings: CENTRAL%>" SelectCommand = "select REGIONAL,ZONA,CODIGO,NOMBRE_ASESOR,PRESUPUESTO,PP_DIARIO,VTA_HOY,VTA_AYER,VTA_ACUM,[%CUMP],VTA_PRESUSP,[%PRESUSP],PROY_MES Where esp_ventas_regional_vendedor from user = @ and @ buscarCM USER = 'True' and anus year and month = @ = @ month and VTA_ACUM + BUDGET <> 0 ">
                         <SelectParameters>

                                <Asp: SessionParameter Name = "USER" SessionField = "CODIGOUSUARIOS" Type = "String" />
                                <Asp: SessionParameter Name = "buscarCM" SessionField = "buscarCM" Type = "Boolean" />
                                 <Asp: SessionParameter Name = "ANO" SessionField = "anoCM" Type = "String" />
                      <Asp: SessionParameter Name = "MES" SessionField = "mesCM" Type = "String" />
                    </ SelectParameters>

              </ Asp: SqlDataSource>
              <Asp: SqlDataSource ID = "String1" runat = "server" ConnectionString = "<% $ ConnectionStrings: CENTRAL%>" SelectCommand = "select REGIONAL,PRESUPUESTO,PP_DIARIO,VTA_HOY,VTA_AYER,VTA_ACUM,[%CUMP],VTA_PRESUSP,[%PRESUSP],PROY_MES,EFECTIVIDAD Where esp_ventas_regional from user = @ and @ buscarCM USER = 'True' and VTA_ACUM + BUDGET <> 0 and year = @ year and month = @ month ">
                         <SelectParameters>

                                <Asp: SessionParameter Name = "USER" SessionField = "CODIGOUSUARIOS" Type = "String" />
                                <Asp: SessionParameter Name = "buscarCM" SessionField = "buscarCM" Type = "Boolean" />
                                 <Asp: SessionParameter Name = "ANO" SessionField = "anoCM" Type = "String" />
                      <Asp: SessionParameter Name = "MES" SessionField = "mesCM" Type = "String" />

                    </ SelectParameters>

              </ Asp: SqlDataSource>

  • You must be logged in to reply to this topic.
Discussion created by
Favorites
Replies
Created On
Last Post
Discussion created by
Charles
Favorites
0
Replies
17
Created On
Jun 30, 2016
Last Post
9 years, 8 months ago

Suggested Discussions

Created by

Created on

Jun 30, 2016 8:14 PM

Last activity on

Feb 23, 2026 5:38 PM