i want to get all connectionstring defined in web.config
var dk = System.Configuration.ConfigurationManager.ConnectionStrings;
problem .i am define 2 connectionstrings in web.config but upper code return me 3 connectionstring
dk[0] = LocalSqlServer (dont know where to come )
dk[1] = connection1 (Define by me )
dk[2] = connection2 (Define by me )
so how i can get only 2 connection from Web.config
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.
<configuration>
<add
name="stringname"
[code]...
I am working on a web project in Visual Studio 2010 with ASP.NET 4.0/C# 4.0.My requirement is to remove all the namespace referenced from codebehind in C# and put it in web.config.
As per the link, [URL], from MSDN I added the namspaces to web.config.
Now my web.config will look like this.
[code]....
I have what I think is a very common scenario but I've searched quite some time now and can't seem to find the answer! I have a standard web app that has a web.config in the root directory. I have some account management pages in a subdirectory called Accounts. Any timeouts at the root level work fine - the user is redirected to Default.aspx as indicated in my Forms authentication. My problem is when the users are in the Accounts (or any) subdirectory and they go off for coffee and the app times out. On the next click, they get an error saying "Accounts/Default.aspx" cannot be found. And Default.aspx is not there as it sits at the root level. It's trying to redirect them to the default login URL as defined in the web.config file but that doesn't work when the user is sitting in a subdirectory. I don't want to put a default page in this any every sub directory. I have tried putting a web.config file in the subdirectory but it throws the error about machine to application level/IIS.
View 1 RepliesIf application is started without debugging - it runs smoothly, when I press F5 I get: "Unable to start debugging on the web server. Could not start ASP.NET debugging. More information may be available by starting the project without debugging. Click Help for more information"I noticed that problems are caused by URL Rewrite section in web.config:
<rewrite>
<rules>
<clear />
<rule name="LowerCaseRule" stopProcessing="true">
<match url="[A-Z]" ignoreCase="false" />
when I comment it out - I can start debugging. Also debugging works on VS's built-in web server.I'm running Win7 64 bit, VS 2010, application's framework is 4.0, in IIS application has ASP.NET 4.0 Intergrated pool set
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?
I have a website about to go live. I'm wondering what I should be doing about the connectionstring in the web.config. Do I obfuscate it and it so how?
View 3 RepliesI have a class library that contains a valid connectionString inside the app.config. Inside that class library I want to use it with
ConfigurationManager.ConnectionStrings["NAME"].ConnectionString
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.
ConfigurationManager.ConnectionStrings["NAME"].ConnectionString
I have the following in my web.config
<connectionStrings>
<add name="ActiveDirectoryConnection" connectionString="LDAP://ActiveDirectoryDomain1.com" providerName="System.Web.Security.ActiveDirectoryMembershipProvider"/>
</connectionStrings>
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:
<activeDirectorySecurityContextSettings connectionStringName="ActiveDirectoryConnection" defaultADUserName="ReportUser" defaultADPassword="password"/>
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.
View 3 RepliesAs mentioned in this tutorial (http://www.asp.net/webmatrix/tutorials/5-working-with-data), I tried using my own connectionstring from web.config.
I got this error: "Format of the initialization string does not conform to specification starting at index 0."
The tutorial suggests to use: Database.OpenConnectionString("SmallBakeryConnectionString") method
Instead you should use Database.Open("ConnectionStringName").
Ref: http://cytanium.com/forums/yaf_postsm18_Connection-string-problem.aspx
The API Document is missing Database.Open method and also Database.OpenConnectionString info needs to be modified.
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.
View 5 Repliesam having problems creating this;1. How to create a add a connectionstring to my web config fileThis is the connection string I have entered
Datasource=.SQLWEXPRESS; attachDb filename=c:inetpubwwwrootdevelopment_ecommerceApp dataextratime.mdf;integrated security=true; user instance true
I have tried to enter this as well
<connectionStrings>
<add name="development_Ecommerce" connectionString="Data Source=smbc-652263fbfaSQLEXPRESS;Inital Catalogue=extratime; Integrated Security=True" providerName="System.Data.SqlClient"/>
[code]...
i'm working on already built asp.net webapplication. in the web.config for connectionString section i have seen this
<add name="MyConnectionString" connectionString="3abcde12n3kd03kldwqaswe45tdw4fo23003ld3ddfot0lkdpe2d" providerName="System.Data.SqlClient"/>
can anyone tell me on how this encryption done? i know the standard way of encrypting using aspnetregiis.exe which replaces the entire connnectionString section of the web.config.
I just deployed my database to my remote server. I am trying to create a connectionstring to the remote server and it won't work. I am using godaddy. I kept having this message: could not establish a connection to the database. Here is the connectionstring for the local server:
<connectionStrings>
<add name="ApplicationServices" connectionString="data source=.SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
[code]...
I'm developing an ASP.NET WebForm application with Visual Studio 2008 SP1 and C#.
I've defined the following listener on Web.Config:
<system.diagnostics>
<trace>
<listeners>
<add name="myListener" type="System.Diagnostics.TextWriterTraceListener" initializeData="D:LogslogWeb.txt" />
</listeners>
</trace>
</system.diagnostics>
How can redirect output from OutPut Window to this listener? All sentences like this:
System.Diagnostics.Trace.WriteLine("IntegratedManaged: ResolveCulture");
or
System.Diagnostics.Debug.WriteLine("IntegratedManaged: ResolveCulture");
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 deploy my web site, it contains a project!
in MyWeb there are all the aspx page and some entites datamodel, in MyApp there are the class with function like "getter data from DB" and there is a entity data model.
afeter the deploy, I have only the web.config and the connection string for the entity datamodel....itīs run ok, read/write the data on the DB.
The problem is with MyApp.....after the deploy it is a dll file and I donīt have the app.config and the entity inside it donīt run, not read/write nothing on the DB.
There arenīt error or messager but not read/write the data in the MyApp project.
all run on the iis 7
now...the question is:
I lose the connection string (in app.config) after the deploy?
Can I put a entity in the MyWeb and read it in another project (myApp)?
ps: for connect to DB I use not the c# code:
var db=from x in AccessDB.Example select x;
I am developing web applicaiton. I want to read web.config in App.config file. I have appSettings and connectionStrings in web.config. How to read that?
View 10 RepliesWe recently updated from .NET 3.5 to .NET 4.0 (server 2003).We're getting this error on pages where we are trying to set the login control's textbox focus:
Uncaught ReferenceError: WebForm_AutoFocus is not defined Incidentally, the autofocus isn't working. So we get that error above (when doing Javascript debug with the Chrome browser), AND the autofocus doesn't work (in IE, Chrome, or FF).Also, we're using the ajax control toolkit for .NET 4.0 but I don't think we're using it on this page.....just fyi.
I have this very simple project,which consists ( Default.aspx , Class1.vb and web.config ) ....see the picWhen i press Debugging button ... it just worked fine.When I tried to upload it online or run it on iis localhost server, I face this problem.
View 6 RepliesWhile using a third party dll I was getting the following exception - "exePath must be specified when not running inside a stand alone exe" with following trace
System.Configuration.ConfigurationManager.OpenExeConfigurationImpl(ConfigurationFileMap fileMap, Boolean isMachine, ConfigurationUserLevel userLevel, String exePath).
The reason I found was that it was looking for app.config and I had provided the details in web.config. My question is why does the system.configuration differentiate between web.config and app.config.