Loop through database table's cols

hi everybody.i have some problem please help me.
i have three cols in my database table named col1,col2,and col3. i want that when user clicks on a button the a for loop takes the values of these cols one by one and show it on the web page. can some body tell me how to do it. i m using asp.net with c#. thanks in advance.