dll & Web Service in VB.Net 2005 Stored Procedure

[James Wong]

Hi,

I am writing a vb.net2005 program that needs to create a stored procedure
with SqlServerProjec t Template.
Now, I have two questions for this stored procedure.

1) How can I import and execute the .dll in this Stored Procedures?
2) How can I connect the Web Service and get the result in this Stored
Procedures?

-------------------------------------------------------------------
Partial Public Class StoredProcedure s1
<Microsoft.SqlS erver.Server.Sq lProcedure()> _
Public Shared Sub GetTable()

Dim strSQL As String = "SELECT * FROM Table1"

Using conn As New SqlConnection(" context connection=true ")
Using cmd As New SqlCommand
With cmd
.Connection = conn
.CommandText = strSQL
.CommandType = CommandType.Tex t
conn.Open()
SqlContext.Pipe .ExecuteAndSend (cmd)
.Connection.Clo se()
End With
End Using
End Using
End Sub
End Class
-------------------------------------------------------------------

Thanks!

[Cor Ligthert [MVP]]

James,

It can be that I understand you wrong, however a stored procedure can
contain SQL transact language. Not VBNet DLL's.

Cor

"James Wong" <cp*******@nosp am.nospam> schreef in bericht
news:%2******** ************@TK 2MSFTNGP02.phx. gbl...

Hi,

I am writing a vb.net2005 program that needs to create a stored procedure
with SqlServerProjec t Template.
Now, I have two questions for this stored procedure.

1) How can I import and execute the .dll in this Stored Procedures?
2) How can I connect the Web Service and get the result in this Stored
Procedures?

-------------------------------------------------------------------
Partial Public Class StoredProcedure s1
<Microsoft.SqlS erver.Server.Sq lProcedure()> _
Public Shared Sub GetTable()

Dim strSQL As String = "SELECT * FROM Table1"

Using conn As New SqlConnection(" context connection=true ")
Using cmd As New SqlCommand
With cmd
.Connection = conn
.CommandText = strSQL
.CommandType = CommandType.Tex t
conn.Open()
SqlContext.Pipe .ExecuteAndSend (cmd)
.Connection.Clo se()
End With
End Using
End Using
End Sub
End Class
-------------------------------------------------------------------

Thanks!

[James Wong]

Thanks!

"Cor Ligthert [MVP]" <no************ @planet.nl> ¼¶¼g©ó¶l¥ó·s»D: O4************* *@TK2MSFTNGP05. phx.gbl...

James,

It can be that I understand you wrong, however a stored procedure can
contain SQL transact language. Not VBNet DLL's.

Cor

"James Wong" <cp*******@nosp am.nospam> schreef in bericht
news:%2******** ************@TK 2MSFTNGP02.phx. gbl...

Hi,

I am writing a vb.net2005 program that needs to create a stored procedure
with SqlServerProjec t Template.
Now, I have two questions for this stored procedure.

1) How can I import and execute the .dll in this Stored Procedures?
2) How can I connect the Web Service and get the result in this Stored
Procedures?

-------------------------------------------------------------------
Partial Public Class StoredProcedure s1
<Microsoft.SqlS erver.Server.Sq lProcedure()> _
Public Shared Sub GetTable()

Dim strSQL As String = "SELECT * FROM Table1"

Using conn As New SqlConnection(" context connection=true ")
Using cmd As New SqlCommand
With cmd
.Connection = conn
.CommandText = strSQL
.CommandType = CommandType.Tex t
conn.Open()
SqlContext.Pipe .ExecuteAndSend (cmd)
.Connection.Clo se()
End With
End Using
End Using
End Sub
End Class
-------------------------------------------------------------------

Thanks!

[Steven Cheng[MSFT]]

Hello James,

As for this issue, I've found your another dupilcated thread in the

microsoft.publi c.dotnet.genera l

newsgroup. I've posted my response and some suggestion there. I'd
appreciate if you have a look there. Also, if there is anything unclear or
if you need any further assistance, please feel free to post there.

Thanks for your understanding.

Regards,

Steven Cheng
Microsoft Online Community Support
=============== =============== =============== =====

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=============== =============== =============== =====
This posting is provided "AS IS" with no warranties, and confers no rights.

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)