Databases Reference
In-Depth Information
Go back to the
Default.aspx
page, and change the
SqlDataSource
settings as follows by
adding the
ConnectionString
and the
SelectCommand
settings manually.
5.
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:Connection1 %>"
SelectCommand="SELECT uid, name FROM sys.sysusers ORDER BY 1" >
</asp:SqlDataSource>
6.
Running the project should give you output similar to that shown in Figure
8-14
.
Figure 8-14.
Running the solution locally and fetching data from SQL Database
