First off, I am just getting started with ASP.NET so I expect this is something that I am doing.
i am trying to make a connection to a MS SQL database on my local machine.
I have the following in web.config
[code]....
I try to connect my database for so long so i wrote two type of codes. Let's discuse first on.
I have database called PhoneDirectory.
It have only one table named Residents.
I have button wiht ID="Button1".
I want when i click this button to see all of my residents.
I want to see the result in DetailsView and to be able to edin, delete and add new resident.
First try with SqlDataSource so i wrote this:
<asp:SqlDataSource ID="Resident Details" runat="server" ProviderName="System.Data.SqlClient" ConnectionStrings="<%$ ConnectionStrings:ThisIsTheConnection%>"
I devlopyed on asp.net application in IIS, i need to know how many current database connection is open for the database..
so how can i check how many connection are currently using for this database... if we dont want some connection how can we kill the connection
I'm having a problem, which I haven't had with other projects, in setting up membership. I have set up a aspnetdb database using the asp.net confirguration tool. The database is in the app data folder and I can set up users and roles etc from the web site administration tool. However, trying to log in within the application, using the login control I get "Login attempt was not successful".
I have noted the following :-
1. On the home page of the Web site administration tool the application:/ shows no application where as normally it would show the name of the application.
2. Clicking the AspNetSqlProvider test button, I get the error "could not establish a connection to the database"
3. Although various lines have been added to the web config file, no connection string has been created to the aspnetdb file in the app data folder.
4. If you right click on the aspnetdb file within the solution explorer, there is an option of "include in project". Selecting this doesn't however solve the problem.
I'm trying to weigh up which is the better most reliable database connection for use on a vb.net/ms sql site. I've previously experienced problems catching and closing db connections with the using statement if an error occurs, but do like the fact it doesn't need to use any global variables. Both examples use a general Database class file which opens and closes a connection.my current examples are: TRY CATCH EXAMPLE:
[Code]....
[Code]....
[Code]....
and i am receiving error as
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Description:An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
how make the class for database activities and it can be used in code behind
coz i want avoid the connection opening, closing activities, insert,update etc methods in code behind frequently.
the class should include connection open and closing method, passing values to stored procedures etc.
How should we construct it?
When I load my page I populate my repeater with the following code.
Dim conn As Data.SqlClient.SqlConnection
Dim Comm As Data.SqlClient.SqlCommand
Dim reader As Data.SqlClient.SqlDataReader
[code]...
My website is working but when I host it up, the connection are all screw up. Is it because my connectionString are all linked via SqlDatasource and is for local files only? Whats the coding that I need to put in so that my site will connect to the database via accessing the web.config or server?
View 11 RepliesI am designing a web application and have separate layers for UI, BAL, DAL and DB, while using custom business objects and collections. The app will be used by over 10,000 + registered used and it becoming more complex as I add new functionality such as inline editing and batch processing of collections with transactions ... which has me up late at night trying to design the best approach for this ...In some UI web forms, I bind say 3 controls to 3 different collections. The UI calls the BAL classes for the required collections, then binds the collection returned. So for each collection I want, a db connection is opened and closed. As I understand database connectivity adds overhead so Is there anyway I can design this so 1 database connection is created for a unit of work in a 3-tier or n-tier architecture?
View 7 RepliesHow do we convert, the following code to query a SQL database with ASP using a DSN-less connection
[Code]....
Is it mandatory to close database connection in enterprise library 4.1?
View 1 Repliesam writing a series of WSS/MOSS webparts amongst which one will need to detect the current SQL Server database connection, prompt the user to setup a new connectionstring, and fire appropriate stored procedures to create a new database if needed. The user needs to be presented a textbox or label control with the current database connection. I've never had to detect current database connection, what methods do I call for this? If the desirable connection is not present, the web application needs to prompt the user to make a new database. The user really won't make the database, they simply need to click the command button which will fire the stored procedure to create the database.
View 1 RepliesI am copy my Data Source code and CS code here.
*******DATA SOURCE************
<add name="Streaming_ServerConnectionString" connectionString="Data Source=WIN-6BTHP5JUMMDSQLEXPRESS;Initial Catalog=Streaming_Server;Integrated Security=True"
providerName="System.Data.SqlClient" />
unitnm;
int unitno;
sring connection;
unitnm = txtUnitName.Text;
unitno = Convert.ToInt32(txtUnitNo.Text);
connection = System.Configuration.ConfigurationManager.ConnectionStrings["Streaming_ServerConnectionString"].ConnectionString;
string sql;
sql="insert into [UNIT](UNIT_NO,UNITNAME)values('"+ unitno +"','"+ unitnm +"')";
SqlConnection conn = new SqlConnection(connection);
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
the above code is perfectly work on the Local Machine. But when i try to insert data from the remote location. It will shows me error. The errors as follows.
"Cannot open database "Streaming_Server" requested by the login. The login failed.
Login failed for user 'IIS APPPOOLss'"
I am writing a page for creating a new user for a website. After the user fills out the form and click the "Create User" button, the information provided is supposed to be sent for storage to the database. I have been getting the same error message for a couple of days now and I've ran out of things to try. The message doesn't seem like a complicated issue, in fact it's quite common and found a great deal of information on how to resolve it. However, nothing I've tried works. I'm using VS 2010, and SQL Server Express 2005. The message I get is the following:Cannot open database "[database]" requested by the login. The login failed.Login failed for user "[MACHINE_NAMEUSER]".I have added my current Windows account to the Users folder under the Security folder through Management Studio and granted it all the role memberships. I'm also using Windows authentication. If there's any information I'm not providing to figure out what's the issue, let me know and I'll post it.Stack Trace:
[Code]....
While trying to access SQL server DB from ASP.net web application, I am getting error as follows,Cannot open database requested in login 'ASPState'. Login fails. Login failed for user 'CxxxIWAM_Cxxx'.In the tutorial I am doing, its mentioned to add these before I Start
View 4 Replieshow to create multilanguage website using database not localization
when i select desired language ,data in datagride display with that language. how to make that to all my website pages
I'm using an ODBC connection to connect a SQL 2005 database to my ASP.NET app in Visual Web Developer Express. I'm finding that the expected functionality that tutorials review does not work for ODBC connected databases the same way as it does for SQL databases created in the Web Developer. For example, I can't use stored procedures because the option to create one is disabled in the Web Developer, and if I create the stored procedure in SQL Server Management Studio Express, it doesn't show up in Web Developer because Web Developer only finds the system stored procedures, not the user-defined ones. I've seen other cases as well where database management options in Web Developer don't work with ODBC databases.
Am I missing something in my setup, or is there an inherent limitation with ODBC connected databases? Or, is this a limitation with using the Express versions of these development tools?
I am trying to make a routine system(school, college) where i will use three text field as input1> Class start time(input: 8:00 AM) // when school/college will start.2> Class ending time(input: 1:00 PM) // when all of my class will finish3> Duration of class(input: 1.5(hour))// class hourdesired output: A class routine where time(hour) will be shown in row and Day(e.g, sunday,monday) will be shown in column.questions:
1> how i'll take the input as time:hour from text field?2> how i can save the calculated time in database for use in other page?
I am using VS2008 and oracle 10g ODP.Net. The oracle database that I used in the connection is working and tested it using sql plus.The connection string when used in a GriDView works perfectly. Now when I created a new listview control with the same connection it gives an error.Database schema could not be retrieved for this connection. Please make sure connection settings are correct and the database is online
Object reference not set to an instance of an object at VSDataObjectSupport (478,6)
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$appSettings:ConnString%>"Â SelectCommand="sql query ............."
This is in design and with the above I have
 SqlDataSource1.SelectCommand = "sql query ............. " in code behind
but if i have the connection in code behind. How do I execute
SqlDataSource1.SelectCommand == "sql query ............. "
It without any reader or dataset...
When I'm using this to open Connection to DB,
Do I need to Close it at the end?
Or by using it, it close by itself?
using (SqlConnection cnn = new SqlConnection(connectionInfo))
I have an application with a few dbml files to connect to several sql servers in order to import data from one to another using Linq to SQL.
There are 2 connection strings with integrated security and in one I provide user ID and password.
It all works great in the development workstation. I've then wrapped the dll project and deployed the asp.net application to a test server. Then, when I tried to run the application to import the data, I got a connection exception:
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)
I figured out after some debugging the problem is with the DataContext whose connection string is the one I provide user ID and password. Now, the funny part is that the same connection string works if I create a udl file and test it. And again the same connection string works with my development workstation.
I've a web form named contest, where users are to register for it. When the register is clicked on, details entered by the user will be saved into the database, but before it will check if the user has already participated in the contest (using AJAX). If the user has already participated, the button will be disabled. The problem is there is an error when I click on the register button.
The error:
ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.
Here's the codes I use:
[Code]....
If I m using Windows Auth in my connectionstring i.e Integrated Security = SSPI / Trusted_Connection = Yes,
Is there any way to retrieve the USERID that is being used to make connection?