Write Back To SQL from ASP .NET web Page

[rroman]

I'm trying to execute a SQL Insert command using my existing SqlConnection
without refering to a dataset. I've come acroos several examples such as:

Public Sub CreateMySqlCommand(myExecuteQuery As String, myConnection As
SqlConnection)
Dim myCommand As New SqlCommand(myExecuteQuery, myConnection)
myCommand.Connection.Open()
myCommand.ExecuteNonQuery()
myConnection.Close()
End Sub 'CreateMySqlCommand

however my project isn't recognizing SqlCommand as a function. Is there a
reference I'm missing or is someone else executing SQL commands straight at
the connection? Please help.

[Paul Clement]

On Thu, 4 Nov 2004 08:09:05 -0800, rr****@800mcmahan.com
<rr*****************@discussions.microsoft.com> wrote:

¤ I'm trying to execute a SQL Insert command using my existing SqlConnection
¤ without refering to a dataset. I've come acroos several examples such as:
¤
¤ Public Sub CreateMySqlCommand(myExecuteQuery As String, myConnection As
¤ SqlConnection)
¤ Dim myCommand As New SqlCommand(myExecuteQuery, myConnection)
¤ myCommand.Connection.Open()
¤ myCommand.ExecuteNonQuery()
¤ myConnection.Close()
¤ End Sub 'CreateMySqlCommand
¤
¤ however my project isn't recognizing SqlCommand as a function. Is there a
¤ reference I'm missing or is someone else executing SQL commands straight at
¤ the connection? Please help.

You need to either fully qualify the namespace or add an Imports statement to your module:

System.Data.SqlClient.SqlCommand

or

Imports System.Data.SqlClient
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

[rroman]

Thanks. All set with this. Functioning like a dream.

"Paul Clement" wrote:

On Thu, 4 Nov 2004 08:09:05 -0800, rr****@800mcmahan.com
<rr*****************@discussions.microsoft.com> wrote:

¤ I'm trying to execute a SQL Insert command using my existing SqlConnection
¤ without refering to a dataset. I've come acroos several examples such as:
¤
¤ Public Sub CreateMySqlCommand(myExecuteQuery As String, myConnection As
¤ SqlConnection)
¤ Dim myCommand As New SqlCommand(myExecuteQuery, myConnection)
¤ myCommand.Connection.Open()
¤ myCommand.ExecuteNonQuery()
¤ myConnection.Close()
¤ End Sub 'CreateMySqlCommand
¤
¤ however my project isn't recognizing SqlCommand as a function. Is there a
¤ reference I'm missing or is someone else executing SQL commands straight at
¤ the connection? Please help.

You need to either fully qualify the namespace or add an Imports statement to your module:

System.Data.SqlClient.SqlCommand

or

Imports System.Data.SqlClient
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)