Change connection string in XSD file
Are you looking for a way to Change connection string in XSD file ? then read this thread to know how to change it
Hello team,
<Connections>
<Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="ecusamplemanagementdbConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ecusamplemanagementdbConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.ecusamplemanagementdbConnectionString.ConnectionString" Provider="MySql.Data.MySqlClient" />
</Connections>
<DbSource ConnectionRef="ecusamplemanagementdbConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
I have an XSD file which is created from VS2010 as a Dataset, I would like to use this dataset to the SAP Crystal reports package(Not with VS) but this is referring to the Web.config file as a connection string.
I would like to refer my own connection string with Provide, DSN name, user name and password in the XSD file itself so that i can make use of it anywhere.
Could you please let me know how can I change this particular references from the XSD file.
thanks ®ards