如何使用c＃取消订阅asp.net中的电子邮件ID [英] How to unsubscribe email id in asp.net using c#

问题描述

如果我的群发邮件的收件人想要取消订阅，那么如何从他们那里获取一个电子邮件地址以将其从我的SQL表中删除？我想以编程方式获取他们的电子邮件地址，并从我的表中删除该地址。我该怎么做？

解决方案

在表格中添加一列 Subscribe_Status （位数据类型）。 />
1 - 是

0 - 否

根据值，您需要对查询进行更改。例如，

  SELECT  *  FROM  Tbl_Subscriptions  WHERE   Subscribe_Status = 1  

以上查询仅选择用户（电子邮件）想要订阅。



同样，您可以更改查询以从结果集中删除用户。定制<！/ BLOCKQUOTE>

If a recipient of my mass mailing wants to unsubscribe then how do I get that one e-mail address from them to remove it from my SQL table? I want to get their e-mail address programmatically and remove that address from my table. How do I do that?

解决方案

Add a column Subscribe_Status(bit datatype) in your table.
1 - Yes
0 - No
Based on the value, you need to do changes in your query. For example,

SELECT * FROM Tbl_Subscriptions WHERE Subscribe_Status=1

Above query picks only users(emails) who wants to subscribe.

Same way, you could change your query to remove users from resultset. Customize!

这篇关于如何使用c＃取消订阅asp.net中的电子邮件ID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！