Question

Sorry for the many asked question again, but i have not found a answer for solving my problem. First of all: I have a Web (customer-intranet, internal use only) where the user should decide, witch project should be shown. Every project has a connection to a database on different servers. So I have to change the connectionstring to the right database or I have to install the same web twice or more. I cannot use different connectstring-names, because the the dataset-designer stores the connectionname hardcoded in the c#-designer-code.

Is there really now way, to set the project-connectionstring maybe in the global.asax.cs? Or another way to handle this?

Answer 1

也许您可以将设计器代码更改为不硬编码连接名称？

为什么不添加一个名为GetConnectionStringName（）的方法，该方法由设计器调用，并将动态选择正确的连接字符串？

Answer 2

我只是编辑C#-designer代码，并将其替换为对配置管理器连接字符串引用的引用（或任何漂浮在船上的东西）。它是自动生成的，这并不意味着你不能编辑它。

Answer 3

@Hunter Not shure, what you mean. we create a Dataset-class in the App_Data-Folder with contextmenu Add->Class

@drachenstern I know, I could edit the designed code. That s not only me, who create webpages. And everytime something changed in the dataset-layout the code has to edit again. That s no option

@Nathan Taylor That s all in the designer-created code. I don t know, when the code is accessed and the connection will opened.

友情链接