Find Jobs
Hire Freelancers

Sql Server Stored Procedure Script

$10-30 USD

已取消
已发布超过 9 年前

$10-30 USD

货到付款
i want to run the following script from within a c# application : EXEC msdb.dbo.sp_send_dbmail profile_name = 'Adventure Works Administrator', recipients = 'emailaddress', body = 'The stored procedure finished successfully.', subject = 'Automated Success Message' ; //plse see : [login to view URL] //i want to use "msdb.dbo.sp_send_dbmail" to send my Database mails using SQL Database Mail //i know how to send mail from within SQL Server Management Studio using my SMTP settings //but i want a script to be created so that i can run the stored procedure from within a c# application to send the mail. //see example below. List<string> recipients = new List<string>(); [login to view URL]("mail1 at example dot com"); [login to view URL]("mail2 at example dot com"); string FromAddress = "support at example dot com"; string ReplytoAddress = "support1 aexample dot com"; string ProfileName = "SQL DB SendMail"; //i use dataadapter to run the stored procedure in example below var cls = new Data.DataTables.SQLMAIL_TableAdapters.SQLMAIL_TableAdapter(); cls.sp_SQL_DATABASE_MAIL_SEND(ProfileName , recipients, FromAddress, "Subject", "Body");
项目 ID: 6748358

关于此项目

6提案
远程项目
活跃10 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
6威客以平均价$36 USD来参与此工作竞价
用户头像
Hello, I am .NET expert. I am willing to help you do this project right now. Please contact me. Thank you
$55 USD 在1天之内
4.9 (58条评论)
5.6
5.6
用户头像
Hi, Myself dinesh expert in asp.net, c# and sql server with 10 yrs of experience in software development. Developed various web applications for finance, insurance , education and research domain. to send mail u can use either smtp or stored procedure. u have to call a stored procedure in which other stored procedure gets called. let me know your view. Awaiting for your positive response. Thanks and regards...dinesh.
$30 USD 在1天之内
4.7 (30条评论)
5.3
5.3
用户头像
hello i can do this. what sql server you are using.? please contact thanks
$30 USD 在1天之内
5.0 (1条评论)
2.7
2.7
用户头像
Hello sir/madam we have read and understand your requirement and very much confident that we can complete this project within low budget and less time . Give us chance to serve you better looking forward to be hired by you soon. Regards, softtechsurat
$35 USD 在1天之内
5.0 (1条评论)
0.0
0.0
用户头像
Not sure what problem you are facing, I can help you complete the email calling from either Stored Procedure, or in C# code. I have experience on both scenarios. Please let me know.
$35 USD 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
hello. I am an expert SQL developer with over 15 years experience, I believe I can complete this task for u
$30 USD 在2天之内
0.0 (1条评论)
0.0
0.0

关于客户

SOUTH AFRICA的国旗
South Africa
5.0
59
付款方式已验证
会员自9月 24, 2002起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。