|
TDDragon wrote: this all works and the programme works fine but when I check the connections to the db (in SQL server) it says that there are still 2 connections (per user).
Yes, it is the connection pooling. It is faster to get an existing connection out of the pool than create a new one, so once a connection is created for the first time it will be returned to the pool once it is finished with.
TDDragon wrote: Now I don't like this since this programme is going to be used by 10+ users that would mean there are already 20+ connections (I know that that is now problem for SQL but it just isn't how it is supposed to work) and there are also many other db's hosted onto the server so the less connections the better.
It sounds like what you actually need is some sort of service interface to sit between your application and SQL Server (in order that you are only using one pool of connections to the database). If performance isn't so critical you can look at turning the pooling off (Not something I can remember how to do - it's been a few years since I last looked at that)
|
|
|
|
|
How read a barcode from scaner?
Plz Help me.
|
|
|
|
|
Hi
You Need an object that connect to barcode device
and usually have an event for alert to you when action.
that object Depend on device
you would provide that from manofactor of device
contact by barcode company
|
|
|
|
|
You need to consult the documentation of the scanner to figure this out. See if there is an SDK available for your scanner and read the documention on it if there is one.
|
|
|
|
|
Barcode scanners normally work like a normal keyboard, you just need to trap the event for 'Enter' being pressed in your textbox (or whichever control you're using), which is sent after the end character of the barcode is scanned.
I'm not saying it works for all scanners, though it has in the one's I have tried
|
|
|
|
|
Yeah, I know that. I also know that he hasn't specified anything about which scaner he's using. It could be a keyboard wedge, serial, USB, or ethernet based unit, only about half of which act like a keyboard.
|
|
|
|
|
How can I remove the [X]-close Button on the message box?
|
|
|
|
|
I got the answer..
I'll just show a pseudo code here..
It's something like (I'm not sure exactly the code in VB.Net
msgbox("Hello", vbYesNo + vbModalApplication)
It disables the [x] button of the messagebox.
|
|
|
|
|
Hi
i want convert a network Path to Loacal Path,
Eg. \\Client1\DBBackup
D:\DBBackup
result should be like this
D: is the Drive of Net work Folder 'DBBackup'
can you give any suggestions Or solutions
By
George Garvasis
|
|
|
|
|
Hi
You Can Use This Function To Convert NetworkPath To LocalPath
Private Function ConvertToLocalPath(ByVal NetworkPath As String)
Dim LocalPath As String = "D:"
Return LocalPath + NetworkPath.Substring(NetworkPath.IndexOf("\", 2), _ NetworkPath.Length - NetworkPath.IndexOf("\", 2))
End Function
|
|
|
|
|
This is easy using the Path class in the System.Io namespace:
Imports System.Io
.
.
.
Dim root As String = Path.GetPathRoot("D:\some\file.path")
This also works just as easily with a UNC path.
Or are you asking how to determine which drive letter is being mapped to a UNC path??
|
|
|
|
|
hello
i want to just enter capital letters in a cell of c1flexgrid,
but i cannot handle the event properly so that i could validate this check before the cell lost focus.any code ? help?
i am using dotnet 1.1
thanks in advance
hello
|
|
|
|
|
Hi
Past this code to KeyPress Event Of Your FlexGrid
e.KeyChar = Char.ToUpper(e.KeyChar)
|
|
|
|
|
but it just changes the vbery first typed character
rest of the characters remain nchanged
thanks
hello
|
|
|
|
|
hi guys
i want to print windows based report on dot matrix printer. is it possible?
if yes what will be the h/w , s/w requirement for it ? and coding structure for it in vb.net. since i have developed report in vb.net2005 & crystal report.
Thanks
bye
|
|
|
|
|
As long as the printer has a windows printer driver and you communicate with it using that driver only (no escape code injection etc) then the hardware layer should be of no consequence - it should just work...
|
|
|
|
|
thanks for reply. then what should i do for printing on dot matrix ? pliz. suggest me code.
Thanks
bye
|
|
|
|
|
He just told you! It's no different that if you were printing to a laser printer.
Crystal Reports will handle generating the image of the page and pass that to the printer driver which will convert that into the native language of the printer. There's nothing your code has to do any different.
|
|
|
|
|
I have a form and if you load another form from that, the first form gets hidden, but not closed, so, how can I get the whole application to close if the exit button on the top right corner of the program is cliced rather than the exit button I placed?
In the end we're all just the same
|
|
|
|
|
hi
to close the application use - application.close()
& to close the current form simply use - me.close()
Thanks
bye
|
|
|
|
|
But I used
FrmFinance.hide () as I wanteded it that way because I had information I wanted to display on it temp while the application was open. If I put frmFinance.close () you would lose the information
In the end we're all just the same
|
|
|
|
|
depends on what you want
say you have 2 forms frm1 and frm2
frm2 is opened by clicking a button on frm1
then you can hide frm1 like you are doing without problems
now from here it depends on what you want
if you want both forms to close when the user presses the close button from frm2 you use
application.close
if you only want frm2 to close you use me.close (and bring frm1 back out of hiding)
use the frm2.close event to do this
hope it helps
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistakes.
|
|
|
|
|
I have a file CarSales.txt and its in the same directory as the program itself, but I keep getting "file not found" when I run the program. How would I get the program to find this file? code:
Dim sr As New StreamReader("CarSales.txt")
In the end we're all just the same
|
|
|
|
|
use application.startuppath
so code would look something like this:
dim sr as new streamreader(application.startuppath & "\carsales.txt")
hope it helps
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistakes.
|
|
|
|
|
You should always use the fully qualified path to a file and not just assume the current directory is the one you think it is.
If your file is in the same folder as your .EXE, you can get the full path using something like:
Public Shared Function GetFullPathToFile(ByVal filename As String) As String
Return Path.Combine(Application.StartupPath, filename)
End Function
If it's in a subfolder of your application's folder, there are several different ways of building the path. A simple implementation would be something like:
Public Shared Function GetFullPathToFileInDataFolder(ByVal filename As String) As String
' Build the full path to the Data folder in our the folder our .EXE is in.
' You could also get this path from a config file, or some other data store.
Dim dataFolderPath As String = Path.Combine(Application.StartupPath, "Data")
' Then build the path to the requested file
Return Path.Combine(dataFolderPath, filename)
End Function
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
