如何在数据表或DataSet中验证电子邮件地址 [英] how to validate email address in side the data table or DataSet
问题描述
我有一个是具有一些记录的
标识&NBSP一个数据表;          电子邮件
--- -------- ------
1 hebsiboy@gmail.com
2             vb.com
3分配     &NBSP ; gobl。
4 boy @ yahoo.co.in
5分配            男孩
6分配  gmail.com
7 mail.gmail.com
i想要验证电子邮件列中的电子邮件地址,不使用循环
是他们的任何可能性
任何人请帮助我..........
您也可以按照以下方式检查电子邮件
var datarows =(来自 d dt .AsEnumerable()
<跨度类= 代码sdkkeyword>其中跨度> ISEMAIL(d.Field<字符串>(<跨度类= 代码串>跨度> <跨度类=code-string>))== true
选择 d).ToArray();
public const string MatchEmailPattern = @ ^(([\\\ - ] + \。)+ [\w - ] + |([a-zA-Z] {1} | [\w - ] {2,}))@
+ @ (([0-1]?[0-9] {1,2} | 25 [0-5] | 2 [0- 4] [0-9])\。([0-1]?[0-9] {1,2} | 25 [0-5] | 2 [0-4] [0-9])\ 。
+ @ ([0-1]?[0-9] { 1,2} | 25 [0-5] | 2 [0-4] [0-9])\。([0-1]?[0-9] {1,2} | 25 [0-5 ] | 2 [0-4] [0-9])){1} |
+ @ ([A-ZA-Z] + [\w - ] + \。)+ [A-ZA-Z] {2,4})
跨度>;
public static bool IsEmail( string email)
{
if (email!= <跨度类= 代码关键字>空跨度>)<跨度类= 代码关键字>返回跨度> System.Text.RegularExpressions.Regex.IsMatch(电子邮件,MatchEmailPattern);
其他 返回 false ;
}
I have one data table that is having some record's
Id Email
--- --------------
1 hebsiboy@gmail.com
2 vb.com
3 gobl.
4 boy@yahoo.co.in
5 boy
6 gmail.com
7 mail.gmail.com
i want to validate email address in email columns without using loop
is their any possibilities
any one please help me..........
You can check email following way also
var datarows = (from d in dt.AsEnumerable() where IsEmail(d.Field<string>("")) == true select d).ToArray(); public const string MatchEmailPattern = @"^(([\w-]+\.)+[\w-]+|([a-zA-Z]{1}|[\w-]{2,}))@" + @"((([0-1]?[0-9]{1,2}|25[0-5]|2[0-4][0-9])\.([0-1]? [0-9]{1,2}|25[0-5]|2[0-4][0-9])\." + @"([0-1]?[0-9]{1,2}|25[0-5]|2[0-4][0-9])\.([0-1]? [0-9]{1,2}|25[0-5]|2[0-4][0-9])){1}|" + @"([a-zA-Z]+[\w-]+\.)+[a-zA-Z]{2,4})
"; public static bool IsEmail(string email) { if (email != null) return System.Text.RegularExpressions.Regex.IsMatch(email, MatchEmailPattern); else return false; }
这篇关于如何在数据表或DataSet中验证电子邮件地址的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!