|
In the MySqlException Class you have a Number Property that returns an int containting the MySql Error Code (The ErrorCode Property Returns the HResult) but that could be all of nearly 4000 codes, depending on the specific error (i.e 1049 - Unknown Database Error, 1045 - Access Denied Error) and to check for these seems overboard really.
I like your idea of adding a property to my custom exceptions so that in the calling function I only need to trap one error instead of 2, although I can't see it helping me when I trap the original error unless I can get the MySql connector to actually throw my custom exception (impossible ?). I don't really know to be honest, but many thanks for your input.
|
|
|
|
|
Hi All,
Last month I posted this question, but I think I didnt get response for that. Anyways, I would like to ask again:
I am one vb.net windows application installed on my client's PC. Now my client has asked some changes in the code and re-send that application, so that he can uninstall the previous version and install the updated version.
From my end, I have done the requested modification and created a Setup & Deployment project in VS2005.
Now I dont want him to uninstall the previous version of that application installed on his PC. I want to update his installed application with the updated one ( which I made on my PC) without un-installing his last version.
Can someone Pls let me know how to create this? Any patch building is required or not? I am new to this, though i can send him the updated exe so that he can uninstall the previous version and install the new version, but i dont want him to do...I want him to directly update his present verion of the application already installed.
Anyhelp would be appreciated.
Regard,
R.S.
|
|
|
|
|
As far as I know, the Setup and Deployment project doesn't create patches. You can it it to upgrade a previous verison of the package, so long as you have the ProductCode that it used, then the current one will uninstall the old version and install the new one.
I don't use the Setup and Deployment project, so I'm surely no authority on it. I use real setup and deployment tools, such as Wise Package Studio, InnoSetup, and InstallShield.
|
|
|
|
|
Hello to All,
Where are temporary internet files stored in Firefox ? (like IE stores them in temporary internet files).
Thanks
If you can think then I Can.
|
|
|
|
|
To go to the disk cache section , type in:
about:cache?device=disk
in the address bar of FF.
Also have a look at this[^] addon. 
|
|
|
|
|
where i can type this .
If you can think then I Can.
|
|
|
|
|
He already told you:
in the address bar of FF.
|
|
|
|
|
How the hell did this question end up in the Visual Basic forum?
I fail to see the link between FF and VB.......am i missing some info here?
|
|
|
|
|
daveauld wrote: am i missing some info here?
Yep, I believe you are; and so am I.
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
I m with ur favor.
If you can think then I Can.
|
|
|
|
|
Hi CP,
I developed an appl. in that i am having controls like textbox, combobox, list box,button ,etc and some other controls from PowerPacks.
I implemented successfully Cut/ Copy / Paste of these controls within the application .
Now i have to implement the things in Clipboard . How can i serialize the class which is maintaining the list of controls.
Public Class Temp
Dim lTempControls As List(Of Object) = Nothing
End Temp
So how can i serialize to clipboard and get all the things when i exit & open the application ?
Regards,
For1206
|
|
|
|
|
The Clipboard is common across the system, you interact with the clipboard through the MyComputer.Clipboard object.
|
|
|
|
|
You beat me to it!
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
|
|
|
|
|
Yeh, but notice we both got voted 1.
Now was that because the suggestions weren't an acceptable answer for the OP, or did someone else think we were taking the pi$$.
Guess we will never know!
Do you want a 5 exchange?
|
|
|
|
|
I will 5 you all the way down, just to be sure!
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
|
|
|
|
|
Use My.Computer.Clipboard
This may help[^]
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
|
|
|
|
|
Hi Dave,
These things doesn't workout for me . Bcoz i implemented my custom way to build the application .
Clipboard Serializable format but it's not working.
Regards,
For1206
|
|
|
|
|
Ah, sorry then, I cannot help further.
But do be careful and think before doing!!!
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
|
|
|
|
|
for1206 wrote: So how can i serialize to clipboard
Don't! Remember the clipboard is a user controlled mechanism. If you serialize to the clipboard and the application then terminates you have lost control of the clipboard, and potentially all your objects. Serialization should be to permanent storage, e.g. disk files.
MVP 2010 - are they mad?
|
|
|
|
|
Like Richard said, you copy to/paste from the Clipboard, in whatever format suits your app (text, image, file list, ...); and you serialize to/from permanent storage in some format (binary, XML, ...) to make your object persistent. Those are two distinct mechanisms with different purposes.
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that. [The QA section does it automatically now, I hope we soon get it on regular forums as well]
|
|
|
|
|
Hi friends,
I want to develop a small Application.
In Brief a scanned Paper which is of four A4 Pages.
It contains image and at the bottom contains many fields.
SO that I have to develop a application.
The Image size is too large. SO, I would like to apply scrolling for ImageBox.
and How to make active of the next item..
Please let me know.
Thanks
|
|
|
|
|
|
yes, a Control-in-Control technique is the easy way out. PictureBox-in-Panel is fine.
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that. [The QA section does it automatically now, I hope we soon get it on regular forums as well]
|
|
|
|
|
I am working on an application in which month and year is selected through combobox.
On selection on both, a checklistbox is filled with data for the selected month and year.
When I select the month and then year in application that is connecting to remote server, the system hangs. But the same when I do on a machine that connects to another remote server works fine.
What could be the possible reason for this?
I call a sub procedure on the selectedindexchange event of the combobox
Code in the sub proc is as below:
Private Sub FillClients()
Dim sqlComIns As SqlCommand
Dim iRec As Integer
Dim sSQL_Temp As String
If CboMonth.Text = "" Or cboYear.Text = "" Then Exit Sub
Call DisposeAllObjects()
sSQL_Temp = "DELETE FROM GlobCustNonZeros_Cust"
sSQL = "INSERT INTO GlobCustNonZeros_Cust(Global_Cust)SELECT DISTINCT GLOBALCUST FROM tbMain WHERE FeesAmt<>0" & _
" AND UpMonth='" & CboMonth.Text & "' and UpYear='" & cboYear.Text & "' AND GlobalCust NOT IN (SELECT Global_Cust from GlobCustZeros_Cust)"
LstClient.Items.Clear()
Try
objDB = New ClsConnection
sqlcon = New SqlConnection(objDB.conStr)
sqlcon.Open()
sqlComIns = New SqlCommand(sSQL_Temp, sqlcon)
sqlComIns.CommandTimeout = CMDTimeOutFirst
sqlComIns.CommandTimeout = CMDTimeOutSec
iRec = sqlComIns.ExecuteNonQuery
sqlComIns = Nothing
sqlComIns = New SqlCommand(sSQL, sqlcon)
sqlComIns.CommandTimeout = CMDTimeOutFirst
sqlComIns.CommandTimeout = CMDTimeOutSec
iRec = sqlComIns.ExecuteNonQuery
sSQL = "SELECT Global_Cust FROM GlobCustNonZeros_Cust ORDER BY Global_Cust"
sqlComm = New SqlCommand(sSQL, sqlcon)
sqlComm.CommandTimeout = CMDTimeOutFirst
sqlComm.CommandTimeout = CMDTimeOutSec
sqlRead = sqlComm.ExecuteReader
Do While sqlRead.Read
LstClient.Items.Add(sqlRead("GLOBAL_CUST"))
Loop
sqlRead.Close()
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
Any help will be highly appreciated as its very urgent.
thanks in advance
Regards
Imran
|
|
|
|
|
GSS_imran wrote: Do While sqlRead.Read
LstClient.Items.Add(sqlRead("GLOBAL_CUST"))
Loop
Put a break point here to see if your code is getting into an infinite loop.
Me, I'm dishonest. And a dishonest man you can always trust to be dishonest.
Honestly. It's the honest ones you want to watch out for...
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
