C# - Use Connectionstring From Web.config In Source Code File?
Mar 15, 2011
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?
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 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 built an ASP.NET (.NET v4) application in VS 2010. It is working just fine. But when I try to create deployment package (so I can deploy it in our test IIS 7.5 Server), it gives me error like this,
Error 1 Could not open Source file: Could not find file 'C:11-2 estobjDebugCSAutoParameterize ransformedWeb.config'. 0 0 test
Thing is in past, I had deployed the SAME application using the SAME method.
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.
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:
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>
Is there anyway I can encode my asp.net source code?
I really don't want my customer to steal my vb source code. They refused to pay extra for the source code and license. So we need to convert vb file to dll or encode(encrypt) vb source code that no one can understand the logic or decode(decrypt).
how to make my source code to display on one line instead of multiple in source view. The display drives me batty when I'm trying to find something and I would prefer to display across the page instead of multiple lines down the page.
i have some websites and one part of all websites is the same and it work with dataset i got an ide to creat a code projrct to handel that part and i use it in all websites the problem is the websites not use the same connectionstring but the connectionstring name can be same. i need to set this code project to read the connectiostring from the website web.config file.
I'm creating a multi-tenant Asp.Net MVC 3 Web app, and using EF4.1 code first for the db model.For development I'm happy to use SqlServerCE in App_Data, and for production this will move to Sql Server 2008.
Say my context is called "MyModels", by default code-first looks for a connection string called "MyModels" in Web.config. This can be told to use a file in App_Data or changed to access a database in SQL2008. All fine so far.
But because of multi-tenancy, I'd like the SqlServerCE filename to match the unique id of the tenant (so App_Data would have "client_x.sdf", "client_y.sdf"; Sql Server 2008 would have separate databases). I can't work out how to direct to these different databases.
I've tried MyModels inheriting from DbContext and supplying a connection string (using a 'placeholder' conn string in Web.config and replacing "{clientId}" with the unique id), and I've also tried setting the connection string in the MyModels constructor:
base.Database.Connection.ConnectionString = xxx;
but this never seems to work. I always get the following error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
( it's not yet 'configured' to use SqlServerCE, and so is trying to connect to Sql Server)
Tracing the code, Database.Connection.ConnectionString hasn't been read from Web.config at this point, so I can't search and replace that, and, possibly, it's getting overwritten by the 'placeholder' conn string later in the pipeline.I reckon this must be quite straightforward and I just can't find the 'hook'.
I have a project that has 4 pages and from each page have several link buttons to go each of the other pages. I would like to declare these url in the web.config file and give them a name and access from vb.net code behind.
I'm preparing to deploy a ASP.NET web application. The target server has already a previous version of my web application with parameters specified on the web.config file.
In the new version of this web application, the web.config file contains new sections I would like they appear into the target web.config file on the server.
However I can't find the way to merge the new web.config sections into the existing web.config file ?
Does I have to do it programmatically, or is there a tool to merge the both files during installation ? (I'm using Web Setup Project).
