How to make this change in a dataSet? Thanks.

  • Thread starter Thread starter Miguel Dias Moura
  • Start date Start date
M

Miguel Dias Moura

Hello,

I have this dataSet created in Dreamweaver:

<MM:DataSet
id="dsDocuments"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_conBonsAlunos")
%>'
DatabaseType='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_conBonsAlunos")
%>'
CommandText=' said:
</MM:DataSet>
Click to expand...

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
 
Back
Top