|
Use OleDbCommand.ExecuteScalar() if you return a single value from the query.
|
|
|
|
|
Hi!
I have stumble on the keyword WithEvents, here is a code example:
Public Shared WithEvents theOpcServer As OPCAutomation.OPCServer = Nothing
Public Shared WtihEvents theOpcGroup As OPCAutomation.OPCGroup
What's the difference with those two declarations compared to:
Public Shared theOpcServer As OPCAutomation.OPCServer = Nothing
Public Shared theOpcGroup As OPCAutomation.OPCGroup
OPCAutomation is a reference from a DLL-file which I'm using in my application and OPCServer and OPCGroup are two classes from that namespace.
For my application is doesn't matter if I have 'WithEvents' or not. Can someone explain the 'WithEvents' keyword?
|
|
|
|
|
Selecting the word and than pressing F1 gives you the help.
Withevents let you select the events possible for that control at designtime
|
|
|
|
|
WithEvents has one powerful extra feature.
To use your example. Suppose you start with a variable such as
Public Shared theOpcServer As OPCAutomation.OPCServer = Nothing
We also assume you have and event handler somewhere eg.
Public Shared Sub OpcServerEventHandler(sender as Object, e as EventArgs)
With this code every time you assign an object to theOpcServer you need to attach and remove the Event Handlers. eg.
If theOpcServer IsNot Nothing Then
RemoveHandler theOpcServer.OpcServerEvent, AddressOf OpcServerEventHandler
End If
theOpcServer = New OPCAutomation.OPCServer()
AddHandler theOpcServer.OpcServerEvent, AddressOf OpcServerEventHandler
Alternatively use the WithEvents keyword and a Handles clause on the event handler sub.
Like this .Net does all the event handler maintenance for you without having to write armfuls of code.
If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
www.JacksonSoft.co.uk
|
|
|
|
|
|
Hi All,
I have a Tabcontrol form with 4 tabs. I want to enable 1 tab ( which will be disabled when the Form loads) and will be enable using some authentication system, i.e. whenever user try to click on the disabled tab, it will prompt for entering some login/password which when matches, will enable the tab.
How to implement this?
|
|
|
|
|
AFAIK, you cannot enable/disable the tabe page itself. Although you can do that for the controls that recide in it.
You can handle the MouseClick event of the tab control and check the SelectedTab property. If that is the concerned tab page, show your login form. If the login succeeds, you can enable the controls in the tab page.
You can use delegates to handle the Ok (or whatever submit button you have in login form) button click in the form containing the tab control.
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
Actually you can disable a tabpage. The Enabled property is hidden and unsupported, however if you type it in the code it does work.
If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
www.JacksonSoft.co.uk
|
|
|
|
|
That's news for me. Thanks. I will try that tomorrow morning. 
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
Disabled controls (including Tab Pages) will not generate events 
|
|
|
|
|
Good point.
A better solution would then to custom paint the tabs and make them look disabled based on some other property of the tabpage, maybe that tag property. If the Tag contains a boolean True then paint the tab to look disabled, then the events will still fire.
Personally I would rather assess the user security before entering the form and then disable or remove the appropriate tabs up front.
If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
www.JacksonSoft.co.uk
|
|
|
|
|
When a control is disabled, it is a visual clue to the user that the functionality is not available. Don't expect your users to click on a disabled tab to get access to it. It doesn't make sense. Instead, provide a button somewhere on the main tab that provides access to the disabled tab.
Disabled tab will not generate events and you would end up wasting your time
|
|
|
|
|
I am looking for a way to createWindowEx and to get the handle of the control just created:
I have tried both these ways:
callfunc CreateWindowExA,
hwnd = CreateWindowExA(
but all i get back is a "0", telling me that all is well.
Pls, how can i do this.
Code in C+ or VB or HotBasic would be great!
Thanks...vmars
|
|
|
|
|
Hi,
vmars316 wrote: but all i get back is a "0", telling me that all is well.
On the contrary 0 or null is telling you that all is not well. What arguments did you supply to the function. A short code fragment showing the context of the call would be helpful.
Alan.
|
|
|
|
|
Straight from the documentation:
"If the function fails, the return value is NULL. To get extended error information, call GetLastError."
Luc Pattyn [Forum Guidelines] [My Articles]
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
modified on Sunday, November 22, 2009 3:16 PM
|
|
|
|
|
Hello!
I have to produce a software license number from a PDA's device ID. Whenever a user submits this ID to web site, the new licence number must be produced according to submitted id and then whenever user uses the new license number in the software, the code should resolve the new id according to PDA's device id and confirms it.
For example:
The following is a PDA's device ID (7AAF5100226808010d19-c37ad75c0345) and the new license number should be likely this
(5FC6-88J9-1264-76K8)
How can I produce such algorithm. Is there a code sample? I need a road map to realize the concept.
Thank You.
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
Use simple hashes based using secret company and product hashes as salts and then combine them all to generate a license hash.
|
|
|
|
|
How about Reversing the produced license key and finding the product of the secret company. Hascode only produces numeric numbers.
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
Yes but you could then tweak the generated hash to ensure that the generate key is within the ascii printable charachter set.....
|
|
|
|
|
Hello,
my aim is to insert a table with 100 rows and 2 cols at the end of a document.
Next I have to fill every row with a random font-name in the first column and a formatted text with that random font in the second column.
A font-type must not be repeated within the next 10 rows.
So here is a code, that does exactly that thing, but I want to find a more performant solution - maybe someone could help me how to optimize it. I know that there are much better ways how to solve this problem, thats why I ask.
Thanks in advance for taking the time,
cherry
'Set Range to end of document
Dim where As Range
Set where = ActiveDocument.Range(ActiveDocument.Range.End - 1, ActiveDocument.Range.End - 1)
'Insert table with 100 rows and 2 cols
Set tablewith_different_styles = ActiveDocument.Tables.Add(where, 100, 2, _
DefaultTableBehavior:=wdWord9TableBehavior, AutoFitBehavior:=wdAutoFitFixed)
'Loop 100 times for each Font
i = 0
g = 1
Do While i < 5
Do While g < 21
'Got to table row i, col 1
tablewith_different_styles.Cell((i * 20) + g, 1).Select
'Set random font
Selection.Font.Name = FontNames(g + 20)
'Save random font
Name_Font = Selection.Font.Name
'reset font for next output
Selection.Font.Name = "Courier New"
Selection.Font.Size = 9
'Insert font name and iterate to next line
Selection.TypeText Text:=Name_Font
Selection.MoveRight Unit:=wdCell
'set font and size
Selection.Font.Name = FontNames(g)
Selection.Font.Size = 9
Selection.TypeText Text:="My Formatted Text in every Row."
g = g + 1
Loop
g = 1
i = i + 1
Loop
|
|
|
|
|
This looks pretty simple and efficient to me. The only other approach that might make this process faster is by going through XML. Maybe code creating the word file in xml format (but saving it as word) might execute faster.
My advice is free, and you may get what you paid for.
|
|
|
|
|
Thanks for your answer. But it is not what I'm looking for.
The problem is: I know this works usually much faster - the table gets inserted and filled in less than 2 seconds - there has to be another way and sadly I'm totally new to VB.
I would be happy if someone had another tweak for me...
Thx cherry
|
|
|
|
|
You said, you know that it usually works faster. It might help, if you could explain how you used to do it. What changed?
My advice is free, and you may get what you paid for.
|
|
|
|
|
Oh, if it would have been me who worked it faster, then I maybe wouldnt ask you 
Its kind of a challenge, the fastest makro wins. It not only this table, but this table
is the part that costs me the most computation time.
I only know, that it would eventually be faster, if you set up the table step by step. But I don't know how to do it best and I don't think of this as a great idea.
So far, thanks. cherry
|
|
|
|
|
I am not sure if something is getting lost in translation. Do I understand you correctly, the code you posted is written in MS Word's own code editor (i.e. it is VBA), or has it been written in VB.NET using Office.Interop?
My advice is free, and you may get what you paid for.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
