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...
protected void getSectionContent()
{
SqlConnection conn = default(SqlConnection);
SqlCommand comm = default(SqlCommand);[code]....
View 3 Replies
Similar Messages:
Jan 30, 2011
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)?
View 2 Replies
Jul 1, 2010
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?
View 4 Replies
Mar 8, 2011
<sessionState timeout="1440"></sessionState>
how can i read value of timeout from web.config to c# code
View 2 Replies
Oct 18, 2010
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?
View 1 Replies
Apr 30, 2010
I want to use the setting stored in the web.config file in my vb code, but don't know how to reference them.
More specifically I want to access the Host name, username and password in the smtp settings to send an email. My web.config is
[code].....
View 11 Replies
Nov 19, 2010
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.
View 4 Replies
Mar 23, 2010
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.
View 2 Replies
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?
View 5 Replies
Feb 6, 2010
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.
View 5 Replies
Oct 16, 2010
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?
View 3 Replies
Mar 27, 2010
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>
<system.net>
<mailSettings>
<smtp from="username@DomainName">
[code]...
View 16 Replies
Feb 6, 2010
what code should i write in web.config for the connection string for DB connectivity woth ado.net component??
View 2 Replies
Oct 19, 2010
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);
[Code]....
View 3 Replies
Feb 18, 2010
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?
View 4 Replies
Dec 29, 2010
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
[Code]....
View 2 Replies
Mar 1, 2011
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.
View 3 Replies
Apr 28, 2010
I need convert my htaccess code to web.config code.
this is the htaccess code:
RewriteCond %{THE_REQUEST} ^[A-Z]{3,9} /index.php HTTP/
RewriteRule ^index.php$ http://www.wonderstarter.com/ [R=301,L]
View 2 Replies
May 13, 2010
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]....
and under system net
<system.net>
<mailSettings>
<smtp from="Jack <<user name>@gmail.com>" deliveryMethod="Network">[code]....
And the page that sends message is as follows
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.
View 10 Replies
Mar 17, 2011
<configuration>
<system.net>
<mailSettings>
<smtp
from="user@user.com">
<network
host="smtp.server.com"
password="password"
userName="username" />
</smtp>
</mailSettings>
</system.net>
</configuration>
How can I call the "host"setting from the App.config file in my C# code?
I have tried this but it does not work.
SmtpClient mailClient =
new SmtpClient(ConfigurationManager.AppSettings["network"]);
View 1 Replies
Jan 19, 2011
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)...'.
View 2 Replies
Feb 16, 2011
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?
View 2 Replies
Mar 15, 2011
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?
I'm using IIS 7.5 and .NET 3.5 sp1.
View 1 Replies
Sep 1, 2010
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.
View 1 Replies
Apr 13, 2010
How can I "clear" the vendor defined <controls> in my child app's web.config?
Parent Web Config.
[code]....
I have it working for the <tagMapping> section, but <controls> does not support <clear/>.
View 2 Replies
