.Net 2.0 SqlDataSource and DataSet question

  • Thread starter Thread starter Jason Huang
  • Start date Start date
J

Jason Huang

Hi,


I would like to know what the DataSet name is and where the DataSet is for
a SqlDataSource like this:

<asp:SqlDataSource ID="SqlDataSourceA" runat="server" ConnectionString="<%$
ConnectionStrings:ServiceConnectionStringA %>"
SelectCommand="SELECT TestNo, AcceptDate, status FROM TestForm ORDER BY
TestNo">
</asp:SqlDataSource>

where the connectionStrings in te Web.Config is as:
<connectionStrings>
<add name="ETCServiceTestConnectionStringA" connectionString="Data
Source=192.168.100.100;Initial Catalog=Service;User
ID=service;Password=mypwd"
providerName="System.Data.SqlClient" />
</connectionStrings>

Thanks for help.


Jason
 
Set the SqlDataSource.DataSourceMode to SqlDataSourceMode.DataSet and invoke
SqlDataSource.Select() to get a DataSet.
 
Back
Top