Must Declare the Scalar Variable error

[Oded Dror]

Hi there,

Please take a look at the source code and tell me whats wrong?

Imports System.Data
Imports System.Data.Sql Client
Partial Class Test
Inherits System.Web.UI.P age
Const conString As String = "Data Source=.;Initia l
Catalog=Northwi nd;Integrated Security=True"
Public Function MyInsertMethod( ) As Integer
Dim con As New SqlConnection(c onString)
Dim insertString As String = "Exec usp_InsertTest
@CustomerID,@Fi rstName,@LastNa me"
Dim cmd As New SqlCommand(inse rtString, con)
con.Open()
cmd.ExecuteNonQ uery()
con.Close()
End Function
Protected Sub Button1_Click(B yVal sender As Object, ByVal e As
System.EventArg s) Handles Button1.Click
Call MyInsertMethod( )
End Sub
End Class

I created a table Test with CustomerID nvarchar(50),Fi rstName
nchar(10),@Last Name nchar(10)

Along with the usp_InsertTest

set ANSI_NULLS ON
set QUOTED_IDENTIFI ER ON
GO
ALTER PROCEDURE [dbo].[usp_InsertTest]
(@CustomerID nvarchar(50),@F irstName nchar(10),@Last Name nchar(10))
AS
Insert into dbo.Test
(CustomerID,Fir stName,LastName )
Values
(@CustomerID,@F irstName,@LastN ame)
Return

When I click submit I'm getting an error that says
"Must Declare the Scalar Variable"

Ho can I fix this

Thanks
Oded Dror

[Kerem OZMAN]

Hi,
If your SqlCommand object (cmd in this case) has some parameter in its
CommandText then you have to add those parameters to your SqlCommand
object's Parameters collection that is (something like):
cmd.Parameters. Add("@CustomerI D", "SomeCustID ")
cmd.Parameters. Add("@FirstName ", "John")
cmd.Parameters. Add("@LastName" , "DOE")

Check MSDN on SqlParameter for more information.
Regards.
"Oded Dror" <od******@cox.n et> wrote in message
news:%2******** ********@TK2MSF TNGP02.phx.gbl. ..

Hi there,

Please take a look at the source code and tell me whats wrong?

Imports System.Data
Imports System.Data.Sql Client
Partial Class Test
Inherits System.Web.UI.P age
Const conString As String = "Data Source=.;Initia l
Catalog=Northwi nd;Integrated Security=True"
Public Function MyInsertMethod( ) As Integer
Dim con As New SqlConnection(c onString)
Dim insertString As String = "Exec usp_InsertTest
@CustomerID,@Fi rstName,@LastNa me"
Dim cmd As New SqlCommand(inse rtString, con)
con.Open()
cmd.ExecuteNonQ uery()
con.Close()
End Function
Protected Sub Button1_Click(B yVal sender As Object, ByVal e As
System.EventArg s) Handles Button1.Click
Call MyInsertMethod( )
End Sub
End Class

I created a table Test with CustomerID nvarchar(50),Fi rstName
nchar(10),@Last Name nchar(10)

Along with the usp_InsertTest

set ANSI_NULLS ON
set QUOTED_IDENTIFI ER ON
GO
ALTER PROCEDURE [dbo].[usp_InsertTest]
(@CustomerID nvarchar(50),@F irstName nchar(10),@Last Name nchar(10))
AS
Insert into dbo.Test
(CustomerID,Fir stName,LastName )
Values
(@CustomerID,@F irstName,@LastN ame)
Return

When I click submit I'm getting an error that says
"Must Declare the Scalar Variable"

Ho can I fix this

Thanks
Oded Dror

[Oded Dror]

I chenged the connection string to sqlDatasource1
This is sql client connection that I created
And now this is the error message that I'm getting
Format of the initialization string does not conform to specification
starting at index 0

How to fix that!

Thanks,
Oded Dror
"Oded Dror" <od******@cox.n et> wrote in message
news:%2******** ********@TK2MSF TNGP02.phx.gbl. ..

Hi there,

Please take a look at the source code and tell me whats wrong?

Imports System.Data
Imports System.Data.Sql Client
Partial Class Test
Inherits System.Web.UI.P age
Const conString As String = "Data Source=.;Initia l
Catalog=Northwi nd;Integrated Security=True"
Public Function MyInsertMethod( ) As Integer
Dim con As New SqlConnection(c onString)
Dim insertString As String = "Exec usp_InsertTest
@CustomerID,@Fi rstName,@LastNa me"
Dim cmd As New SqlCommand(inse rtString, con)
con.Open()
cmd.ExecuteNonQ uery()
con.Close()
End Function
Protected Sub Button1_Click(B yVal sender As Object, ByVal e As
System.EventArg s) Handles Button1.Click
Call MyInsertMethod( )
End Sub
End Class

I created a table Test with CustomerID nvarchar(50),Fi rstName
nchar(10),@Last Name nchar(10)

Along with the usp_InsertTest

set ANSI_NULLS ON
set QUOTED_IDENTIFI ER ON
GO
ALTER PROCEDURE [dbo].[usp_InsertTest]
(@CustomerID nvarchar(50),@F irstName nchar(10),@Last Name nchar(10))
AS
Insert into dbo.Test
(CustomerID,Fir stName,LastName )
Values
(@CustomerID,@F irstName,@LastN ame)
Return

When I click submit I'm getting an error that says
"Must Declare the Scalar Variable"

Ho can I fix this

Thanks
Oded Dror