Copy and paste data from Excel / Clipboard to GridView and filter result on another page in GridView using C# in ASP.Net

Dear Musassar

Thanks for the code on page : http://www.aspsnippets.com/Articles/Copy-and-paste-data-from-Excel-Clipboard-to-GridView-in-ASPNet.aspx.

How can I make one of the column (eg.Name) from this Grid that is generated by copy paste method as a criteria in a SQL query statement. It seems that prooper referencing was needed when I attempted unsuccessfully several times.

Would it be any of the following:

e.g. Select [Name] from [MyCustomers] where [MyCustomers].[Name] = __________

or

Select [MyCustomers].[Name] from [MyCustomer] inner join_____________ON______________

Please help since I am a beginner.

Thanks Asif