Haha... yes google worx where i live. This is what I have done in my gridview and its not working.
<Columns>
<asp:HyperLinkField DataTextField="courseName" HeaderText="Course Tittle"
NavigateUrl="~/Default.aspx">
<HeaderStyle ForeColor="White" />
</asp:HyperLinkField>
<asp:BoundField DataField="courseCode" HeaderText="Course Code" ReadOnly="True"
SortExpression="courseCode" >
<HeaderStyle ForeColor="White" />
</asp:BoundField>
<asp:BoundField DataField="coursePrice" HeaderText="Course Price"
SortExpression="coursePrice" >
<HeaderStyle ForeColor="White" />
</asp:BoundField>
</Columns>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:scheduleConnectionString %>"
ProviderName="<%$ ConnectionStrings:scheduleConnectionString.ProviderName %>"
SelectCommand="SELECT [courseName], [courseCode], [coursePrice] FROM [courses] ORDER BY [courseName]">
</asp:SqlDataSource>