foreach loop in datagrid

Question

how to retrieve record from database table and display record in datagrid using foreach loop in asp.net with c#.

plz give me complete code of this problem