I 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..?
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]...
can anybody tell me how to show how long your connectionstring has been connected to the database?
View 4 RepliesI am a beginner in using Asp.NET with C# and it is my first time I am trying to establish a connection with an SQL server 2005 database: Here is my simple code to connect to the sql server database,I am getting the text message set in the label. Is my problem in the connectionString ??? how to write it and ow to get the server name and write it correctly ....or how to specify the database name (all path or just database name??)
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection connection = new SqlConnection("server = Saher;Database=Database.mdf;integrated security = true");
try{
connection.Open();
}
catch{
lblMessage.Text = "COULDN'T CONNECT to Stupid database";
}finally{
connection.Close();
}
}
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 RepliesIm trying to get the connectionstring for connecting to MSSQL2008 via JDBC.I now have this:jdbc:sqlserver://L0024:1433;databaseName=weddingAnd also tried:jdbc:sqlserver://(local)/wedding:1433But it keeps saying: login failed for user 'sa'If you see the above screens...what would be the expected connection string?
View 2 Replies<table style="width: 100%; background-color: #B5C7DE">
i have this table and want to change the background-color to be yellow if the server used int he SQL connection string is not 'pheddv20'i am adding c# code to the page load event to check for this and run the dynamic logic. the connection string is held in the web.config as is typically seen...whats the code look like for this type of action?
I've set an AppSetting key for my root directory in my web.config file and now I'm going back through my site and changing all link and resources to use this key. Then If the domain ever changes I can just change one line of code and not worry about links breaking. I'm not quite sure however how to use this when I register my header and footer user controls.
View 2 RepliesI 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 using MS Test to test one of my controller's actions. This method uses the ConfigurationManger to read appSettigns from the web.config. For some reason ConfigurationMangager is not able to find the appsettings.In NUNIT I would just make sure to add a copy of the webconfig file to the test project so that it is available when running in that context. However this is not working for me.
View 1 Repliesi did not realize that: i have a web.config in a separate class library and i was reading the web.config appsetting from different web applicaiton.
i am using VS2010 target framework 3.5
i dont know what is wrong here but i am getting null when i try to get
ConfigurationManager.AppSettings["StoreId"];
string _storeid = GetStoreId;
public static string GetStoreId
{
get
{
return ConfigurationManager.AppSettings["StoreId"];
}
}
<appSettings>
<add key="StoreId" value="123" />
</appSettings>
When I run this piece of code I get this error message:
[Code]....
Error 1 The name 'ConfigurationManager' does not exist in the current context C:UsersPaul HudsonDesktopTT-ASP_Net_My_ProjectsConfiurationDemoDefault.aspx.cs 13 32 C:...ConfiurationDemo
I've tried adding reference for ConfigurationManager but it still does not work, what do I do?
Can we perform Database connectivity without using ado.net?
Can we create our own architecture to connect to database?
I am retrieving value from webconfig file.
PriceCode = ConfigurationManager.AppSettings[d.PriceCode].ToString() == "" ? "XXXX" : ConfigurationManager.AppSettings[d.PriceCode].ToString(),
if the value is found its fine, but if the value is not found in webconfig file an exception is thrown... why is that?
I am maintaining some Asp.net code and need some help figuring something out. Basically I have a C# statememt that reads as follows
String Em = System.ConfigurationManager.AppSettings.Get("EmailAddress")
So something tells me it is trying to read an email address. I looked in the web.config file and I don't see the string "EmailAdress" defined in the <appsettings> tags or anywhere else. Could I be looking in the wrong web.config file? Or where is system.ConfigurationManager.AppSettngs looking for the definition of the email address?
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 RepliesThe other day I came across an alternative way of accessing web.config configuration in some article. It allowed to:provide path to web.config file modify web.config configuration at runtime like:config.MySetting = "new value";load web.config from another web application in the same IIS (I'm not sure about it)work with configuration using class instance instead of static ConfigurationManager class
View 1 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 RepliesThis is a bizarre behaviour I've just noticed, but very dangerous.I have the following line of code:
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["SmartFormsDB"].ConnectionString))
When I run in my dev environment works fine, but when I compile and push my code to the test machine that contains a web.config with a Test DB setting, the test website
still uses my dev connection string. It's behaving as if the connection string was compiled into the binary!
I am having this strange case, at first time when the page loades, everything goes fine. But as soon as I click on any link which makes any ajax request, after that, I get this error while trying to read the configuration."System.Configuration.ConfigurationManager.ConnectionStrings' threw an exception of type 'System.Web.HttpException"I am using asp.net mvc 1.0
View 2 RepliesI 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 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 RepliesI am facing an amazing problem in ASP.NET. I have a website with many sub directories. The sub directories have aspx and aspx.cs files but do not contain web.config files. I am using the web.config file of the parent directory for storing config items for the respective code files in sub directories. But when i m trying to read the web.config using ConfigurationManager.AppSettings[] with absolutely the correct keys, there's no value being returned. Most amazing fact is, this same code works fine in dev enviroment but not in staging.
View 1 Replies