You must Sign In to post a response.
  • Category: XML

    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
  • #729693
    HI,

    Check these links

    http://stackoverflow.com/questions/435444/changing-xsd-connectionstring-at-runtime-for-a-multitenant-app

    http://itknowledgeexchange.techtarget.com/dotnet-developments/typed-datasets-and-the-connectionstring-problem/

    http://www.roelvanlisdonk.nl/?p=1746

    http://go4answers.webhost4life.com/Example/dynamically-change-connection-string-26694.aspx

  • #729713
    Hi,

    for all type of connections you just refer below link this will help you any type of connection required.

    http://www.connectionstrings.com/

    Hope this will help you to resolve the issue...

    --------------------------------------------------------------------------------
    Give respect to your work, Instead of trying to impress your boss.

    N@veen
    Blog : http://naveens-dotnet.blogspot.in/


  • This thread is locked for new responses. Please post your comments and questions as a separate thread.
    If required, refer to the URL of this page in your new post.