I have and still do program principally in a procedural manner. I've never created objects or ever used the OOP paradigm. I understand the concept certainly, and know generally how it works but have never implemented it. I presume this leaves me though with limited options in the future as OOP is and has been all the rage, especially now that VB.Net is full OOP. Event still, I've written both ASP.Net and VB.Net applications without using OOP, or not that the product didn't create itself.It appears I am not alone either, there seems to be a number of people far more intelligent and experienced than I that eschew OOP.
Our company currently uses an APL model to illustrate our life products. We are in the process of converting this to Excel/VBA because the APL system is extremely difficult to maintain.APL is difficult to maintain because the code has become over the years (~15yrs) spaghetti and only a select people (who have worked here 5+years) really understand this to make updates when new products come out. APL is also not well known and difficult to understand. I just would like help on designing the system, my main career is not a programmer, and the design I was envisioning was a "Procedural" approach. (the APL is procedural rather then object oriented. I have not used object oriented code before)Basically the program illustrates a life insurance product. That just means it projects a fund out from the time the policy is issued to age 120. The illustration is given to the policyholder as a way of predicting what the value of their fund will be given some assumptions.The program does the following1.) Populate Variables2.) Calculate Premiums Types3.) Monthly processing4.) Output values to spreadsheetThe system has to illustrate different types of Products and we are adding new products to the system. Most of the main structure of the program (in VBA) is already written. It seems that (#3) monthly processing will vary by product, and I would like help with maintaining that part of the code. The other 3 parts of the program are not a problem maintaining.We will be continually adding products. We will start with about 5 products and maybe add about 5 per year.Here is the Monthly Processing code:... Call MonthlyProcessing(120, PremPayMode0, Assump0, True, DumpLumpSum0)
I am having trouble understanding the proper implementation of Dispose. While I totally understand the IDEA behind it (Ensuring that variable references to objects are released and free to be GC'd), I am not sure I am doing this properly.I try to call dispose on all items delcalred and used within a procedural scope when I am done with them (or even better, employ a Using block).When I declare Class-level items, I assume I should call dispose on them prior to destroying the class (During the "Disposed" event, right? which will occur when "Dispose" is called on my class?).As Declared in Class-level Declarations:
Public Class MyDisposableClass Implements IDisposable Protected mImgExpand As Image = My.Resources.ListCollapsePNG9x9_DK[code]........
When THIS class is instantiated within another class (Say, a form),I call "Dispose" on THie instance of this class during the form's "Close" Event. Everything seems to work fine. However,when I step through the code, things seem to go in a circle. We go from the close event, which calls dispose on the class instance, to the class instance dispose event, then back to the parent class disposed event, etc.
I'm sure this is straightforward but I cannot find the correct string to get a google result. In VB.NET what is the difference between = (equals sign) and := (colon followed by equals sign)?
know the difference between C#.Net and VB.Net. I use C#.Net for my projects, but when ever I met with some other programmers they often called VB.Net more powerful and easy, than C#.Net. I always asked them "Why it is more powerful then C#, since it uses the same framework?" but still I didn't get any answers.
what exactly distinguishes a COM component from a DLL? Isn't a COM component just a library of functions that can be called from another application? Why is using a COM component so much more complicated than just registering it like one would do with a DLL?
I was under the assumption that VB's For Each loop was the same as a For Next loop. But when i try running the following code I do not get the expected result.
For those who have experience, working with VB.NET, it's easier to use SlimDX or SDL? The tutorials for SlimDX are already written for .NET, but I've read that SDL it's a lot easier than DirectX itself.in my case, I just need 2D graphics.
What is the major difference between 'for each' and 'for' loops in .NET? Is there any performance gain while comparing these two? Which one gives a better performance/faster/memory management?
I have in the past used .net executables as libraries. I'd just add them to the references in visual studio and I was ready to go. Today I tried the same to a new exe (actually mine) and it doesn't seem to work. When I add it to Visual Studio and try to watch its members on the Object Browser, it doesn't show up anything inside that executable's assembly.
I know the main difference between an exe and dll is that the first has an entry point while the 2nd doesn't. Are there any more differences? I know that unmanaged dll's also have a DLL entry point, do .net have one too?Also, what might be the reasons that could make my standard exe/dll (with this i mean, not obfuscated or anything extreme like that) not show up anything in the Object Browser?
What's the difference between / and for division in vb.net? My code gives very different answers depending on which I use. I've seen both before, but never knew the difference.
I am trying to find the difference between two dates. The first of the two dates can be changed and when it is changed, the difference between the original dates has to be retained. This means that I have to automatically change the second date to have the same difference in days as it did before, but with a new first date. [code]I have the value of the old date1(currDate) and the new date1 value(newDate). I need to get the difference between these, and then add or minus these days from the endDate.
I'm making a form with an overview of orders from our clients. I have inserted 2 datetimepickers so the users can choose a period.
To know how many cols I need in my grid, I need to know how many months there are between the 2 datetimepickers. But that seems to be the problem. How do I get the number of months starting from one datetimepicker untill another.
I am a VB programmer working my way into C#. I learned how to create and raise events in vb and am finding that it isnt done the same way in C#. Has anybody come across an article that will help me to understand how to do events in C# and maybe explain why it is different in VB.
for determining whether a string of data contains certain text, which is more efficient? I have read elsewhere that there is somewhat of a consensus to avoid legacy functions, since they may or may not be available in future versions.However, trying to use the contains method (or indexof equivalent of Instr) is causing me problems, I think, because I am having trouble performing a case-insensitive search.
I am trying to be efficient and functional in my code. I am reading an INI file, and I have preloaded the contents of the file into a String variable, for 2 reasons. 1) If I can test if a certain section exists in the code, I can avoid attempting to read a section of empty data (the INI reader class I have chosen returns the value or an empty string for a given request). More importantly, 2) I have created a data field that is not INI compliant (at least not to the API?) as it is a data field that can contain an arbitrary (unlimited?) amount of data which is a hex-encoded representation of serialized byte data. I need to be able to determine if this value exists in the file and retrieve it using normal string manipulation, since the INI handler will not pass strings longer than 256Chr.
So, the problem I am having is getting "strFileContents.Contains("data=")" to return true in the case where the file contains "Data=". This could be data=, DATA=, DaTa=, etc.Instr has the option "CompareMethod.Text" which, I believe, does a case insensitive text search. What is the equivalent for "Contains"?
I get (depending on the way I try to use "Test") either "'Name' is not a member of '<Default>'." or "Type 'Name.Test' is not defined." in my error list. I've found two ways to make it work, but neither are reasonable to expect of a user. One is to remove the "Root Namespace" from the project properties. The other is to include that namespace between "Global" and "Name".
I have made a custom tool that uses CodeDom to generate code for both C# and VB.NET. This is the reason why neither of the two fixes above are feasible: I can't expect my users to have an empty root namespace, and I'd hate to have to do VB-specific tricks in my code generation (kind of defeats the purpose of using a language-neutral tool, doesn't it?) such as picking out the "Root Namespace" (not that I'd know how off the top of my head) and including it in my code generation.
I don't want to leave out the global modifier either, because it protects the tool from users picking bad names for the generated output. Does anybody have a suggestion for how I should deal with this?
Is there any differnce between the following syntax? Im thinking that there isnt, as long as the end result of the "AS" portion has RuleType named "AS R.RuleType." Notice that the first snippet of code has the R.RuleType and the second has just Rule.Type.strRule.Append(
"select R.Ruleid,R.RuleNumber,isnull(C.ClientName,'') as ClientName,R.Customerid,Case R.RuleType when 'R' then 'P' when 'B' then 'G' else R.RuleType End as R.RuleType,isnull(C.InternalClientID,'') as InternalClientID,")
I have an app with one database, with one field/table.When i fill in this for the second time or more, i will see the diferens from last time til now.I want the diff betveen the two last records
Table 1= Water1 Last week we used 200 liter This week we used 210 liter, the diff is 10 liter