I've created a SQL Data Source on my ASPX page. I'm using SQL Server as my database.
I added a GridWeb to my page and used the Worksheet Designer to set the data source as the one I created above. When I try to set the data members, there is nothing in the drop down list. Is there something else that needs to be done here?
This is the code for my SQL Data Source:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:cvmartConnectionString %>"
SelectCommand="SELECT * FROM Product"></asp:SqlDataSource>
And here is part of the code for the grid:
<agw:Worksheet runat="server" DataMember="" DataSource="<%# SqlDataSource1 %>" Name="Sheet1">