Visual Basic

<br />
<br />
#Region "Insert record into Outbound_Login_Details table with AgentId,login time and other details"<br />
    Public Sub INSERT_AGENT_DETAILS()<br />
        Try<br />
            con.Open()<br />
            Command.CommandText = "usp_Outbound_Login_Details"<br />
            Command.CommandType = CommandType.StoredProcedure<br />
            Command.Parameters.Add("@Agent_ID", SqlDbType.BigInt).Value = AgentID<br />
            Command.Parameters.Add("@Extno", SqlDbType.VarChar, 50).Value = g_Extension_Number<br />
           <br />
            Command.Parameters.Add("@Outbound_Login_id", SqlDbType.BigInt)<br />
            Command.Parameters("@Outbound_Login_id").Direction = ParameterDirection.Output<br />
            dataReader = Command.ExecuteReader()<br />
            g_OutBound_Login_ID = CInt(Command.Parameters("@OutBound_Login_ID").Value)<br />
            'Command.ExecuteNonQuery()<br />
            '<br />
        Catch ex As Exception<br />
            lblerror1.Text = ex.Message<br />
        Finally<br />
            dataReader.Close()<br />
            con.Close()<br />
        End Try<br />
<br />
    End Sub<br />
#End Region<br />
<br />
<br />
****************<br />
CREATE PROCEDURE  usp_Outbound_Login_Details <br />
( <br />
	@Agent_ID		BIGINT ,  <br />
	@Extno			VARCHAR(50),<br />
	@IPAddress	VARCHAR(50) = 0  <br />
)<br />
AS<br />
BEGIN<br />
	SET NOCOUNT ON<br />
	DECLARE @LoginDateTime AS DATETIME <br />
	SET @LoginDateTime = GETDATE() <br />
	INSERT INTO Outbound_Login_Details  WITH (ROWLOCK) ( Agent_ID , Login_Time , ExtNo,IPAddress ) <br />
	VALUES ( @Agent_ID , @LoginDateTime , @ExtNo,@IPAddress ) <br />
	SELECT  Outbound_Login_ID <br />
	FROM  Outbound_Login_Details (NOLOCK)<br />
	WHERE <br />
		Agent_ID = @Agent_ID AND <br />
		Login_Time = @LoginDateTime  AND <br />
		Extno =  @ExtNo<br />
END<br />
<br />
GO<br />
<br />
this vb.net code gives me <br />
ex.Message = "Procedure or function usp_Outbound_Login_Details has too many arguments specified."<br />
Please  what wrong in vb.net code.....<br />
<br />
<br />

<br />
Dim mySelectQuery As String = "UPDATE " & WhatTable & " SET "<br />
<br />
mySelectQuery += "VMeaning=" & "'" & Replace(TextBox1.Text, "'", Chr(34)) & "',"<br />
mySelectQuery += "Description=" & "'" & Replace(TextBox2.Text, "'", Chr(34)) & "',"<br />
mySelectQuery += "Thoughts=" & "'" & Replace(TextBox3.Text, "'", Chr(34)) & "'"<br />
mySelectQuery += " WHERE OderNumber=" & SorahNumber <br />
<br />
'When I cancel the line below, it is working fine<br />
mySelectQuery += " AND VNumber=" & CInt(ComboBox3.SelectedItem)  <br />
<br />
<br />
<br />
        Dim myconnection As New OleDbConnection(SQLConnStr)<br />
        Dim myCommand As New OleDbCommand(mySelectQuery, myconnection)<br />
<br />
        myconnection.Open()<br />
<br />
        myCommand.ExecuteNonQuery() 'error occurs here<br />
        myconnection.Close()<br />