How to make this change in a dataSet? Thanks.

[Miguel Dias Moura]

Hello,

I have this dataSet created in Dreamweaver:

<MMataSet
id="dsDocuments"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_conBonsAlunos")
%>'
DatabaseType='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_conBonsAlunos")
%>'

</MMataSet>

I want to replace CommandText='<%# "SELECT * FROM dbo.documents" %>'
with:

CommandText=SQLCODE,

Where SQLCode is a string created by a script when the page loads.

I believe this will be quite simple.
Can you tell me how the line CommandText=SQLCODE would look?

Thanks,
Miguel

 

[Curt_C [MVP]]

CommandText='<%= SQLCODE %>'