System.Data.SqlClient.SqlException: @@idusuario on SqlDataSource [Answered]RSS

2 replies

Last post Jul 05, 2012 09:45 PM by Decker Dong - MSFT

‹ Previous Thread|Next Thread ›

Shortcuts

kilofafeure

Member

233 Points

766 Posts

System.Data.SqlClient.SqlException: @@idusuario on SqlDataSource

Jul 04, 2012 06:49 AM|kilofafeure|LINK

Hi, I'm trying since a few days make work a gridview binded to sqldatasource. I've read a lot of posts and I'm not achieving it. The last exception I've obtained:

System.Data.SqlClient.SqlException: @@idusuario is not a parameter for procedure Select_Vectores.
   en System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   en System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   en System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   en

when I try to bind the GV.

But my procedure is this:

ALTER PROCEDURE [dbo].[Select_Vectores]
 
@idusuario integer = null

AS

DECLARE @sql        nvarchar(MAX),
		@paramlist nvarchar(4000)
        
SELECT @sql = 
        'SELECT tbV.NUMVECTOR, tbV.DESCRIPCION, 0[Dummy1], 0[Dummy2] FROM tbVECTORES tbV WHERE 1 = 1'

IF @idusuario IS NOT NULL
	SET @sql = @sql + ' AND tbV.ID_USUARIO = @xidusuario '

set @paramlist = '@xidusuario integer'
                  
EXEC sp_executesql @sql, @paramlist, @idusuario
SET NOCOUNT ON
RETURN

I'm adding the parameters on code behind. I should load the GV when the page it's loaded:

My aspx:

     
    <asp:UpdatePanel ID="upGrids" runat="server" RenderMode="Block" UpdateMode="Always" >
        <ContentTemplate>
        
            <!-- Titulo Monitor -->
            <div id="rbDisplayMonitor" class="Tahoma8NWhite" style="height:100%;">
                <div class="centrado">
                    <asp:RadioButton id="Radio1" Text="Llamadas" Checked="True"  GroupName="RadioGroup1" runat="server" AutoPostBack="true" />
                    <asp:RadioButton id="Radio2" Text="Agentes"  Checked="False" GroupName="RadioGroup1" runat="server" AutoPostBack="true" />
                    <asp:RadioButton id="Radio3" Text="Buzón"    Checked="False" GroupName="RadioGroup1" runat="server" AutoPostBack="true" />           
                </div>
            </div>
            <hr />/
                
            <!-- Vectores -->        
             <div id="DisplayMonitorVector" runat="server" class="Tahoma7">
                <asp:SqlDataSource id="SDSVector" runat="server" 
                    DataSourceMode="DataSet"                      
                    ConnectionString="<%$ ConnectionStrings:MiConexion %>"
                    SelectCommandType = "StoredProcedure"
                    SelectCommand = "Select_Vectores"
                    InsertCommandType = "StoredProcedure"
                    InsertCommand = "Insert_Vector"
                    DeleteCommandType = "StoredProcedure"
                    DeleteCommand = "Delete_Vector"                    
                    >
                </asp:SqlDataSource> 

                <div id="trVector1" class="centrado">
                    <asp:Literal runat="server" id="litDMV" Text="Vector: "></asp:Literal>
                    <asp:TextBox runat="server" id="NUMVECTOR" cssClass="CampoTexto" MaxLength="3" Width="40" Text=""></asp:TextBox>
                                       
                    <!-- Botón añadir vector -->
                    <asp:Button Text="Añadir" runat="server" ID="btAnadirV" CssClass="menuButton" OnClick="addVector" UseSubmitBehavior="false" />
                                                                
                    <!-- Botón borrar vector -->
                    <asp:Button Text="Borrar" runat="server" ID="btBorrarV" CssClass="menuButton" OnClick="deleteVector" UseSubmitBehavior="false" />
                                                            
                </div>
                <div id="trTablaVector" style="width: 90%;height:100%;margin: 5% auto 5% auto;">
                    <asp:GridView id="gvVector" runat="server" EnableViewState="false"  HorizontalAlign="Center"
                        CellPadding="4" ForeColor="#333333" GridLines="Both" AutoGenerateColumns="true"
                        AutoGenerateDeleteButton="false" EmptyDataText="No hay resultados" Width="100%" Height="100%"
                        DataSourceID="SDSVector" AllowSorting ="true" AllowPaging="true">
                    </asp:GridView>  
                 </div>              
            </div> 
                     
            <!-- Buzones -->
             <div id="DisplayMonitorBuzon" runat="server" class="Tahoma7" style="visibility: hidden; display: none;">
                <asp:SqlDataSource id="SDSBuzon" runat="server" 
                    DataSourceMode="DataSet"                       
                    ConnectionString= "<%$ ConnectionStrings:MiConexion %>"
                    SelectCommandType = "StoredProcedure"
                    SelectCommand= "Select_Buzones"
                    InsertCommandType = "StoredProcedure"
                    InsertCommand = "Insert_Buzon"
                    DeleteCommandType = "StoredProcedure"
                    DeleteCommand = "Delete_Buzon"
                    >              
                </asp:SqlDataSource>
                 
                <div id="trBuzon1" class="centrado">
                    <asp:Literal runat="server" id="litDMB" Text="Vector: "></asp:Literal>
                    <asp:TextBox runat="server" id="NUMBUZON" cssClass="CampoTexto" MaxLength="3" Width="40" Text=""></asp:TextBox>
                                    
                    <!-- Botón añadir buzón -->
                    <asp:Button Text="Añadir" runat="server" ID="btAnadirB" CssClass="menuButton" OnClick="addBuzon" UseSubmitBehavior="false" />                    
                                    
                    <!-- Botón borrar buzón -->
                    <asp:Button Text="Borrar" runat="server" ID="btBorrarB" CssClass="menuButton" OnClick="deleteBuzon" UseSubmitBehavior="false" />
                                      
                </div>
                <div id="trTablaBuzon" style="width:90%;height:100%;margin: 5% auto 5% auto;">
                    <asp:GridView id="gvBuzon" runat="server" EnableViewState="false"  HorizontalAlign="Center"
                        CellPadding="4" ForeColor="#333333" GridLines="Both" AutoGenerateColumns="true"
                        AutoGenerateDeleteButton="false" EmptyDataText="No hay resultados" Width="100%" Height="100%"
                        DataSourceID="SDSBuzon" AllowSorting ="true" AllowPaging="true">
                    </asp:GridView>                
                </div>              
             </div>                  
        </ContentTemplate>
    </asp:UpdatePanel>

My codebehind:

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

        Session("MST_IDUSUARIO") = 4

        If Not Page.IsPostBack Then
            verVector()
        ElseIf Not Page.IsPostBack And Radio1.InputAttributes("checked") = "true" Then  'And Radio1.Checked'
            verVector()
        ElseIf Not Page.IsPostBack And Radio3.InputAttributes("checked") = "true" Then  'And Radio3.Checked'
            verBuzon()
        ElseIf Page.IsPostBack And Radio1.InputAttributes("checked") = "true" Then  'And Radio1.Checked'
            verVector()
        ElseIf Page.IsPostBack And Radio3.InputAttributes("checked") = "true" Then  'And Radio3.Checked'
            verBuzon()
        Else
            'Falta por implementar Radio2'
        End If

    End Sub

    Public Sub verVector()

        Try
            SDSVector.SelectParameters.Add("@idusuario", Session("MST_IDUSUARIO"))
            SDSVector.Select(DataSourceSelectArguments.Empty)
            gvVector.DataBind()
            vectorVisible()
        Catch exsql As SqlException
            lblErrorVisible()
            Me.lblError.Text = exsql.ToString()
        Catch ex As Exception
            lblErrorVisible()
            Me.lblError.Text = ex.ToString()
        End Try

    End Sub

What I'm doing wrong? any idea? I'm obtainning the exception on this line:

gvVector.DataBind()

Thanks!

Ever than a programmer makes an extra hour god kills a kitten

- Reply
kilofafeure
Member

233 Points

766 Posts
Re: System.Data.SqlClient.SqlException: @@idusuario on SqlDataSource

Jul 04, 2012 06:53 AM|kilofafeure|LINK
Here was the error:
```
SDSVector.SelectParameters.Add("@idusuario", Session("MST_IDUSUARIO"))
```
It should be
```
SDSVector.SelectParameters.Add("idusuario", Session("MST_IDUSUARIO"))
```
Ever than a programmer makes an extra hour god kills a kitten
- Reply
Decker Dong...
All-Star

94130 Points

18109 Posts

Re: System.Data.SqlClient.SqlException: @@idusuario on SqlDataSource

Jul 05, 2012 09:45 PM|Decker Dong - MSFT|LINK

kilofafeure
kilofafeure

Congratulation that your problem is solved！Welcome to our forum next time to share more good things or ideas……

Reguards！