Searching Data According the enter values in text box

using (SqlConnection con = new SqlConnection(connectionString))
    {
    con.Open();
    using (SqlCommand com = new SqlCommand("SELECT * FROM myTable WHERE email=@EM", con))
        {
        com.Parameters.AddWithValue("@EM", myTextBoxWithEmailIn.Text);
        // Insert to your gridView as normal.
        }

//First You Need To send your Email address to the database to match with the Same Email id from the DataBase

//Code Behind Code


Cmd = new SqlCommand("Sp_verifyEmailAddress", Con);
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.Parameters.AddWithValue("@EmailId",txt_EmailId);
dt= new SqlDataAdapter();
DataSet ds= new DataSet()
dt.fill(ds)

//create Procedure into the DataBase Like That 

create procedure Sp_verifyEmailAddress
(
@EmailId varchar(100)

)
as

declare Id int
set id= 0

declare Result int 

select Id= PersonsId from table where EmailId = @EmailId

if(id=0)
begin 
set Result=0
select Result
end 

else
begin 
select * from table where PersonsId=id
end