How to make this change in a dataSet? Thanks.

[Miguel Dias Moura]

Hello,

I have this dataSet created in Dreamweaver:

<MM:DataSet
id="dsDocuments"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%#
System.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_STRING_conBonsAlunos")
%>'
DatabaseType='<%#
System.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_DATABASETYPE_conBonsAlunos")
%>'
CommandText='<%# "SELECT * FROM dbo.documents" %>'
Debug="true"

</MM:DataSet>

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 %>'
--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Miguel Dias Moura" <md*REMOVE*moura@*NOSPAM*gmail.com> wrote in message
news:eg**************@TK2MSFTNGP14.phx.gbl...

Hello,

I have this dataSet created in Dreamweaver:

<MM:DataSet
id="dsDocuments"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%#
System.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_STRING_conBonsAlunos")
%>'
DatabaseType='<%#
System.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_DATABASETYPE_conBonsAlunos")
%>'
CommandText='<%# "SELECT * FROM dbo.documents" %>'
Debug="true"

</MM:DataSet>

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