Read Data From Grid View

Question

can Any one help me in .net code

i have grideview have an data

i need to read the data in first column for all rows and make an select statement to retrieve data from another table and put the result in same of grideview

 

i want to read the item number from here and do this statement

SELECT Item_Ledger_Entry.[Item No_]
,Sum(Cast(Item_Ledger_Entry.[

Quantity]as decimal(6,3))) As 'Inventory'
FROM [HO].[dbo].[American Department Stores$Item Ledger Entry] Item_Ledger_Entry
Where Item_Ledger_Entry.[Item No_]='T474151'
And Item_Ledger_Entry.[Location Code]='S0002'
Group By Item_Ledger_Entry.[Item No_]

Replace 'T474151' from Item Number and S0002 From Text Box