Web Forms :: Connection To Database From Local Visual Studio Not Working - Code In Separate File?
Mar 11, 2010
I recently started NOT putting code in separate file. I am using vb. I am having a problem with my database connection. The live code is working just fine....but when I try to debug locally. i get this error. connection to the database from my local visual studio is not working. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
<%@ Page Title="" Language="VB" MasterPageFile="~/MasterPage.master" %>
<script runat="server">
Const ConnectionString As String = "Data Source=1234.database.com;Initial Catalog=database_name;Persist Security Info=True;User =user_name;Password=123456"
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
Dim MyConn As New Data.SqlClient.SqlConnection(ConnectionString)
Dim cmd As New Data.SqlClient.SqlCommand("Select count (*) from Classifieds where (ClassifiedCatagory = 'Antiques')", MyConn)
cmd.Connection.Open()
Dim count As Integer = cmd.ExecuteScalar() 'this contains the number of records
Label_Antiques.Text = count
cmd.Connection.Close()
I'm missing a the code browser when I create pages that have the code not placed in a seperate file. For pages with .asp.vb files I get the browser correctly.
I think it's called a code browser but just in case it's not I mean the dropdown that shows Page Events, Buttons and other controls that can be selected along with their events.
How do I turn on those dropdowns for pages with code behind that uses <script> tags in the actual .aspx page?
Included (Showing page events just under the tab):
This question has probably been answered before, when adding a new web form, I do not see an option that allows you to place code in a seperate file for a project (it does it automatically). But for websites, I see the option. Am I missing some option?
I used Data Connections to connect a database but couldn't make it.
1. I used Windows Authentication to log on to database, my database's name wasn't displayed in Select or enter a database name dropdown menu, so I enter my database's name then I pressed Test Connection button, it said "This connection can't be tested because the specified database doesn't exist or isn't visible to the specified user."
2. So I used SQL Server Authentication to log on to the server,then I put my database's name in Select or enter a database name dropdown menu box, then press OK it's said that "Login failed for user 'xxx' or Try to press Test Connection button it said that "Login failed for user 'xxx'.
I'm sure that I use a correct username and password and I think it's a problem about VS can't see my database in SQLExpress2008.
When I open an ASP.NET 3.5 project using VWD2010, I get a prompt error message,"The connection property in the web.config file is missing or incorrect.The connection string from the .dbml file has been used in its place."however, my project works successfully.
I am a complete newbie when it comes to ASP.NET and SQL database access. I'm trying to learn so that I might become gainfully employed one day soon and better my life. I'm running through the Visual Web Developer Express 2008 beginning walkthroughs right now and I'm already stuck on the third one -- Walkthrough: Basic Data Access in Web Pages. I've installed MS SQL Server 2008 and downloaded the sample Northwind and pubs databases, and even (I think) attached the pre-built files using the DOS command: sqlcmd -S .SQLEXPRESS -i instnwd.sql. (Output was: Changed database context to 'master'. Changed database context to 'Northwind'.)
But, now, when I try to Add Connection through the Database Explorer in VWDE2008, nothing comes up in the Connect to a Database field. Shouldn't it auto-populate? If I'm supposed to manually type a name in there, what should it be? I've tried "Northwind" and "SQLEXPRESS" with no luck (getting a generic Unable to Connect message). I've verified the database is running with SQL Server Configuration Manager and that all Client Protocols are enabled.
I'm using Visual Studio 2008, and my database is SQL Server 2000.
I want to add a connection to the Server Explorer in VS. The Data source is Microsoft SQL Server (SqlClient). After entering in all my information and I click Test Connection, it is successful.
But when I click OK, I get the error:
Unable to add data connection. ExecuteScalar requires an open and available connection. The connection's current state is closed.
Background: I use SQL server 2005 developer edition and visual studio 2008. Visual studio 2008 is running on a local machine with Vista business edition. SQL server is running on a remote server using Windows server 2003. Both computers are within the same domain.
Problem: First, I used the server explorer to connect to the SQL server. Everything works as desired. Then I write code to do the same thing. I keep getting the following error message:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
However, I used the exactly identical connection string as the one used in the server explorer. So connection string should not be the problem. In addition, I tried the test code in MSDN, which tells whether my domainusername can flow the network. It turns out the user name is fine. I also went to the SQL server management studio and found the login for my computer is NVCWeihao while my computer login name is NVCweihao. I am wondering if this uppercase letter really affects the connection.
I have weird issue here, I have a method that takes a login Id and authenticates with LDAP active directory and returns the employee Id. It works great when I run the application in Visual studio 2008 ( it uses the default visual studio developement webserver). The code authenitcates the login id and returns emp Id perfectly. But the problem comes when I publish the code to the Local IIS in my developement PC.
I have VS 2010 professional. I am trying to open "ASP.Net Configuration" through Project -> ASP.Net Configuration.
It pops up the Notification about the ASP.Net Development Server localhost but doesn't open ASP.Net Configuration in the default browser.I clicked on the Root Url (by double clicking on the 'development server' at the right bottom from Notification Manager).
It throws following error
"An error was encountered. Please return to the previous page and try again."
Clicking on "How do i use this tool".It opened page with error.
In an ASP.NET web application using C#, when we double click on design it will go to code behind page (cs file), but problem here is, when we double click on design its going to script of source file. Why it is happening?
I'm currently editing some html/css within a aspx file inside of Visual Studio 2010. I'm using Chrome as my browser. When I make changes inside of Visual Studio and save/ctrl + F5 to run it frequently fails to load the new updated .css file due to pulling old cached versions of the CSS.
I've used visual studio as my primary HTML editor before but when I work with pure html/css files I just save and refresh the file in chrome and it will refresh the updated css 100% of the time. I've only started to experience this problem when working with aspx files and running things via ctrl + f5. Anyone have any ideas of how I can fix this?
I just recently upgrade my asp.net web project from visual studio 2005 to visual studio 2010. The upgrade was successful with no problems however im missing some features with this project. The One Click Publish feature(which is greyed out) in the header area of Visual Studio 2010 and the Add Config Transforms feature which is no where to be seen when you right click on web.config. When i create a new web project straight from visual studio 2010, these options work fine.
what's up with the new 2010 version of VWDExpress? It seems it no longer creates the VB code behind file to go along with the markup pages. Is threre a setting somewhere that I've missed? Or is code behind no longer supported?
My application is working fine in local environment but not working after push code in live. My locale environment and hosting environment both are having same configuration. Same app working fine 2 month before but in different domain but same hosting server.
how to check the both config / any possible to run debug mode in hosting server please let me know. below code used in all page for checking user session status but when I click on any link page redirect to login.aspx I think session got timeout. I don't know why session got time frequently, but this issue not happening in local environment (desktop).
I am in the process of adding my custom aspx pages to the LAYOUTS folder(a folder I created) in a WSPbuilder solution in VS08. The problem I am having is when I build the solution it fails because the controls(Load, Textboxes, dropdown lists,etc) in the code behind file for the custom aspx pages say they are not defined. They all have a blue squiggly line and I get over 100 errors.what to do to get the WSP to recognize the code behind pages.
I am using some code I found that generates a random password. I am in the habit of putting code in a seperate file. The code was written in the same file and I'm trying to move it to a seperate file and get the following message. Also, below, I posted the original code (code on same page as aspx) and what I did (code in seperate file).what adjustment needs to be made to make the seperate code file work?
Compiler Error Message: BC31143: Method 'Public Function GeneratePassword(length As Integer, numberOfNonAlphanumericCharacters As Integer) As String' does not have a ignature compatible with delegate 'Delegate Sub EventHandler(sender As Object, e As System.EventArgs)'.
I am developing a web application in which I am suddenly facing an issue. I have a webpage which contains many controls, one of the control is JQuery color picker. Now, I am upgrading my system with telerik controls. As part of this process, I replaced textbox(txtcolor) with radcolorpicker with a different id(colorPicker). Suddenly, my code behind file is not throwing any errors like 'unable to find txtColor'. It is running successfully without build errors. But, when I open the page, system is throwing runtime exception(txtColor not found) which is correct.
I tried to change other controls with asp.net controls, still the problem persists. So, I dont think it is anything to do with telerik.
I have an intellisense problem in VS2008.I use code-behind, and though I can declare ASP elements in the aspx file, it's as if the code can't see them.The pages run OK,but when I type anAspLabel and then '.' for example, intellisense does not pop up the methods and members for this asp label.
I've tried the reset option in Options > Text Editor.Intellisense works fine if the class instance is declared in the code behind file,but it won't recognise web controls declared on the aspx page.
I'm working with VS2010 and I wonder should I use one Solution for multiple web applications (web sites) or is it better to create separate web applications (with it's own solution) for each web site?
