I need to add a dropdown box to my login page that allows the user to change the connectionString to a different string, e.g. "LDAP://ActiveDirectoryDomain2.com"
In C# code behind how do change the connectionString value?
More info:
The problem I am having is that there are 4 other web.config settings call that one connectionString. For example:
My application is used by several customers, who needs to maintain their own database. Currently I'm keeping all the connectionstrings and according to the user, change it. (In a case of CRUD operation). Is this errenous way? I don't know much about MultiTenant applications. Is that the best solution for my problem?
I have a connectionstring in my web.config <add name="HeimkinoVerbindungszeichenfolge1" connectionString="Data Source=SERVER;Initial Catalog=Heimkino;Persist Security Info=True;User ID=sa;Password=*******;"providerName="System.Data.SqlClient" />
This itself is working when using eg the SQLDataSource for a Gridview or similar.
Now I need to access this DB with different scripts and work with that database.
Eg I need to run this comand in a page_load against the DB
[Code]....
to remove old events from the database
For other pages I need something like
[Code]....
for some userauthentication things this should just create a recordset I can work with then.
Is there a way to realize this using the connectionstring in the web.config (and if so, How???)
If this will not work, how can I run such queries?
My ASP.net 4.0 framework application references that DDL and retrieves data from it. I want create a Entity Framework 4 DataContext within my DDL with the ConnectionString from the App.config. (I do not want to pass the connectionString from my ASP.net application in every single method. (I'm using ObjectDataSources))
However, this line inside my DLL throws a NullReferenceException.
how can i encrpt database password and store to Visual Studio's connectionString areaalso, i would like to know how can i set all config in config file and how the program can read.
I know this might be a very basic question, but maybe thats why im having problems finding the answer. Right now I'm creating database connections in my source files by doing something like this:
SqlConnection con = new SqlConnection("Data Source=...Password=...); SqlCommand cmd = new SqlCommand(String.Format("SELECT * FROM Table;"), con); con.Open(); SqlDataReader reader = cmd.ExecuteReader();
But this means that if I choose to change databases it will be a major pain in the ass. Do you guys know how to use the connection string from a web.config file instead?
I am new to asp.net and wondering if anybody can help me defining SQL Server 2005 ConnectionString in web.config file and call/read anywhere in application on any button.Kindly provide me code example.
I want to setup the connectionstring of the SqlDatasource of a dropdown list at runtime, eg. Page Load event. I have install MySQl ODBC driver, System DSN name as "MySQL_Employee" If I have an entry in Web.config:
<connectionStrings> <add name="mysqlConnection" connectionString="DSN=MySQL_Employee;UID=john;description=connection to employee database;server=empServer;database=employee;port=3306;" providerName="System.Data.Odbc"/> </connectionStrings>
I encrypted my connectionstring and store at web.config file. Then I bind Gridview with sqldatasource control, cannot bind because of sqldatasource don't know the(encrypted) connectionstring.
i have a class library and i want to use it in difrent web form application.
i created a linq data class and i drag and drop the table of my local database in it.
now i want to use this class library in my web form application with a database in server with difrent database name but with same tables and also the connectionString Name is the same.
in my class library i call myDataContax("MyConnectionStringName")
my question is when i use a connectionstring with the same connectionString Name as my Class library ConentionString Name but with difrent database name it will work or not?
i have this table and want to change the background-color to be yellow if the server used int he SQL connection string is not 'pheddv20'i am adding c# code to the page load event to check for this and run the dynamic logic. the connection string is held in the web.config as is typically seen...whats the code look like for this type of action?
I'm trying to set up a simple content management system for two different sites, which are both stored on the same server (my own, not hosting, if it matters:)).
Both sites are basically the same, built upon a similar (but seperate) xsd (Typed DataSet) file, and read data from different databases using the tableadapters in the xsds.
Obviously, i have the same xsd setup in my management system application that need to hook up to the relevant database (after user authentication) and use the tableadapters to access the data and allow the forms in the management system to modify the data.
When i had a single site, the connection string was stored in the web.config file and after logging in to the management system, all forms could access the database.
Now i have two site and i need to setup the connection string in the xsd dynamically after user validation based on the relevant site to edit.
My question is, how do i set the xsd's connection string dynamically (after user logs in, the function returns the specific connectionstring and stores it in a Session variable)
i just came up with the reading, Writing and adding values dynamically in web.Config in asp.net. Have many ideas in mind, but i just wana know what is the best way of adding values in web config dynamically.
I have created a code which updates the sessionState timeout on certain conditions, but when I run this code, it asks for saving the web config file. I think its because writer.flush() or writer.close() code. Can anyone help me on how to save the web.config file @ runtime. ??
I have a web-application with more than 5 themes. Each themes covers a completely different style for different customers. whenever we publish a new version of our application we send it for all of customers.
We specify theme in web.config file in <Page> tag. like
<page theme="Theme1" /> // or Theme2 for second customer.
with this approach we easily change the style of application from each other without writing codes which needs a new publish for each one.
With changing the theme="Theme1". nothing change and we didn't write a code in application , so why changing theme don't change the theme and we need a new publish?
we want to change it in web.config or somewhere else and with changing it the theme change without needing a new publish for each one.
Update :
I Publish Once and then copy the published version for each customer (5 times) then in each web.config file I change the theme="CustomerTheme". but only the theme which was active in publish process is usable in all of 5 versions and other 4 themes are un-usable Actually the main question is that why changes in Web.Config need a different publish while it is XML and do not need a complie. I should Add this note that, App_Theme include all of 5 themes so that all of them Compiles and are ready to use
This is the way I publish the application
Photo Link
Update 2
here IFound the exact problem reported by someone else. he resolve the problem but I can't underestand how he resolved this Issue.
Is there a way to use a generated file as a configSource for a web.config section?
In web.config, I tried a simple:
<webParts configSource="webpartsConfig.aspx" />
where webpartsConfig.aspx just spits out XML when accessed normally, but not as a configSource. (The literal source code is included as-is, giving an error.)
Motivation for this solution: I have different configuration variables locally and online, and I don't want to juggle multiple config files.
Is there a way I can dynamically register an IHttpHandler in C# code, instead of having to manually add it to the system.web/httpHandlers section in the web.config.
This may sound crazy, but I have good reason for doing this. I'm building a WidgetLibrary that a website owner can use just by dropping a .dll file into their bin directory, and want to support this with minimal configuration to the web.config.
The basic idea is we have a test enviroment which mimics Production so customErrors="RemoteOnly". We just built a test harness that runs against the Test enviroment and detects breaks. We would like it to be able to pull back the detailed error. But we don't want to turn customErrors="On" because then it doesn't mimic Production.
I've looked around and thought a lot, and everything I've come up with isn't possible. Am I wrong about any of these points?
We can't turn customErrors on at runtime because when you call configuration.Save() - it writes the web.config to disk and now it's Off for every request.We can't symlink the files into a new top level directory with it's own web.config because we're on windows and subversion on windows doesn't do symlinks. We can't use URL-Mapping to make an empty folder dir2 with its own web.config and make the files in dir1 appear to be in dir2 - the web.config doesn't apply. We can't copy all the aspx files into dir2 with it's own web.config because none of the links would be consistent and it's a horrible hacky solution. We can't change customErrors in web.config based on hostname (e.g. add another dns entry to the test server) because it's not possible/supported. We can't do any virtual directory shenanigans to make it work.
If I'm not, is there a way to accomplish what I'm trying to do? Turn on customErrors site-wide under certain circumstances (dns name or even a querystring value)?
