Sql Server - Reducing SQL Connections To Just 1 - ASP.net?
Feb 7, 2012
I am currently working on an asp.net web page with a GridView displaying a table from a database.This GridView has 4 DropDownLists that will be used to filter the data shown on the GridView. When the page loads 4 Sub routines are run, each one connecting to the database with a select statement to fill the DropDownList with relevant filter headings.
Initially, I had one connection with a loop that populated all of the drop downs but these contained duplicates. I then split the filling of each DDL so that the select statements could contain DISTINCT. I would like (and am sure there is a way here) to be able to populate all of the DDLs with data from one connection.
Code for one connection:
Protected Sub FillDepDDL()
Dim conn As New SqlConnection()
conn.ConnectionString =
[code]....
The other 3 column names: FirstName > DDLFN, LastName > DDLLN, Wage > DDLWag.This is only a test DB and the princibles learned here will be applied to a larger live project.
View 1 Replies
ADVERTISEMENT
Jul 19, 2011
Using VB.Net and SQL Server 2008 R2: I have recently had a database that using sp_who2 reflects a connection ".Net SqlClient Data Provider" is still active even though the .Net application has closed and disposed of all connections.
[Code]...
View 1 Replies
Jul 25, 2010
I have a server which has around 300+ users on it. Though the problem is that its coded in VB6, and if somebody has a bad ping, everybody has a bad ping. I need a tunneling server which will tunnel the incoming and outgoing connections and make there ping appear to be 0 in the server. Client to Server, Server to Client.
View 1 Replies
Mar 11, 2011
I searched on google for these terms : "How to see all open connections in vb.net" and it should be for a server im running and it would be like to see witch users are connected (ip) and then if i type in the console -disconnect ip then the user will be disconnected from the server but is this technical posibble ?
View 4 Replies
Aug 24, 2011
I'm pretty new to VB.NET and connecting to SQL Server.What is considered best practice when building an app that needs to connect frequently to a SQL Server DB to fetch, write, delete and update records?Should a connection be opened at app startup (a connection at start is opened to validate the user) and left open for subsequent transactions or should a connection be opened, closed and disposed of each time a read/write to the DB is required?
View 3 Replies
Aug 27, 2009
I have a java class that is used to for ssl connections to a web server. I have got some of it converted however there are serveral java libraries that i have been unable to figure out how to call or reference in vb.net. First off i'm not even sure if it's possible to reference them
[Code]...
View 1 Replies
Aug 17, 2010
I have a .net window application created and I wanted to see if it's at all possible to place various file dependencies off the web server. e.g. is it possible to have the connection to the database be off a web server?
I also would like to see if it's possible to place one of the .dlls off the web and have code that points to it to load.
View 2 Replies
May 29, 2009
In our VB 2008 we are making a lot of connections to sql server 2005 databases. Is there a possibillity to check with a program or a tool of 2005, all connections are closed?
View 3 Replies
Jul 27, 2009
Every time I execute my application and the app try to access the database I received an error message telling me that the user cannot login into the database. This is because the VS Server Explorer have the connection opened. What I need is that every time I debug (F5) my app the Server Explorer close the connection with the database so I do not have to stop the execution and manually close the connection. Is this is possible? Is there any way I can setup the debug or the Server Explorer to do this?
[Code]...
View 1 Replies
May 17, 2010
I am developing project on cyber cafe using vb .net 2005 and winsock i don't know how to accept connections from multiple clients to a server having winsock control
View 2 Replies
Sep 2, 2009
a small question: what is the difference between sync and async connections in a tcp/ip client/server application?
View 1 Replies
Dec 18, 2009
I have been developing an async socket connection server and client program. I have been testing it, and noticed that if I connect to the server from my client and then disconnect. Upon reconnecting I am on a different port(local IP still). This is fine, however when I go to send a message, and the server trys to update all the clients, it eventually hits clients that do not exist anymore. I get the SocketException 10054, and upon connecting/disconnecting enough, it no longer works at all. My question is how do I clear out these no longer useful sockets from the server? I am doing currentsocket.Shutdown(SocketShutDown.Both); and then a currentsocket.Close(); after that. When a user disconnects.
[Code]...
View 1 Replies
Jun 11, 2009
I have an application which connects to a database, retrieves a username from a user's table and matches it against the username retrieved with System.Security.Principal.WindowsIdentity.GetCurrent.Name.On my localhost, everything works fine. The database exists on the development server but the application lies on my localhost. All of my authorization and authentication techniques are running smoothly.However, when I publish my application to the development server, I'm faced with the following error.Cannot open database requested in login 'databaseName'. Login fails.Login failed for user 'DevelopmentServerNameASPNET'.
[Code]...
View 4 Replies
Jun 16, 2010
Can anyone provide a script to close all open sessions in a Terminal Server?
Aldo.Everything is possible, impossible just takes longer
View 2 Replies
Jan 27, 2011
I understand the basics of using VB.NET, what I don't understand is what I need to tell the computer to do. I'm supposed to create a subprogram to calculate the greatest common factor and another subprogram to reduce the fraction from the answers retrieved from the first subprogram. My teacher said something about using Mod to calculate it, and also attempted and failed to explain ByVal and ByRef parameters. I don't even know where to begin other than the parameters I have for each, and even those have a high chance of being completely wrong.[code]
View 1 Replies
Aug 30, 2009
I've been having complaints about my applications that they use to much memory.Is there a way to make them use less?
View 11 Replies
May 27, 2011
How would you go about reducing the code for this but still allowing it to work the way it is now
Dim updatelesson As String = cmbChange.SelectedIndex
Dim chosenlesson As String = cmbSession.SelectedIndex
Dim changed As String = lstNames.SelectedItem
[CODE]....
View 3 Replies
Apr 27, 2009
I'm generating a list of names from my database, but I need to validate them so they are no longer than 15 characters.
Dim Name As String
Dim txtFirst = "../../Names/first.txt"
Dim txtLast = "../../Names/last.txt"
[Code]....
I need Name to be no longer than 15 characters, and it doesnt matter if the name stays in tact, it just needs to cut off characters from the end of the string until its 15 or less.
View 2 Replies
Dec 23, 2011
In the process of creating an Icon object, I need to reduce the numbers of colors in an image from thousands down to 256 or less. I do this by "chromatizing" the RGB values - counting the colors - then re-iterating the process with heavier "chromatization" until the number of colors is reduced to my requirement.
I searched these forums and google on this subject to find out more - but I found that I alone call this process "chromatization" it seems. So I was hoping someone could help me out with the correct terminology.
Specifically, I want to use the correct terminology on my UI buttons (at present I have a button labeled [Chromatize] . .) and I am curious as to whether it would be good practice to "chromatize" the Green most heavily, the Red more moderately, and the Blue least . . . or just "chromatize" them all equally which is what I have been doing
View 2 Replies
Oct 22, 2010
i am currently working on an application that reads the MAC addresses of all phones within the range of our bluetooth reader on the workstation. However, we would like to reduce the range of the reader to < 1 meter. I have dont alot of research and the only solution that i have found is a hardware one; i.e. changing the device to a class 3 or getting a custom made device that will have it's range adjusted to our preferences. However, i also know that we can adjust the power that runs through the bluetooth device in order to reduce the range. Is there any way that we can reduce the power of the device ? We don't have many funds atm and we're looking at a software solution and not a hardware one.
View 4 Replies
Sep 14, 2010
I have a combo which contains a lot of different colours. If I press b it goes to the b's in the list and if I press it again it goes to the next b. Is it possible to jump to the colour as I type it so if I type blu it would go to blue. Currently it jumps to the first b when I type b but ignores the lu for blue.
View 4 Replies
Nov 6, 2010
Dim a as string = "a"
Dim b as string = "b"
Dim c as string = "c"
[code]....
View 11 Replies
Mar 2, 2009
Reading through "The Pragmatic Programmer", I've come across the DRY (Don't Repeat Yourself) and Orthagonal (keep code modular) principles.I have a suite of modules, some of which have common procedures. Because each module is a separate project in Visual Studio, up until now I have simply copied code from one project to another when 1 module (project) needs to do the same function as another module (project). This is when functionality overlaps, not when 2 modules (projects) do everything the same.
I always suspected this was bad practice (and have seen the fruits of my suspicions when the subs get out of sync), and the book confirmed me in this belief. So, what I want to do is make a central code repository for the 4 or 5 common subs, but I don't know how to do it.Should I make a .dll file for each sub I want to use in multiple places? If so, how do I do that? Is there another way to do what I want to do?
1. I have a subroutine that takes a filepath (and if disconnected also a SqlConnection) and loads the referenced file into a database as a BLOB.
2. I have 3 separate projects in 1 VS solution that all run basically the same version of this code.
3. I want all 3 to run EXACTLY the same code.
4. I want 1 version of this code so that any changes made don't need to be made in 3 places.
5. I have a few other instances like this for other subroutines.
View 8 Replies
May 4, 2009
How do I reduce flicker in a vb2005 panel?Inside the parent panel I have 2 other panels that I'm am using.
The outer most panel contains a background sprite and the two innermost panels are overlays that change to fit the places in the background sprite.When I change the overlay sprites I would like to reduce the flicker and make it a smooth transition from one sprite to the next.
Here is the code that changes the images in the overlay panels the overlay panel is not changed if the new value is the same as the old value
[Code]...
View 2 Replies
Jan 21, 2012
I've looked up ways to reduce the ViewState:
Viewstate Optimisations
Strategies for reducing ViewState size in asp.net
However, due to the situation I'm in, I need the quickest and most effective ways to reduce the ViewState size. The legacy system I'm working on is bloated and routinely has a ViewState that's 800Kb+ on multiple postbacks.
For example, I'm pretty sure populating drop down lists with 100+ items on multiple post backs is one of the culprits, correct?
Disabling the ViewStae entirely doesn't appear feasible. It breaks all of the controls, of which there are many, rendering the pages unusable. If this is the best approach, how should I go about handling all the broken controls?
View 4 Replies
Feb 17, 2011
I use the following code to fill the Table1 dictionary with the information found within the LINQ query.
Dim DB As New DatabaseDataContext
Dim Table1 As New Dictionary(Of String, Integer)
Dim Table2 As New Dictionary(Of String, Integer)
[code].....
View 3 Replies
Apr 4, 2012
I have managed to crunch down a several line code to this
For Each gal In galleries
With New HtmlGenericControl("div")
.ID = gal.Header
[code]....
I cannot find any where how to reference back to the object i am currently working with to add the control back to galleryContent' - Using plain me crashes the whole web server...Using does not offer the shorter hand of just using . - But it Using the only way to do it?
View 3 Replies
Sep 6, 2009
<Visual Basic 2005 + SQL 2005>I am developing an Human Resource system that has to have a pictue image for each employee. I can't ask HR person that takes a picture and reduce it to upload to the HR system.
View 2 Replies
Aug 27, 2007
Reducing Code Clutter When Using A ListItem Object
When using ListItem objects, the normal procedure is as follows:
[Code]......
View 2 Replies
Jun 28, 2011
I noticed that when using a single letter as the title on a tab of a Tab Control , the tab is bigger that it should . Look on this example :
The above Tab Control behaves normally because the text on each tab is sufficient to keep it big enough . The lower Tab Control , however , has its tabs too big . Is it possible to reduce its width ? I saw there is an ItemSize property of the Tab Controls , but unfortunately I can only modify the height of the tabs . No matter what value I set for its width , the width remains always the same (and larger than it should) ...
View 4 Replies
