how to check EmailID in C#

Create function:

public bool IsValidEmail(string email)
{
//regular expression pattern for valid email
//addresses, allows for the following domains:
//com,edu,info,gov,int,mil,net,org,biz,name,museum,coop,aero,pro,tv
string pattern = @"^[-a-zA-Z0-9][-.a-zA-Z0-9]*@[-.a-zA-Z0-9]+(\.[-.a-zA-Z0-9]+)*\.(comeduinfogovintmilnetorgbiznamemuseumcoopaeroprotv[a-zA-Z]{2})$";
//Regular expression object
Regex check = new Regex(pattern, RegexOptions.IgnorePatternWhitespace);
//boolean variable to return to calling method
bool valid = false;
//make sure an email address was provided
if (string.IsNullOrEmpty(email))
{
valid = false;
}
else
{
//use IsMatch to validate the address
valid = check.IsMatch(email);
}
//return the value to the calling method
return valid;
}

Class Name:
using System.Text.RegularExpressions;

Use Function:

bool check=IsValidEmail(txtsearchtext.Text.ToString());
if(check == true)
{ Send Mail() }
else { Invalid Email}

Stored Procedure for Paggination

--DMS_LookUp_New_Search 'Company','HD' --Select count(*)/10 from DMSMaster -- where Company_Name like '%H%' --DmnLookUp 'Company','HD',22,10 --DmnLookUp 'Telephone','011',22,10 --DmnLookUp 'Company*City','sa*calicut',1,10 --DmnLookUp 'Email','HD',22,10 --Declare @Name Varchar(50) --Set @Name='Getit*Delhi' --Select substring(@Name,1,charindex('*',@Name)-1), substring(@Name,charindex('*',@Name)+1,Len(@Name)-charindex('*',@Name)) -- --Declare @CoName varchar(150) --Declare @CtName varchar(150) --Set @CoName = (Select substring(@Name,1,charindex('*',@Name)-1)) --Set @CtName =(Select substring(@Name,charindex('*',@Name)+1,Len(@Name)-charindex('*',@Name))) -- --print @CoName --Print @CtName CREATE Procedure DmnLookUp --'Company*City','HD',22,10 ( @cotype varchar(150) ,@Keyword varchar(200) ,@PageNo Numeric(16) ,@PageSize Numeric(16) ) as Set NoCount ON Declare @StartRow Numeric(16) Declare @EndRow Numeric(16) Set @StartRow=(@PageNo*@PageSize)-(@PageSize-1) Set @EndRow = @PageNo*@PageSize IF @cotype = 'Company' begin If Exists(SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'#JATC')) Drop Table #JATC select Row_Number() over (order by d.company_name asc) RowNo ,l.master_id ,l.location_id ,d.company_name ,d.title,l.state ,l.city,l.locality ,l.status into #JATC from dmsmaster d (nolock) inner join dmslocation l (nolock) on l.master_id=d.master_id and d.company_name like '%'+@Keyword+'%' Select RowNo, master_id ,location_id ,company_name ,title ,state ,city ,locality ,status from #JATC Where RowNo>=@StartRow and RowNo<=@EndRow end Else If @cotype = 'Telephone' begin If Exists(SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'#JATT')) Drop Table #JATT Select Row_Number() over (order by d.company_name asc) RowNo ,l.master_id ,l.location_id ,d.company_name ,d.title ,l.state ,l.city ,l.locality ,l.status into #JATT From dmsmaster d (nolock) inner join dmslocation l (nolock) on l.master_id=d.master_id and ( l.telephone1 like '%'+@Keyword+'%' or l.telephone2 like '%'+@Keyword+'%' or l.telephone3 like '%'+@Keyword+'%' or l.mobile like '%'+@Keyword+'%' ) Select RowNo, master_id ,location_id ,company_name ,title ,state ,city ,locality ,status from #JATT Where RowNo>=@StartRow and RowNo<=@EndRow end Else if @cotype = 'Company*City' Begin Declare @CoName varchar(150) Declare @CtName varchar(150) Set @CoName = (Select substring(@Keyword,1,charindex('*',@Keyword)-1)) Set @CtName =(Select substring(@Keyword,charindex('*',@Keyword)+1,Len(@Keyword)-charindex('*',@Keyword))) If Exists(SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'#JATCC')) Drop Table #JATCC Select Row_Number() over (order by d.company_name asc) RowNo ,l.master_id ,l.location_id ,d.company_name ,d.title,l.state ,l.city ,l.locality ,l.status into #JATCC from dmsmaster d (nolock) inner join dmslocation l (nolock) on l.master_id=d.master_id and d.company_name like '%'+@CoName+'%' and l.city like '%'+@CtName+'%' Select RowNo, master_id ,location_id ,company_name ,title ,state ,city ,locality ,status from #JATCC Where RowNo>=@StartRow and RowNo<=@EndRow End Else Begin If Exists(SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'#JATE')) Drop Table #JATE Select Row_Number() over (order by d.company_name asc) RowNo ,l.master_id ,l.location_id ,d.company_name ,d.title,l.state ,l.city,l.locality ,l.status into #JATE from dmsmaster d (nolock) inner join dmslocation l (nolock) on l.master_id=d.master_id and ( l.email like '%'+@Keyword+'%' or l.email1 like '%'+@Keyword+'%' ) Select RowNo, master_id ,location_id ,company_name ,title ,state ,city ,locality ,status from #JATE Where RowNo>=@StartRow and RowNo<=@EndRow End --Alter Procedure DmnLookUp 'Company','get',50,10 --( -- @cotype varchar(150) -- ,@Keyword varchar(200) -- ,@PageNo Numeric(16) -- ,@PageSize Numeric(16) --) --as --Set NoCount ON --Declare @StartRow Numeric(16) --Declare @EndRow Numeric(16) --Set @StartRow=(@PageNo*@PageSize)-(@PageSize-1) --Set @EndRow = @PageNo*@PageSize -- -- IF @cotype = 'Company' -- begin -- Select RowNo, -- master_id -- ,location_id -- ,company_name -- ,title -- ,state -- ,city -- ,locality -- ,status -- from -- ( -- select -- Row_Number() over (order by d.company_name asc) RowNo -- ,l.master_id -- ,l.location_id -- ,d.company_name -- ,d.title,l.state -- ,l.city,l.locality -- ,l.status -- from -- dmsmaster d (nolock) -- inner join dmslocation l (nolock) -- on l.master_id=d.master_id and d.company_name like '%'+@Keyword+'%' -- )JAT -- Where -- JAT.RowNo>=@StartRow -- and -- JAT.RowNo<=@EndRow -- end -- Else If @cotype = 'Telephone' -- begin -- Select RowNo, -- master_id -- ,location_id -- ,company_name -- ,title -- ,state -- ,city -- ,locality -- ,status -- from -- ( -- Select -- Row_Number() over (order by d.company_name asc) RowNo -- ,l.master_id -- ,l.location_id -- ,d.company_name -- ,d.title -- ,l.state -- ,l.city -- ,l.locality -- ,l.status -- From -- dmsmaster d (nolock) -- inner join dmslocation l (nolock) -- on l.master_id=d.master_id -- and -- ( -- l.telephone1 like '%'+@Keyword+'%' -- or -- l.telephone2 like '%'+@Keyword+'%' -- or -- l.telephone3 like '%'+@Keyword+'%' -- or -- l.mobile like '%'+@Keyword+'%' -- ) -- )JAT -- Where -- JAT.RowNo>=@StartRow -- and -- JAT.RowNo<=@EndRow -- end -- Else if @cotype = 'Company*City' -- Begin -- Select RowNo, -- master_id -- ,location_id -- ,company_name -- ,title -- ,state -- ,city -- ,locality -- ,status -- from -- ( -- Select -- Row_Number() over (order by d.company_name asc) RowNo -- ,l.master_id -- ,l.location_id -- ,d.company_name -- ,d.title,l.state -- ,l.city -- ,l.locality -- ,l.status -- from -- dmsmaster d (nolock) -- inner join dmslocation l (nolock) -- on l.master_id=d.master_id -- and -- d.company_name like '%'+@Keyword+'%' -- )JAT -- Where -- JAT.RowNo>=@StartRow -- and -- JAT.RowNo<=@EndRow -- End -- Else -- Begin -- Select RowNo, -- master_id -- ,location_id -- ,company_name -- ,title -- ,state -- ,city -- ,locality -- ,status -- from -- ( -- Select -- Row_Number() over (order by d.company_name asc) RowNo -- ,l.master_id -- ,l.location_id -- ,d.company_name -- ,d.title,l.state -- ,l.city,l.locality -- ,l.status -- from -- dmsmaster d (nolock) -- inner join dmslocation l (nolock) -- on l.master_id=d.master_id -- and -- ( -- l.email like '%'+@Keyword+'%' -- or -- l.email1 like '%'+@Keyword+'%' -- ) -- )JAT -- Where -- JAT.RowNo>=@StartRow -- and -- JAT.RowNo<=@EndRow -- End