i am making an application in which i have stored connection string in security.cs file under app_code folder...all is my application is going well except update panel of gridview using sql datasouce..i dont know what to write in connection string .. i mean i have connection string in class file.. so what to write in aspx page so that it will get the connection string from app_code
[Code]....
Or any class that's not X.aspx.vb. I've imported the Globalization, Threading, Threading.Thread, and UI.Page namespaces. But it won't come up in Intellisense and it gives error lines in my code. Is there a way to access use the GetLocalResource("Y") method in other classes?
View 3 Repliesjust for my testing purpose i know i can define both the connection's outside in a single web config file by different name's and access them in my front end according to it but what if i want to have seprate for both connection's web.config situation is like this see image so i want to access my connections from second web config file how i can do that.
[Code]...
i tired this but its giving error
[Code]....
I have a single project. and I have two folder in it. In the 1st folder I have a class named Class1 and in the 2nd folder I have a class named Class2. Can anyone tell me how I can access members of Class1 in Class2. I have tried by adding namespace in Class1 and Using that namespace in Class2. But it is giving error. It is easy to access classes or their members from App_Code folder. I don't want to put my classes in app_code folder.
View 5 RepliesI have a single project. and I have two folder in it. In the 1st folder I have a class named Class1 and in the 2nd folder I have a class named Class2. Can anyone tell me how I can access members of Class1 in Class2. I have tried by adding namespace in Class1 and Using that namespace in Class2. But it is giving error. It is easy to access classes or their members from App_Code folder. I don't want to put my classes in app_code folder.
View 3 RepliesI am new for web hosting.My hosting provider use plesk panel for manage websites.I have created MS SQL database using plesk panel. but every time I am getting error when trying to connect ro database. I am using the following connection string.
<add name="ACN" connectionString="Data Source=209.59.179.205SQLEXPRESS;Initial Catalog=ACN;User ID=xxxxx;Password=xxxxxx" providerName="System.Data.SqlClient" />
U can check error detail by just clicking on Login button on [URL]
I want to add connection string to connect to mysql in web.config and access the same in my code c# how can i do this?
here is my code onclick of a button to connect to database.
protected void Button2_Click(object sender, EventArgs e)
{
String a = DropDownList1.SelectedItem.Value;
String b = DropDownList3.SelectedItem.Value.PadLeft(3, '0');
[Code]....
Iam using vwd2008 C# and an MSaccess database and have tried to connect to the database using SQLDatasource.The code example is as follows:
<%@ Page Language="VB" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
[code]...
i have made a project that has an access database.
i have manage to connect and retrive data from the database at aspx and at code behind.
the problem is that i do not want to write the connection string at code behind again and again but to get it from the web.config as i am doing to the aspx pages.
this is what i do at aspx pages:
<add name="dataConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|data.mdb;Jet OLEDB:Database Password=data
@123" providerName="System.Data.OleDb"/>
[Code]....
Although the below connection string works for Select, Insert and Delete functions I can't get to work with Update.
Returns error 'unable to connect to MySQL hosts'
Sub Edit (sender As Object, e As EventArgs)
Dim myConnection As MySqlConnection[code]...
I have fried a multitude of combinations, also from MySQL site without success.
I need a connection string to connect the microsoft 2003 database with my ASP.NET webserviceWhen just making a website I used to use the following connection statement
OleDbConnection dbconn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" + + Server.MapPath("~/db/SalesCentral.mdb"));
Now as I am using a webservice the Server.MapPath function is giving an error
Can any one explain me about App_code folder? AND i want to put some .cs files in that folder. But i coud not see the folder. HOw to add?
View 4 Repliesany one explain me why use classes inside app_code folder or which file add inside this folder and what is the logic of that file and how they work?
View 3 RepliesMy question is: I have update stored procedure in my database (simple update stmt) I am finding difficulty in writing a ADO.Net(C#) connection string for update stored procedure. i have 4 columns and i first 3 columns have constant values. The 4th column values needs to be updated. At the same time i need to increment and then update the table.
View 2 RepliesI have a db connection string 'ApplicationServices' defined in the connectionString section of web.config and 3 Entity Framework connection strings which have the provider connection string attribute with the same connection string as the one in 'ApplicationServices'. Is there a way to reference connectionString in 'ApplicationServices' for the provider connection string attribute of the EF connection string in the web.config, rather than providing the connection string all over again?
View 1 RepliesI have a Windows Service I have developed in Visual Studio 2005 (C#).
It accesses a database using a connection string in machine.config.
On my Windows XP Pro 32bit (SP3) machine, it works correctly.
On my new Windows 7 Pro 64bit machine, it throws "object not set to an instance of an object" when it gets to the line where it's trying use the connection string.
This is the 'object' which is not set in Windows 7:
ConfigurationManager.ConnectionStrings["MyDatabase"].ConnectionString
The machine.config has the same connection string set up on both machines.
A .Net 2 website transferred to the Windows 7 machine has no problem accessing the same connection string.
I have tried a bunch of different permissions on the machine.config and its containing folders, and setting the service to log in as Admin, but I don't know exactly what permissions are required.
I am making use of 3-Tier architecture while making my project. And in Data Access Layer I am making use of application block, but application gets a connection string from web.config; but ClassLibrary of Data Access Layer doesn't contain web config file. How can I access connection string from Data Access layer?
View 5 RepliesI've noticed that with some, but not all sites, if I add a class in a .cs file in the App_Code folder, then I can't reference the class anywhere. In some sites, this isn't a problem. If I move the .cs file to the root, then no problem. Anyone able to explain what's going on here? I have a mixture of sites created in VS2010, along with ones that existed before I got it. Don't know if this makes any difference. More to the point, how do I persuade VS2010 (and I suppose IIS ultimately) to allow .cs files in App_Code, as I find this much neater than having class files littered around the root.
View 6 RepliesI have a question. When I create my website using vwd 2008 express, I can not create App_Code folder, actually there's no selection for App_Code folder when I right click on my website(only Theme, App_Resources, App_LocalResources, App_GlobalResources and disabled App_Data).
I try to add new folder and name it App_Code, then put a class in there. But I can reference to it in my code behind.
Is there something wrong with my VWD installment or this is not supported by Express version?
I have a database on Go Daddy and my VS2008 app can not access it via web.config connection string. Of course runs great locally in development. I copy/pasted the connection string information from Go Daddy exactly into my web.config file. Web site runs fine on the web but when I try to Login at my login page, i get :The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.
I used VS2008 to create the .sql script files and uploaded them to Go Daddy and the Go Daddy people say everything works as they and I can both Login to the database from within GoDaddy.The database i am trying to access consists of the a ASPNETDB.mdf and another Database.mdf together as one in the Go Daddy database.
here is what i used: <connectionStrings><add
name="superskin"
connectionString="Data
[code]...
I was trying to create a Dynamic Data Website using VS 2010 RC. An attempt to create an App_Code folder where I would put a LINQ to SQL class, failed. When I selected 'Add ASP.NET Folder' to add the folder, I had options to create only the following folders:
App_GlobalResources
App_LocalResources
App_Data
App_Browsers
Theme
What happened to the App_Code folder?
Using vb.net/asp.net 2005. I have a project that is done with all vb.net, however I want to get some more experience with C#.Net. I am considering creating a new database class to put in the app_code folder.
View 3 RepliesI have an application which contains different modules from different databases, for instance, I have a table called "ITEMS" in each database. When I create the classes for the table ITEMS I wonder how I can differentiate among them.
For instance, for now, I have "ItemDetails.cs" under App_Code folder BUT I need to create another "ItemDetails.cs" class which will reference the table ITEMS from a different database. If I create folder under the App_code the class name still remains the same.
I could add an acronym in front the class to differentiate which database I am working from but that makes the class name too long.
I appear to have hit a brick wall whilst attempting to debug some C# code that resides in the App_Code folder.We have an established ASP.NET solution and I've just been brought onto the team. Unfortunately when I run the code [which successfully debugs (to a certain extent)] it does not step into a *.cs file that exists in the App_Code folder.I've found several posts on the subject, none of which seem relevant to me.
Specifically:
Running Win7 Enterprise 32 bit VS2005 8.0.50727.867 (vsvista.050727-8600) http://forums.asp.net/p/958358/3675792.aspx#3675792 mentioned removing the "+optimize" in the web.config file; this doesn't seem to be relevant to me (<compiler language="c#;cs;csharp" extension=".cs" compilerOptions="/d:TRACE"
type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>)
The "App_Code" folder doesn't seem to have any peculiar setting associated with it
I also said that debugging works successfully "to a certain extent". I've set up Visual Studio with the C# developer environment. When I hit F11 I would expect the IDE to begin debugging and for the execution point to stop on the very first line of code (this is what it does in all my other projects in VS2003 & VS2008). However, when I hit F11 it acts like F5, running until it either hits a break point or a run-time error. I'm wondering whether this may be related to it not even hitting break-points in code in my App_Code folder?
I just added update Panel for Ajax..
Inside the update Panel I added few controls, which I cant Access them regular
like TextBox1.Text.
What should I do?