Lookup using the array of values eneted in the datagrid

All,

Iam new to ASP.NET and i got a new requirement to do a developmen wrk

I have attached an excel sheet here.

Basically, first i need to export numbers form EXcel sheet to data grid when i press IMPORT button

2. enter the cliebt and brochure detail and if i say lookup, it should fetch me the POD numbers from a table and populated in another data grid contraol

Please see the belo w image

Please help in how to proceed on thjis.

Date From Client Date To Brochure ImportApply ABTAClientBrochure A0001123A A0001456B A0001456C A0001789D A0001123E A0001123F A0001123G A0001123H A0001123I A0001123J A0001456K A0001456L A0001456M A0001678N A0001678O A0001678P A0001789QAdd Another Look UpCancelClear Pod Batch Look Up ABTAClientBrochurePOD No A0001123A1234567Print A0001456B1234567Print

For the first question, check this article:Populate a Datagrid with data from a worksheet

For the second question, you cannot simply search the datagrid place somewhere else, especially if that DataGrid is on another page. If the other DataGrid is on the same page, then you use the DataSource of that Grid, which might be a DataSet or any other collection, and search the record you need!

Hope this helps,

Regards