SQLSERVER 2008 调用dll发起socket CLR

发布时间：2020-12-12 16:04:35 所属栏目：MsSql教程来源：网络整理

导读：SQLSERVER中、DLL控件的调用。 exec sp_configure 'clr enabled',1 reconfigure go alter database OHKUMADB set trustworthy on go create ASSEMBLY asmHelloWorld FROM 'D:ClassLibrary1.dll' WITH PERMISSION_SET = unsafe go CREATE FUNCTION dbo.clrHe

SQLSERVER中、DLL控件的调用。
exec sp_configure 'clr enabled',1
reconfigure
go
alter database OHKUMADB set trustworthy on
go
create ASSEMBLY asmHelloWorld FROM 'D:ClassLibrary1.dll' WITH PERMISSION_SET = unsafe
go
CREATE FUNCTION dbo.clrHelloWorld
(
@name as nvarchar(200)
)
RETURNS nvarchar(200)
AS EXTERNAL NAME asmHelloWorld.[ClassLibrary1.CLRFunctions].SendMsg
go
SELECT dbo.clrHelloWorld('Mark')

备注：
ASSEMBLY的删除（ASSEMBLY删除前、关联的FUNCTION呀删除）
drop FUNCTION dbo.clrHelloWorld
go
DROP ASSEMBLY asmHelloWorld
go

DLL控件代码
namespace ClassLibrary1
{
public class CLRFunctions
{
public static string SendMsg(string msg)
{

try
{
System.Net.Sockets.TcpClient tcpc = new System.Net.Sockets.TcpClient();

tcpc.Connect("192.168.1.102",56668);

System.Net.Sockets.NetworkStream tcpStream = tcpc.GetStream();

Byte[] data = null;

data = System.Text.Encoding.ASCII.GetBytes(msg);

tcpStream.Write(data,data.Length);

tcpStream.Flush();
tcpStream.Close();
tcpc.Close();
}
catch (Exception exception)
{

return exception.GetType().ToString();
}
return "success";
}

小熊博客：www.btbear.net

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!