I have a GridView called GridView1. I want to load it based on a ButtonTest being clicked. When the button is clicked, I need to do a SQL retrieval of data and popuplate the GridView with it. I can write the SQL code to get the data but I wasn't sure how to load the data into the GridView1.
On a side note, could anyone tell me how I can leverage the SELECT column to my advantage. I would like to have it read the id of the row it's on and redirect to a new page with a url similar to this UserProfile.aspx?UserID=__ .
Thanks for any help in advance.