Efficient best Syntax to Open a SqlConnection in Asp.Net 2.0 3.5

To describe the best way to open sql server connection in asp.net here i am choosing to bind the gridview because in most of the cases the major task is to bind GridView data. You can make more generous method to collect sql server data but here my intension is to show you how you can open sql server connection efficiently.












Please have a look at the code sample:
protected void