Sql Server调用C#编写的DLL

拼吾爱程序人生数据库编程 SQL Server Sql Server调用C#编写的DLL

1 / 1 页

跳转页

查看:1225

striver

个人空间 相册
性别:
来自:拼吾爱
积分:7057
帖子:6969
注册: 2007-04-09

2007-08-21 22:42 | 只看楼主

树型| 收藏| 小中大复制帖子链接到剪贴板1F

Sql Server调用C#编写的DLL

下面以发送邮件为例，来简单说明如何使用SQL SERVER调用DLL的功能。
第一步：新建一个CS类库

Code

[copy to clipboard]

CODE:

using System;
using System.Collections.Generic;
using System.Text;
using System.Net.Mail;
using System.Runtime.InteropServices;

namespace BiSoftWare
...{
[ComVisible(true)] <--此处为重点，表示此类能对COM类型公开。
public class BiSoftWare
...{
public bool SendMail(string from, string sendToCollection, string ccCollection, string bccCollection,
string replyTo,string subject, string body,string smtpSender, string smtpPassWord, string smtpHost)
...{
try
...{
string substr = null;
string temp = null;

MailMessage message = new MailMessage();
email initializtion#region email initializtion
message.From = new MailAddress(from);
message.IsBodyHtml = true;
message.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure;
message.Priority = MailPriority.Normal;
#endregion

Assign the message values if they are valid.#region Assign the message values if they are valid.

if (!string.IsNullOrEmpty(sendToCollection))
...{
substr = sendToCollection.Trim();
while (substr.Contains(";"))
...{
temp=substr.Substring(0, substr.IndexOf(";")).Trim();
if (!string.IsNullOrEmpty(temp))
...{
message.To.Insert(message.To.Count, new MailAddress(temp));
}
substr = substr.Replace(substr.Substring(0, substr.IndexOf(";")+1), "").Trim();
}
if (!string.IsNullOrEmpty(substr.Trim()))
...{
message.To.Insert(message.To.Count, new MailAddress(substr.Trim()));
}
}

if (!string.IsNullOrEmpty(ccCollection))
...{
substr = ccCollection.Trim();
while (substr.Contains(";"))
...{
temp = substr.Substring(0, substr.IndexOf(";")).Trim();
if (!string.IsNullOrEmpty(temp))
...{
message.CC.Insert(message.CC.Count, new MailAddress(temp));
}
substr = substr.Replace(substr.Substring(0, substr.IndexOf(";") + 1), "").Trim();
}
if (!string.IsNullOrEmpty(substr.Trim()))
...{
message.CC.Insert(message.CC.Count, new MailAddress(substr.Trim()));
}
}

if (!string.IsNullOrEmpty(bccCollection))
...{
substr = bccCollection.Trim();
while (substr.Contains(";"))
...{
temp = substr.Substring(0, substr.IndexOf(";")).Trim();
if (!string.IsNullOrEmpty(temp))
...{
message.Bcc.Insert(message.Bcc.Count, new MailAddress(temp));
}
substr = substr.Replace(substr.Substring(0, substr.IndexOf(";") + 1), "").Trim();
}
if (!string.IsNullOrEmpty(substr.Trim()))
...{
message.Bcc.Insert(message.Bcc.Count, new MailAddress(substr.Trim()));
}
}

if (!String.IsNullOrEmpty(subject))
...{
message.Subject = subject;
}

if (!String.IsNullOrEmpty(body))
...{
message.Body = body;
}

if (replyTo != null)
...{
message.ReplyTo = new MailAddress(replyTo);
}

message.Sender = new MailAddress(smtpSender);

#endregion

Create a new SmtpClient for sending the email#region Create a new SmtpClient for sending the email
SmtpClient smtpClient = new SmtpClient(smtpHost);
smtpClient.Credentials = new System.Net.NetworkCredential(message.Sender.Address, smtpPassWord);
smtpClient.DeliveryMethod = SmtpDeliveryMethod.Network;
smtpClient.Port = 25;
smtpClient.Send(message);

#endregion

return true;
}
catch
...{
return false;
}
}

public string Hello()
...{
return "Test OK!";
}
}
}

注：类库要使用签名，编译成强命名的程序集。在ASSMBILY中最好手工将comvisible设为TRUE.

2、拷贝编译好的DLL文件到C:\WINDOWS\system32下（此步路径需为系统path中的路径）
3、注册该类库：打开 SDK 命令提示工具，输入 regasm /tlb: C:\WINDOWS\system32\BiSoftWare.tlb C:\WINDOWS\system32\BiSoftWare.dll /codebase 回车(此步骤不能简为 regasm C:\WINDOWS\system32\BiSoftWare.dll，否则在SQL SERVER中会提示“系统找不到”)
4、打开SQL SERVER 新建存储过程输入

Code