I have a dropdownlist which is connected to object data source for displaying data, now what I need is to connect to database using semicolon seperated list from web.config connection strings and then connect that to dropdownlist.
View 5 RepliesI'm using Visual Studio 2008 and SQL Server 2008 Developer to create a website.
I'm trying to test a connectino to a local database in my computer.
What I did is create a connection string in the webconfig file like this:
[Code]....
Then I want to call that connection string like this in the default.aspx.cs file I write the following code:
[Code]....
I'm not getting any error or warning in any of the code but when I run the page I throws me an error telling me:
The connectionstring property has not been initialized.
If I run with debug on it shows this:
[Code]....
Line 22 in red.
I don't know what I'm doing wrong since VIsual Studio does not tell me there is an error, it just seems like it cannot make the connection.
I would like to use the webconfig file to store some values, which will be used in my application in order to execute some methods, one a parameter for a timer, the Interval property and the other to pass as parameters in a method.
So, my questions are:
Where in the webconfig can save these parameters in order to make them accessible to the applicationHow do I access these parameters in my application in order to use in the aspx page for the timer control and in the code behind for a method to use
how to set the <xhtmlConformance mode="legacy"/> tag in web.config as "strict" using the codes in c#.net for an asp.net webaplication
View 1 RepliesI'm new to java and android, originally from an asp.net/c# background.I am looking for a config file in java, similar to the webconfig of app config with .net but there doesn't seem to be one.
View 3 Replieshow can i access 2 external config files from web.config file.
i have done it for one external file like this in webconfig:
<appSettings file="........">
Now how can i access the second external config file from same webconfig.
I have the following webconfig file that redirects (once logged in) a specific user...but for some reason it's not seeing the redirect location. So, for some reason when john123 log's in he doesn't get sent to superUser.aspx. It's as if it's not seeing the location path.
View 3 RepliesI have created a webservice, which debugs fine with no errors, and published this on my localhost server for testing.
I have created a windows app which calls the webservice but am hitting problems as soon as I reach the point where the webservice tries to connect to its database.
The connectionstring is held within the web.config file of the webservice as
>><connectionStrings>
<add name="MyConnectionName" providerName="System.Data.ProviderName" connectionString="server=MyServerName; database=MyDataBaseName;uid=MyUser;pwd=MyPassword;"/>
</connectionStrings>
and called within the code by using the statement
>> System.Configuration.ConfigurationManager.ConnectionStrings["MyConnectionName"].ConnectionString
, and as I said before, this works perfectly when debugging the webservice application directly.
However, the windows application is not seeing the connection properly, if I use the statement as above I get a debug error stating that it is a NULL reference. If I change it to
>> System.Configuration.ConfigurationManager.ConnectionStrings[0].ConnectionString
I no longer get a debug error, but the connection is not made. On testing the above code it believes the name for connection 0 is "localSqlServer" and in both the web app and the webservice the error below is returned.
>>An attempt to attach an auto-named database for file \MyServerMyDirectoryMyProjectMyProjectApp_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
why the windows application see's the correct connection string code as null? Is there additional security I need to add for the web.config file to be accessible? Or does the connection strings need to be relicated within the app.config of the windows app?
Both applications are written in C# and I use Visual Studio 2010, ASP.Net version 4.0.30319
How do I call the connection string in the webconfig file from a web form?
View 4 RepliesI have an asp.net3.5 app. It has multiple client folders in the root folder. There are multiple web.config files. One is in root folder and one each in client folder. The web.config in client folder contains connection string for the database to be connected. I am using FORMS authentication. Each client has a specific page which are lying in root folder. This page redirects to the client specific folder and user logs in the application using the one more login page which is in client folder. And this page uses the connection string which in this client specific folder web.config.Now my problem is that I am not able to connect to the database using the client specific web.config on my live server. Live server is a Windows 2008 Datacenter and IIS7 machine. And my local system is XP IIS6 machine.Please help me to resolve this issue. Or how can I configure my application on IIS 7 &Win2008 DC system in WINDOWS authentication mode?
View 2 RepliesHow to set Trust level "FULL" in webconfig file.
View 1 RepliesI tried to set the session state in my webconfig file and got this error.. <sessionState timeout = "60"/>
Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.
However if I tried to set it in anther aspx page it seems fine...is there a reason for setting up the virtual directory as an app in IIS ..what are the benefits of doing this, and is it always necessary?
I am working on an asp.net (or winforms) app that is supposed to detect wifi connectivity and strength. The intention is to provide the field agents with an indicator that they can connect to our main office
What would I need to detect wifi connectivity?
Is it possible to integrate Nokia connectivity API with asp.net? If so, How to get started?
View 1 RepliesI'm just starting development on a new website and am trying to do it correctly, that is, with a DAL and not with queries in code which I had before. I understand the principles of it all, but I am finding this DAL with table adapters and wizards that do too much to be really messy to work with. Does anyone have any recommendations on what I should be using instead and a link to a tutorial on how to get going quickly with it?
View 5 RepliesI am not able to use
String connectionString = ConfigurationManager.ConnectionStrings["DevBackup"].ConnectionString;
I am getting error 'The name 'ConfigurationManager' does not exist in the current context' I have used namespaces
using System.Data.SqlClient;
using System.Data.Sql;
what should be done..?
Can we perform Database connectivity without using ado.net?
Can we create our own architecture to connect to database?
I have MS SQL Server2005 enterprise edition. And MS VS.NET 2008. And have IIS 5.0 (which is available in XP professional). Now I want to run .net web application in our intranet (LAN). But I can't access database. Only static pages remain ok....but can't invoke database
View 16 RepliesI'm not having much fun with connection pooling. The website I've written does dip into the SQL server all the time and quite a lot of times per page. Every time I nip into the SQL Server to get or set something I open a connection...
comGeneral.Connection.Open()
... do or get what I need and then close it. From what I've read any of the following should close the connection and return "one connection" (?) to the pool (top one, only if reading)....
rdrGeneral = comGeneral.ExecuteReader(Data.CommandBehavior.CloseConnection)
comGeneral.Connection.Dispose()
comGeneral.Connection.Close()
... but that's not really working for me and I keep hitting the default max 100 open pools. So I've been doing all 3 of the above (again, top one, only if reading). But alas, still the stupid thing (Yes, I am aware I'm the stupid one) keeps hitting the max.
My new plan is to set pooling to false (pooling = false ?) across the entire website and take the performance hit which wont be terrible because I don't really do anything too demanding. Trouble is I don't know how, other than setting Pooling = False, but where exactly in the webconfig would this bit of code go?
I have Visual Studio.When a create a new ASP website (so not a project), I can go to the configuration management and enable roles and an aspnetdb.mdf is automatically created in the app_data directory.When I create a new ASP (MVC 3) project, the configuration management says: can not load MvcApplication1.MvcApplication .Is there some configuration setting for this?
View 3 RepliesHow to create a JSON webservice in ASP.NET that connect to MS SQL Database and update/delete values from the database?
This webservice will eventually be used to communicate with iPhone SDK.
Ive integrated a custom asp.net web application into a Sharepoint site by creating a virual directory, that contains my web app files, that points to a directory in the Sharepoint inetpub folder.
On my local dev server I can access all my web app pages just fine by typing in /virtualdirectoryname/page.aspx
My Problem is that: When I deploy to my Live Test server that is internet facing, none of the pages that make a MS-Access database call will work.
The Error I receive is '[SecurityException: Request for the permission of type 'System.Data.Odbc.OdbcPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.]'
I have researched the issue online and tried numerous solutions which include giving all the assemblies in my application a strong name, and modifying the security policy to trust this strong name.
My Custom Web App consists of 2 projects
1. A Class Library Project (Data Layer)
2. A Web Application Project (Web Layer)
My .mdb database file is stored at root level within the Virtual Directory.
I have 1 class in the Data Layer (ClassConnect.cs) that when instantiated, creates the ODBC connection for all other pages to use (OdbcConnection dbConn = new OdbcConnection();)
I have a Connection String stored in the web.config file that is as such. When I deploy to the Live Test Server I change the path in this connection string, because I haven't figured out yet how to get a relative path that works.
I also place the dll's for my 2 projects in the Sharepoint bin folder.
Could anyone suggest what might be the dfference between my Local Dev Server and the Live Test Server and why I might be getting these errors.
what code should i write in web.config for the connection string for DB connectivity woth ado.net component??
View 2 Repliesis there any way to add HttpUtility.HtmlDecode = true in webconfig.i have 1000's of textboxes. i cannot add this all of them.
View 2 Replieshow can i register Control on runtime in webConfig
View 5 Replies