To Put All Sql In The Web.config Instead Of Code Behind?
Sep 13, 2010
I'm making the switch from vb.net to C#. And with that, I want to move away from using sql datasources in the aspx page, and put the code to execute my sql statements "where it should be". Only thing is, I don't know where exactly that is. Basically, there are a three or four stored procedures that a page of this small website may need execute per page.Instead of putting all this in the code behind of the first page, and then copy/paste similar in other pages, I'd like to put it all together in one spot and then have each page "call" as needed. Problem is, I just don't know where/how this should be to do this the proper way. I'm trying to learn a better way of coding this...
I would like to store some meta-information about a given site instance that can (a) be managed by that site instance and (b) persist clobbering of Web.config file.The site will run in multiple environments (dev,testing,staging and production) and each environment can have different values for this metadata. Note: All environments are running IIS 7.0+
The Root Web.config seems very appealing, as it is certainly outside of the website. Therefore, both files and databases can be changed while maintaining the metadata. I have seen how to modify the appSettings of the Web.config stored in the website, but is it possible to similarly modify the appSettings in the Root Web.config (Specifically within the proper directive)?
When your web.config or app.config file has an appsettings entry, what is the best way to refer to its key in your code file? Developers I have worked with have differing opinions on this. Some say to hard code the string and others suggest that there should be a file containing string constants and in your code, you use the constant as the appsettings key. I would be interested in hearing other opinions on this. What do you do? Why is it the best?
I have mulitple websites using the same code but different web.config files. Is there a way where I can achieve not having multiple copies of the same code? so its easy to mantain?
How Can We Have two Connection Strings In Web.Config And Switch Betweeen Them In Code Behind? when i add two connention strings in web.config so an error appears that tells us u cann't add two connection strings in web.config. i want the upper job because i have 2 databases and i want transfer data from another to the other one.
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.
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 using ajax controls in my website. In my previous website I used these controls and they worked well but when I started a new website and I used these validators, fiter textboxes they donot work. I am adding the same dll of ajaxcontroltool kit and the same code in web.config. Don't know what is the issue.Please can anyone let me know why this happens or am I doing any mistake.
I have some pages that need user to sign in. If not, I need to redirect user to signin page. I know this can be done by using some code like"<system.web><authorization><deny users="?"/></authorization></system.web>" in web.config.
But can I just write some code to do the same function?
like in page load method, I can check whether user is sign in, if user is not signed in yet, how can I redirect user to the login page by using code? and how can I stop sending the content of the page to user?
I'm doing a code of sending email to a reciepnt, i did the behind cod and the SMTP configuraiton but it when adding the statement to the web.config page it gives me an Error. "Error 2 Only one <configSections> element allowed per config file and if present must be the first child of the root <configuration> element. C:Documents and SettingsUserMy DocumentsVisual Studio 2008WebSitesWebSite2web.config 21 "I'm adding the following code inside the <configuration block as mentoined in another topic in the forum>
I wonder how to hard code the configuration below in a class. I have a case where I cannot use app.config (due to creation of dll). The code below is probably not enough.. hard coded in class
ContractDescription contract = new ContractDescription("Common.MyInterfaces.IConnector"); Binding binding = new NetTcpBinding(); binding.Name = "net.tcp.binding"; EndpointAddress endPointAddress = new EndpointAddress("net.tcp://localhost:9001/Connector"); ServiceEndpoint serviceEndpoint = new ServiceEndpoint(contract, binding, endPointAddress);
So if i encrypt connectionstrings and sections, how will i get their values inside my code?I don't want to decrypt the web.config, i just want to read the encrypted values.There must be a class.Maybe something from ConfigurationManager?I don't suppose it's automatically decrypted?
My hosting provider just changed the trust level to medium but I cant figureout where to place the configuration on the web.config file! I have spent hours trying to figureout with no luck. here my web.config file
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.
14 days ago all emails were being delivered without any error, but now none of the email is delivered neither from local site nor from hosted site.I did not change any single letter of code in web.config and in pages.
Web config file is as follows. <appSettings> <add key="MailFromAddress" value="<user name>@gmail.com"/> <add key="MailToAddress" value="<user name>@gmail.com"/>[code]....
myMessage.From = New MailAddress(AppConfiguration.MailFromAddress, AppConfiguration.SenderName) myMessage.To.Add(New MailAddress(AppConfiguration.MailToAddress, AppConfiguration.ReceiverName))
Dim mySmtpClient As New SmtpClient() Try mySmtpClient.EnableSsl = True[code]....
On debugging it always fires the catch block. Earlier I never had such problem with emails but for last few days none of the email is being delivered.Is it my system problem? Is it any port no. issue? My local site and remote site are not delivering any message. what could be the reason and how I make it functioning as before.
I just installed VS2010 and opened the root machine.config and web.config files for review and I found some errors. In machine.config, the following line has errors in both entries for <Microsoft.VisualStudio.Diagnostics.ServiceModelSink.Behavior>. When I hover the cursor over them I get a tooltip text which displays: "The element 'endpointBehaviors' has invalid child element 'Microsoft.VisualStudio.Diagnostics.ServiceModelSink.Behavior'. List of possible elements expected: '...(list of options here)...'. The same problem happens for the second appereance in tag <serviceBehaviors>.
[Code]....
In web.config, there is a tag called <protocols> that has an error with a tooltip text that says "The element 'system.web' has invalid child element 'protocols'. List of possible elements expected: '...(list of options here)...'.
Currently, I work on an ASP.NET project which is hosted under version control and is used on several developer machines, tester machine and production environment.
In three cases, configuration (Web.config) may be different. For example, developer and tester environments use testing SQL Server, whereas in production environment, another SQL Server is accessed, so the connection string is different in those cases.
We want to keep three versions of Web.config in subversion. But modifying each of three files every time we need to add, remove or change a common setting is annoying: it would be nice to have a common, master Web.config, which will be inherited by each of the three Web.config files.
How to set up an ASP.NET project which will use a master configuration file and different slave configuration files on different machines, thus sharing the same project/source code/configuration files in subversion?
When I open my ASP.NET site in IIS and try to open the .NET Trust Levels, I get an error message:
.NET Trust Levels There was an error while performing this operation.
Details: Filename: ?C:inetpubwwwrootmyappweb.config Line number: 445
Error: This configuration section cannot be used at this path. This happens when the section is locked at a parent level. Locking is either by default (overrideModeDefault="Deny"),or set explicitly by a location tag with overrideMode="Deny" or the legacy allowOverride="false".
I've checked a few places, but I haven't found anything that seems like it would be locking that setting. Is there a systematic way of determining where that setting is locked?
We are experiencing some strange behaviour on one of our ASP.NET web servers (Windows 2003 64-bit). After some activity, two third-party controls are unable to run correctly. One is log4net (it does not write error messages out) and the other is a menu control (it displays eval message instead of picking up its license). The one common thread is that both controls pick up their config from external config files (linked to from web.config).
Just wondering if anyone has any thoughts on this or experienced this in any way. Is it related to file/folder rights? The server has been running fine for a while and just started exhibiting this behaviour. Perhaps it occurs around the time the worker processes are recycled.
