DataSource Controls :: How To Prevent Multiple ConnectionOpen/ConnectionClose
Oct 13, 2010
I'm writing a page that gets info from my database quite often, but on different events.
To demonstrate, There are three buttons- "Adults","Kids", and "babies".
When clicking on "Adults" the code fetches info from the "Adults" table and displays it.
Everything is working well, thing is I'm not sure that the way I implemented it is good enough.
What I did is that on each button click, in the eventhandler a new instance of the connection object is created, with which I open a conneciton, fetch the data, and than close it.
So, if I have 3 buttons- there are three different connection objects, in three differenct eventhandlers, each doing his own Open-Close.
Thing is the page needs to expand to 19 objects (give or take) where not all of them are buttons, each of them should access my datasource- and I'm pretty sure that 19 times creating a connection object + Open-Close operations for each is the wrong way.
View 6 Replies
Similar Messages:
Jan 26, 2010
On our company we have a intranet site which uses ASP classic to authenticate users before accesing the site. This site was working before but suddenly i throws an error which limits the users in accessing the intranet site. I made a debugger page in order to know the error of the application and it showed me this error [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. On my local machine the page is accessible on my (IIS server) the connectionstring in the web server and in my localhost are the same. I just can't figure out what's causing this problem.
View 2 Replies
Dec 14, 2010
I have a button in my dataview that drives the update:
<asp:Button ID="btnUpdate" runat="server" Text="Submit Bid" CommandName="Update"
View 6 Replies
May 31, 2010
i need all the details to How to prevent by sql injection by using stored procedure .
View 7 Replies
Feb 13, 2010
I have this "SP" that will insert one record to Table 1 and multiple records in Table 2 ...
I just need a way to prevent null values to be inserted in Table 2 ? here is how it looks in my table 2
ID Col1 col2 Col3
3 AB CDE EFGs
4 NULL NULL NULL
4 GDF SSS DFGD
i don't want to insert the second record ... how do i do that using existing "SP" ?
here it is my SP :
CREATE PROCEDURE dbo.Insertvalues
(
@newParentName NVARCHAR(100),
@NewJobTitle NVARCHAR(100) ,
@NewDepartment NVARCHAR (100) ,
@NewCompanyName NVARCHAR (100) ,
@NewURLAddress NVARCHAR (100) ,
@NewOfficePhone char(15),
@NewFax char(15),
@NewMobilePhone char(10),
@NewEmailAddress nvarchar(50),
@NewChiledGroup NVARCHAR(100) ,
@Newchiled_jobTitle nvarchar(100),
@Newchiled_department nvarchar(100),
@Newchiled_phone char(15),
@Newchiled_mobile char(10),
@Newchiled_email nvarchar(50),
@NewChiledGroup1 NVARCHAR(100) ,
@Newchiled_jobTitle1 nvarchar(100),
@Newchiled_department1 nvarchar(100),
@Newchiled_phone1 char(15),
@Newchiled_mobile1 char(10),
@Newchiled_email1 nvarchar(50)
)
AS
-- add parents group
INSERT INTO parents_group (Name,JobTitle,Department,CompanyName,URLAddress,OfficePhone,Fax,MobilePhone,EmailAddress)
VALUES (@newParentName,@NewJobTitle,@NewDepartment,@NewCompanyName,@NewURLAddress,@NewOfficePhone,@NewFax,@NewMobilePhone,@NewEmailAddress)
--obtain inserted id
DECLARE @NewParentId INT
SET @NewParentId = scope_identity()
-- insert into childe table
INSERT INTO childe_group
(groupId , chiled_name,chiled_jobTitle,chiled_department,chiled_phone,chiled_mobile,chiled_email)
(SELECT @NewParentId,@NewChiledGroup,@Newchiled_jobTitle,@Newchiled_department,@Newchiled_phone,@Newchiled_mobile,@Newchiled_email)
UNION
(SELECT @NewParentId,@NewChiledGroup1,@Newchiled_jobTitle1,@Newchiled_department1,@Newchiled_phone1,@Newchiled_mobile1,@Newchiled_email1)
GO
View 5 Replies
May 13, 2010
I have access to two servers, one with my development database on, and another with the live database on.
All SQL Stored Procedures, Functions, Views are encrypted on the live database (using WITH ENCRYPTION in my query)
However I'm concerned I might accidentally encrypt a bunch of SProcs on my development database meaning I can no longer view/edit that code.
I have full control over the server and database, and was wondering if there is a way I can prevent these from being encrypted, therefore throwing up an error when this is attempted?
View 4 Replies
Jun 1, 2010
I've been reading up on SQL Injection and want to go back and implement some measures to prevent these kinds of potential attacks.For example, on our company intranet, we have an address book feature and a search function so the user is able to look a company or a person up from the database/The user will enter their query into a TextBox control and click the Submit button, calling the following function:addybookDS1.SelectCommand = "SELECT * FROM [addressbook] WHERE COMPANY LIKE '%" + search1 + "%' OR CONTACT LIKE '%" + search1 + "%' OR LASTNAME LIKE '%" + search1 + "%' OR EMAIL LIKE '%" + search1 + "%'"search1 is the TextBox controlI had previously implemented this measure:search1 = Replace(search1, "'", "''")But I want to know if there is more I can do here and how I can go about doing it.
View 16 Replies
Mar 7, 2011
I am trying to design my logic to do this but I want to create a dataSet which will have records from several databases, The records all have the same layout.
I am reagin the connection string paths from a table in a database.
I am asking for your help in trying figure out my logic.
Should I use the connectionString builder in conjunction with a loop to Connect, read a record into a dataset Until therer are no more records to be read from my databse table with the database name/paths tables ?
Here is my beginning code which deals with one database:
[Code]....
View 2 Replies
Jun 4, 2010
Would it be better to have a sp return multiple result sets and use NextResult() or have subsequent call to dr.execute.... () and hadle one result at a time?
To me using nextResult() on a multiresult datareader would be cleaner and easier - but it does not seem to be very "atomized". I guess I am wondering can the cost of executing multiple commands be neglected? Seems like executing multiple commands and receiving a single result set would also be easier to read/test/understand.
View 1 Replies
Apr 1, 2010
Is there an easy way to prevent users from opening multiple instances of the same web application? Can I add something to the application start section of the global page which would prevent this?
View 4 Replies
Jun 19, 2010
I want to prevent multiple user login for same user in asp.net.. How can I achieve. Note: I want to control without database concepts
View 2 Replies
Apr 8, 2010
how to prevent multiple user to be logged in at a time using a user id ?
I searched the internet and found some ways but somehow they do not work in these situations:
If javascript in brower is turned off.
If user do not click logout and directly close brower.
View 4 Replies
Feb 11, 2011
I am trying to prevent multiple simultaneous logins in my web application. I want to signout all/any previous authentications of a user when they login. Such that the current login remains the only one.
How do I go about calling FormsAuthentication.SignOut() for a particular user to invalidate any existing authentications.I have tried searching everywhere but no answers, only theories.
View 2 Replies
Aug 28, 2010
What whould be the best way to prevent multiple users on a page?
For example if a user is at the page "Home.aspx", no other users should be allowed to go there.
I'm using asp.net on the server and the js-frameword jQuery on the client side.
View 4 Replies
Jan 27, 2010
how to prevent multiple login using vb.net? I'm using visual studio.net 2008
View 6 Replies
Nov 2, 2010
I am using the provided ASP.NET SQL Membership & Role providers in my application.
How can I prevent that the same user does login from different workstations using the same credentials? I can imagine to use the IP address for this but I dont really know where to start from...
Also what about users behind the same router? Is there a way to prevent them access from different client PC's?
View 2 Replies
Jan 14, 2010
I managed to user to perform multiple log on from other IE window session in my web application if the same log on is currently being used.Unfortunately I have problem to control multiple log on if the user is logging in using tab browsing in the same session. I know this is due to the same session Id but is there any way to trace down to the tab level within the same session?
View 2 Replies
Feb 16, 2011
prevent multiple clicks on Submit, I am using
//to prevent multiple clicks
this.imgGonder.Attributes.Add("onclick", "this.disabled = true;" + this.GetPostBackEventReference(this.imgGonder));
in PageLoad()...
this works fine while testing and %90 other users. But I still see some duplicates in database from other users.
View 5 Replies
Jan 26, 2010
I am looking at how best to prevent a single user account logging on multiple times in a webforms application. I know that MembershipUser.IsOnline exists, but I've read a few forum and blog entries suggesting that this can be unreliable, particularly in scenarios where a user closes a browser (without logging out) and attempts to logon with a different machine or browser.
I looked at implementing a last past the post type system; when a user logs on older users are simply kicked off. It seems that FormsAuthentication.Signout() only works for the current user.
Am I missing a trick, is there a better way to prevent the same username logging on from multiple different locations?
View 2 Replies
Jul 17, 2015
I just want to detect who came to login into site and if same login already logged in ,if same login previously exits then we need to logout the previous session , how to do it using asp.net c#
View 1 Replies
Jul 10, 2010
So its a ASP.NET problem where two users using the same machine, same browser:
User 1 logs in the domain.
User 1 changes some data without saving it.
User 2 logs in the domain in a separate tab.
User 1 switches back to his tab and saves the data.
User 1 actually saved the data into User 2!!
This is caused by the following mechanism:
Different tabs in the same browser seems to share the same session id.
We are storing user auth in cookie and the cookie is shared between tabs (same domain)
Therefore, when User 1 request to save, it is recognized as User 2 since the cookie has been updated to User 2.
So I'm wondering if there's any other methods to prevent this from happening, other than:
1. Use cookieless session so the session is embedded in uri.
2. Always include a hidden field in page to indicate which user owns the page.
View 3 Replies
Mar 25, 2010
I have ASP.net application that is basically a data entry screen for a physical inspection process. The users want to be able to have multiple browser windows open and enter data from multiple inspections concurrently. At first I was using cookie based sessions, and obviously this blew up.I switched to using cookie-less sessions, which stores the session in the URL and in testing this seemed to resolve the problem. Each browser window/tab had a different session ID, and data entered in one did not clobber data entered in the other.
However my users are more efficient at breaking things than I expected and it seems that they're still managing to get the same session between browsers sometimes. I think that they're copying/pasting the address from one tab to the other in order to open the application, but I haven't been able to verify this yet (they're at another location so I can't easily ask them).Other than telling them don't copy and paste, or convince them to only enter one at a time, how can I prevent this situation from occurring?
View 5 Replies
Jan 26, 2014
How can we prevent non ahuthenticated users from like and dislike multiple times?one way : save Ip address in a cookiebut theres's two problem1. I heard Ip address isn't unique and changes frequently2. cookie can be deleted by userI'd .
View 1 Replies
Oct 22, 2010
I get the follwowing exception while running my ASP.NET 1.1 web application. The Web application will call a web service which connects to to the DB server and returns the data to the application. This error occurs when we move the webservices and databases to new servers. I am able to connect to the DB server from web servers through SQL port.
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object
data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
Why does this error occur and how to solve this?
View 9 Replies
Jun 2, 2010
My application is windows authenticated. The application pulls JUST the userName from the current windows account. Then I provide site access to this user depending on his account privileges. If his userName belongs to the admins list he is directed to admin screens. If his username belongs to users list he is directed to users screens. I handle this security in C# and some SQL tables(No membership provider and no Active directory security in the app).
I need to be able to prevent multiple concurrent logins for the same userName.
View 4 Replies
