|
Still I'm not clear what you are saying.
I store any kinds of events like :
- A new record is added
- A record is deleted
- A record is modified
- A report is created
- A database backup/restore is made
- A Import/Export is made
....
So for what kind of messages are you talking about ?
Thank you !
|
|
|
|
|
Any of the above. If you need all of those messages, then yes, you'll to reserve space for them.
Do you really "need" them all, all the time? Or could you live with the fact that "modification" messages are only sent if it was configured to send them?
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
I need them because the company's administrator want at any time to see what the users have done at a specific day or time.
|
|
|
|
|
Then it will become a large table; it works the same as with old fashioned books - if you are going to write a lot of them, they will require more space.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
So , your final suggestion is to keep this table inside the main database , or to have another database that will keep only the Event table ?
|
|
|
|
|
That has already been answered.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Sorry , then maybe it's a misunderstand for me.
On your first post about my question , you wrote :
Quote: I'd put it in a separate database on the server, with its own backup policy. I'd also recommend to not broadcast "every" message, but to have the severity as a setting.
Now I don't understand , why we have done all this conversation with each other ? If I should use another database , why I should not keep all the events , as you have suggested ?
Thank you !
|
|
|
|
|
satc wrote: why we have done all this conversation with each other
Good question 
Let's not continue.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hello,
I'm working on a Excel Add-in project in VSTO professional.
What I try to accomplish seems simple, but I cannot figure it out.
I have an excel XLL addin in resources.
On thisaddin.startup I save the xll file in folder in my documents.
What I want to do in the run time is to go and register/add this XLL addin to excel application.
Basically want to replicate following manual steps:
file->options>addins->excel addins->Browse to my folder--> add
Thanks a Lot!
|
|
|
|
|
I make setup of my project, I have crystal report in my project. When i install my setup to the users machine then this setup does not support to crystal report please tell me what is problem and that problem solution ?
|
|
|
|
|
saedawke wrote: I make setup of my project
How? Using Visual Studio, InstallShield, Wise?
saedawke wrote: this setup does not support to crystal report please tell me what is problem and that problem solution
CR is not installed by default, nor automatigally included. You'll need to add it to your setup as a prerequisite. Depending on what software you are using to build a setup that could be an MSI or a merge module.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hi,
I've spent the last few days looking at approaches to creating a 3D display of data points (as a small sphere) and lines (linking the spheres & as a co-ordinate axis).
I did think that DirectX was the solution, but it appears to be not supported for VB.NET under the V4 .NET Framework (?).
So I have installed XNA v4.0 as this seems to be the 'new' way of performing 3D graphics.
My goal is to have a form with a picturebox or appropriate control that I can write "data points" on to in a 3D space. I also want the user to be able to zoom and pan to view the data.
I have had no luck finding straight forward examples in VB (I'm not a c# guy). I have found examples that write circles and lines to a 2D space using XNA but nothing more complex than that.
I would really appreciate any suggestions on where to find a good VB.NET resource for XNA. A post of some sample code would be even better !
Thanks in advance.
Regards
RS
|
|
|
|
|
Getting XNA to show in a WinForm is not a simple task; 3D graphics are not part of the Framework.
You could start here[^]. There's two more options, both "not easy". You could try and find a DirectX3D tutorial, or go for OpenGL[^] - which would have my preference, as it is available on multiple platforms.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hello !
I have a List of KeyPairValues(of Integer,Boolean).
Is there any short way to detect if a specific Key exist in at least one of items of the list ?
( like a Contains method )
Thank you !
|
|
|
|
|
Have to you read the documentation on the collection you're using, or even looked at the Intellisense after you hit the "." after the Key property? There's always a Contains method on it.
|
|
|
|
|
yes , but I'm searching only for Key . If I do contains for the list of keyvaluepair , I need a keyvaluepair to search for. I know only the key . how to construct the Keyvaluepair with a key and unknown value in order to use the contains ?
|
|
|
|
|
satc wrote: yes , but I'm searching only for Key
And? That's exactly what Contains does!
satc wrote: If I do contains for the list of keyvaluepair
Wait. You have a List<KeyValuePair<something, something>>? Why are you not using a Dictionary<key, value>?
|
|
|
|
|
Quote: And? That's exactly what Contains does!
Ok , please can you show me an example :
Dim lst as List(of KeyValuePair(of Integer,boolean).
Please show me a example with contains to find if an item with .key=5 exist in this list.
|
|
|
|
|
You weren't very specific about what you had. If you go back to what I posted, you'll find I said "Keys property", which is itself a collection.
You don't have that. You have a List<>, which doesn't implement a Keys collection on it's own.
Instead of using a List<keyvaluepair<k, v="">>, you should being a Dictionary<k,v> which implements exactly what you want without you having to implement it yourself.
Dim myCollection As New Dictionary(Of Integer, Boolean)
...
Dim result As Boolean = myCollection.Keys.Contains(5)
|
|
|
|
|
If I would like to use dictionary , I wouldn't make the question about List.
So your response is off topic.
|
|
|
|
|
No, it's not. Why the hell are you using List<KeyValuePair<>>?
|
|
|
|
|
Because sometimes I need to iterate through the list using the position of each element like this
for I=0 to list1.count-1
...
Next
Can this be used in a dictionary ? ( Exactly like this ??)
|
|
|
|
|
Man you make this difficult. "Just tell me how to do this" without ever explaining why you think you need to do it.
No, a Dictionary<> can't be indexed like that. As you already know, a List<> can. The solution is to make your own List<> class, inheriting from List<KeyValuePair<TKey, TValue>>. You're going to have to implement your own Keys property to expose a Contains for it. Also, you need to expose your own Add methods to add values to the collection. It's really very simple.
Public Class KeyValueList(Of TKey, TValue)
Inherits List(Of KeyValuePair(Of TKey, TValue))
Private _keys As New List(Of TKey)()
Private _values As New List(Of TValue)()
Public ReadOnly Property Keys() As List(Of TKey)
Get
Return _keys
End Get
End Property
Public Overridable Sub Add(key As TKey, value As TValue)
_keys.Add(key)
_values.Add(value)
MyBase.Add(New KeyValuePair(Of TKey, TValue)(key, value))
End Sub
Public Shadows Sub Add(value As KeyValuePair(Of TKey, TValue))
_keys.Add(value.Key)
_values.Add(value.Value)
MyBase.Add(value)
End Sub
End Class
You use this class instead of the List<KeyValuePair<TKey, TValue>> you used. Since it inherits from List<>, it automatically exposes the index property and you get Keys and Values collections that are also indexed and support Contains since they are Lists too.
|
|
|
|
|
Well , I was thinking if a short way exist , because instead of doing your solution , I can just write
List1.Select(Function(t1) t1.key).Contains(MyKey)
But I thought this solution was not the best.
|
|
|
|
|
Define "not the best". That doesn't say anything at all about what's wrong with the approach. I can only guess at what you mean.
So, I go from the standpoint of performance. Every time this line is executed, the code has to build a collection of those keys from scratch and scan each key comparing to the input.
The way I do it, you're maintaining the list of keys constantly. It doesn't have to be built every time. I can also be improved for better lookup performance depending on requirements.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
