|
SQL is supported everywhere. SQL Server is another matter. MySQL may be supported on Max and Linux, it seems like a products created by the same sort of hippys as Linux.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
thanks,
wat about mac os?
wheather it support mysql??
Senthil S
Software Engineer
|
|
|
|
|
Senthil S wrote: wat about mac os?
wheather it support mysql??
If you are looking for cross platform, MySQL is your best bet. Binary distributions are currently available for Windows, Linux, Solaris, FreeBSD, Mac OS X, HP-UX, IBM AIX and i5 OS, QNX, Novell and SCO:
http://dev.mysql.com/downloads/mysql/5.0.html[^]
OR you can download the source code and compile it on other OS not specified above:
http://dev.mysql.com/downloads/mysql/5.0.html#source[^]
Pete Soheil
DigiOz Multimedia
http://www.digioz.com
|
|
|
|
|
Why does control +C and control +V doesn't work on textbox controls of VB.Net 2005 forms when we run them. But Right click -Copy, Paste works fine on the controls.
Could anybody tell what is the reason.
Sekhar
|
|
|
|
|
They do, as far as I know. What makes you think otherwise ? Are these textboxes you've written any event handlers for ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hello every one
I am making an application in VB 2005 Express. Hear I am accessing a remote database.
When the networks is disconnected for some time and is connected back, the application still dose not connects to the DB again until I exit and start again.
On looking at the thing in detail I was able to come down to the following things
- Can we some how refresh the connection
- Can we refresh / flush the port on which DB is connected
If any one has any ideas of how is it done then plz let me know. Also is there any other way of place where I should look in the application
Regards
Nishkarsh
|
|
|
|
|
Are you making the mistake of opening a connection when you app starts and keeping it open for the life of your app??
Or are you opening a connection, doing your database query, then closing the connection?? If this is the case, the problem you're describing can't happen.
|
|
|
|
|
Yes i am opening the connection once only at start and using through out...
My application is based on a DB will it not take a real extra time every time opening and closing the connection???
|
|
|
|
|
nishkarsh_k wrote: Yes i am opening the connection once only at start and using through out...
That's a really bad practice. Holding a connection open for the life of your application also holds onto a very expensive SQL Server license, which are usually bought by the seat. This means that, for example, you can have 10 connection licenses on the SQL Server and about 50 machines using them IF they just open a connection for the time it takes to do a query, then close the connection. Using your method, the same server would have to have 50 licenses, at an addition 4 times the cost of 10.
Your database connection is probably, in a normal situation, idle for 99% of it's life. That's a lot of time holding onto a license and dogint nothing with it.
If a customer using your application caught you doing that, you'd probably be fired on the spot.
nishkarsh_k wrote: My application is based on a DB will it not take a real extra time every time opening and closing the connection???
Nope. The first connection is the most expensive (process wise). Subsequent connections using the same connection string are cached by ADO.NET and open and close very quickly.
modified on Sunday, December 23, 2007 10:32:46 AM
|
|
|
|
|
I have a TreeView loaded with directories/subs/files. I want the ability to click on the file node (most junior node) of this TreeView and transfer the node over to an adjacent ListView control. At this point I want to transfer it either by double clicking on it or simply by putting code in a click event of the ADD button which sits between the the View controls. At this point I am using a basic TreeView without a multiselect option.
How do I transfer individual the most junior node item labels from the TreeView to the ListView? And how do I ensure that the whole file path comes along with it?
Thanks
EM
|
|
|
|
|
First, stop thinking in terms of "transferring". You'll do nothing of the sort.
When you populate the TreeView, you set the Tag property of the TreeViewItem to the full path to the file/folder.
In the button handler code, you get the currently selected item from the treeview, look at it's Tag property to get the full path of the item, then create a new ListViewItem with whatever data you want, making sure to again, put the full path in it's Tag property, add it to the ListView. Then you delete the selected item from the TreeView if you so desire.
|
|
|
|
|
hi all,
i use multi threading in my application which perform the work of downloading file.
the following code Create the thread & start them
<br />
Protected Sub DownloadFileInfo(ByVal sourcePath As String, ByVal DestinationPath As String)<br />
If Not File.Exists(DestinationPath) Then<br />
ReDim Preserve TotalThreads(TotalThreadCreated)<br />
'ReDim Preserve WaitAllDownloadEvent(TotalThreadCreated)<br />
Dim DownLoadObject As DownloadClass = New DownloadClass<br />
TotalThreads(TotalThreadCreated) = New Thread(AddressOf DownLoadObject.StartDownload)<br />
TotalThreads(TotalThreadCreated).Name = TotalThreadCreated.ToString<br />
TotalThreads(TotalThreadCreated).IsBackground = True<br />
'TotalThreads(TotalThreadCreated).<br />
'WaitAllDownloadEvent(TotalThreadCreated) = New AutoResetEvent(False)<br />
<br />
DownLoadObject.DownloadFileWithSourcePath1 = sourcePath<br />
DownLoadObject.DownloadFileWithDestinationPath1 = DestinationPath<br />
DownLoadObject.MyObjectNumber1 = TotalThreadCreated<br />
TotalThreads(TotalThreadCreated).Start()<br />
TotalThreadCreated += 1<br />
<br />
End If<br />
End Sub<br />
<br />
code of downloadClass is following
<br />
Imports system<br />
Imports System.Threading<br />
Imports System.IO<br />
<br />
Public Class DownloadClass<br />
Public DownloadFileWithSourcePath1 As String<br />
Public DownloadFileWithDestinationPath1 As String<br />
Public MyObjectNumber1 As Integer<br />
<br />
<br />
Sub StartDownload()<br />
If Not File.Exists(DownloadFileWithDestinationPath1) Then<br />
Try<br />
<br />
My.Computer.Network.DownloadFile(DownloadFileWithSourcePath1, DownloadFileWithDestinationPath1)<br />
<br />
Catch ex As Exception<br />
End Try<br />
End If<br />
<br />
End Sub<br />
<br />
<br />
End Class<br />
<br />
DownloadFileInfo procedure is called near about 175 times so total 175 thread is created and in Destination folder i can see the icon of all download files(during downloading).
but after some time (near about 2 minute), these 175 icon is decreased and only few icon are appearead (near about 40). I think all thread is died after 2 minute so file attached to these thread is also deleted (note that files is not completely download)
any body have idea where i am wrong ?
any help will be greatly appreciated.
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
My Company
|
|
|
|
|
Probably because your downloading 175 files all at once. File download operations are probably timing out because of bunch of threads are all waiting on one to use the network pipe. What you're doing is not efficient at all because the network pipe is not really multithread capable. Only one thread can access the network pipe at a time.
Limit your downloads to only a few threads at a time and it should work. Multithreading does NOT make your application faster, nor does it reduce the amount of time it takes to download a group of files. All it does it make your application responsive during a long running operation.
|
|
|
|
|
hello sir,
thanks for your reply.
What you're doing is not efficient at all because the network pipe is not really multithread capable. Only one thread can access the network pipe at a time
Network pipe is not multi threaded capable. Here i want to know one more thing that what is the downloading criteria when i download files on multiple thread. it downloads all files on all thread partially or it first download one file of thread completely and after that it pick other thread file.
size of all files(175) is near about 6 MB. whether it is possible that i successfully download these files using multiple threads. if yes then Please guide me or provide some link or code snippet
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
My Company
|
|
|
|
|
I thought Dave explained it well enough .. but here goes my shot:
The major choke point in this scenario is the network connection.
High level, ignoring all the details and reality overview:
At heart your network connection is a serial line, pushing one byte at a time to and from your machine.
Those bytes are amalgamated into multiple byte sequences called packets. When a packet arrives at your machine it will be addressed to a logical port number (1-65535). Each of your threads having opened a connection to a remote peer will have a logical port number for that socket connection.
Thus you have 175 open connections, each uniquely addressed, each eagerly awaiting packets from the network connection.
However the first thing I said was that the network connection was serial in nature. Only ONE packet at a time can get through. So for any given moment only ONE thread can receive data. Given that the latency for the network is vastly greater (i.e. slower) then for the core(s) your threads are running on, the OS is happily context switching your threads in and out to do absolutly nothing for most of their lives.
Eventually the network connection (not the threads) time out due to inactivity or failure to tranfer the data - this behaviour is desired and shouldn't be altered unless absolutly necessary.
The best analogy I can think of is a cookie jar with a small opening. One person can reach in and take cookie after cookie. A dozen people reaching in will get their hands stuck and get few if any cookies.
To make a long story short, the optimal number of threads for this operation is : 1
I'm largely language agnostic
After a while they all bug me
|
|
|
|
|
Damn, you beat me to it! I was on the road between sites.
Great explanation! That's pretty much what I was going to tell him.
|
|
|
|
|
There seems to be a lot of confusion over threading out there. I think the most egrarious use of threads I ever reached was 5, which I scaled back to 3 in a back-end service (controller, listener, worker). 175 is pretty impressive
I'm largely language agnostic
After a while they all bug me
|
|
|
|
|
Hi
I created this code for wildcard search and it doesn't work. I have VB5 express.
code:
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim SearchName, mySQL As String
SearchName = "'%" & PriimekToolStripTextBox.Text & "%'"
mySQL = "SELECT SLUŽBA.Priimek"
mySQL = mySQL + " FROM SLUŽBA"
mySQL = mySQL + " WHERE (((SLUŽBA.PRIIMEK) Like " & SearchName & "));"
rsMyRS = dbMyDB.OpenRecordset(mySQL)
End Sub
VB alerts:
- rsMyRS not declared
- dbMyDB not declared
how do I do that. I have DataSet and TableAdapter set to this form2.
Bye
modified on Friday, December 21, 2007 6:58:20 AM
|
|
|
|
|
BOREC wrote: I have VB5 express.
No, you have VB.NET 2005 Express. There was an old version of VB5 that didn't have an Express edition. Mentioning that version will confuse people, and greatly affect the answer you get.
BOREC wrote: I created this code for wildcard search and it doesn't work.
What database are you using? Wildcards are NOT the same between different databases.
BOREC wrote: VB alerts:
- rsMyRS not declared
- dbMyDB not declared
You haven't declared these variables and told the compiler what types they are supposed to be. This is a very basic mistake. I highly suggest picking up a beginners book on VB.NET and working through it.
|
|
|
|
|
I have MS VB 2005 express edition like it says with microsoft.NET Framework 2.0. I know what declaring variables means I wanted to ask you what variables should I declare there.
Obviusly you don't know much abaut programing yourself cause you call quite a lot of people on this forum newbies and insult them. I think you don't get out too much and spend too much time with your computer. Well anyway I don't want to go down on your level, but you had it comming.
Certainly I see the point why programers create such tools with no good support, so people buy your books and pay for other help too. And the great thing would be, that when someone learns VB 2005 the next year will be released VB6 and you can start practicaly all over again ( buy new books, learning classes, so on,... ) Well enough of that thanks for your help. Nothing good is for free ain't it.
|
|
|
|
|
BOREC wrote: I have MS VB 2005 express edition like it says with microsoft.NET Framework 2.0.
The only way I knew you were using VB.NET instead of the old VB5 is the code snippet you posted. Someone else may not see that misdirection.
BOREC wrote: I know what declaring variables means I wanted to ask you what variables should I declare there.
It's impossible to tell what types to declare those variables as from the tiny code snippet that you posted. If you're writing this code, you should have known what these are supposed to be. It's quite obvious that your typing in code that you found laying around somewhere, but you have no idea how it works.
OpenRecordSet is not a method on any .NET BCL class. So this method has to be defined in either some other class in your project or in a 3rd party library somewhere.
BOREC wrote: Obviusly you don't know much abaut programing yourself cause you call quite a lot of people on this forum newbies and insult them.
Excuse me, but how did I insult you?? From the questions in your original post, it's quite obvious you're a beginner at this.
And, no, I haven't written any books, nor did I recommend any. I have no vested interest in any books past, present, or future. All I did was suggest picking one up so you can learn the basics. The questions you asked are a direct result of not knowing what a Type is, how define your own custom classes, OOP concepts, and how to use an external code library.
These are basic concepts that apply equally to VB5, VB6, VB.NET 2002, 2003, 2005, 2008, and all future versions of VB.NET...
|
|
|
|
|
Steady as a rock, you've got my 5.
|
|
|
|
|
Thanks!
I've got a munchkin on the way, so I have to practice keeping a level head around him.
|
|
|
|
|
You're in luck then, this site provides ample opportunity to practice...
|
|
|
|
|