Visual Basic .NET is a .NET oriented-object implementation and evolution of Visual Basic developed by Microsoft.

learn more… | top users | synonyms

-2
votes
0answers
50 views

Apostrophe in sql string how can I remove [migrated]

I need some help. I use a combo box to create a sql query. Here is the query string SQlstr = "UPDATE maindata SET " _ & "?theoption1 = ?therec1 " _ & "WHERE acct = ...
2
votes
2answers
177 views

An algorithm that spreads similar items across a list

I need an algorithm that distributes same items across a list, so maximizing the distance between occurrences. E.g. I have a list of 15 items: {a,b,c,c,c,d,e,f,f,f,g,h,h,i,j} The algorithm should ...
2
votes
1answer
126 views

Trying to get a better understanding of Interfaces

Im working on a small program and I thought i would use it as a chance to get a better understanding of things I haven't really used before, mainly Interfaces and Inheritance from base classes. ...
0
votes
1answer
59 views

Generate all possible outcomes from pattern or range

I have multiple patterns that I want to expand. Expansion should expand number and letter ranges between curly braces. Numbers need to support padding. I want to have it expand into a List(Of String) ...
1
vote
1answer
73 views

How can I share a managed DBConnection across various objects?

I am implementing what I thought was a simple object wrapper around a database where one object "PartRecord" represents one row of a database table. I want a client to be able to request a given ...
3
votes
1answer
170 views

Where to keep global variables in Windows Forms App

I have here a Vb.Net employee management application. It has employees, managers, teams, trainings and so on. The way the application is set up now, data is read from the database in the startup form ...
0
votes
1answer
885 views

VB.NET - Serial Key Generating (Encryption, Hashing, Encoding?) Algorithm

I am trying to create a basic licensing system where I take a unique ID from the client computer, and I get this Hexadecimal string (hyphens removed e.g. "84-18-CE-...."): ...
1
vote
1answer
91 views

What is the best approach to storing a multi-dimensional array with unknown bounds?

I'm trying to store content scraped from several lyric and chord websites into separate variables into either a multi-dimensional array, or into separate string arrays, but I've been stuck trying some ...
3
votes
1answer
180 views

Compiler warnings and errors [duplicate]

I come from a C# background before my existing role. I am developing a VB.NET app. The code I inherited had option strict set to off and all other directives set to 'None'. I have recently switched ...
0
votes
2answers
112 views

Why And is needed when there is AndAlso

I have referred What is the difference between And and AndAlso in VB.net? to understand the difference between And and AndAlso. I am from C# background - and C# has AndAlso only - no And.. And I ...
0
votes
0answers
63 views

OPTION STRICT set to off

I am working on an application with over one million lines of code. OPTION STRICT is set to off!. I want to set it to ON during the next work iteration. I believe the only reason OPTION STRICT ...
0
votes
1answer
229 views

What language is better for working with databases? [closed]

I am going to develop a software that works with different databases and I'm considering whether to use .NET languages or C++. I've known that .NET features LINQ and ADO.NET but are there features ...
2
votes
1answer
185 views

When to add new project to solution?

I'm tidying up my company's Version Control Guidelines. One of my tasks is to determine how solutions should be organized in a very broad sense. I have somewhat come to my own conclusion that one ...
1
vote
2answers
73 views

Agile retesting

I wrote some code about two years ago, which was deployed to the production environment. The code deletes information that is six years old from a system. When it was first deployed there were only ...
0
votes
1answer
288 views

Is VB.Net deprecated by Microsoft? [closed]

I have come to this web page from Sony: http://www.sonycreativesoftware.com/scripting_in_vegas_pro_and_sound_forge We suggest you use C# for your scripts, since although you can currently write ...
1
vote
2answers
162 views

Sending emails from server side

I need to read some of your opinions. I'm developing a desktop app (.net/winform) to keep data in one place. This is used by several clients and the data is stored in MS SQL Server (client-server ...
0
votes
1answer
382 views

Are VB.NET and C#.NET projects created from Microsoft Visual Studio “Open Source” safe? [closed]

I'm developing software in VB.NET and C#.NET and planning to release their source codes as fully open source. Are these projects "open-source" safe? My doubts are: VB.NET and C#.NET are using the ...
1
vote
3answers
200 views

Where to Populate Objects

As mentioned in this question, I am moving our team towards objects (as opposed to just throwing DataTables and variables around everywhere). I have picked a suitable spot for the project that ...
3
votes
1answer
396 views

Why doesn't VB.NET allow unnamed, one-line objects to be used?

Why isn't this allowed in VB.NET: New SqlCommand("some string", someSqlConnection).ExecuteNonQuery() Why would the language have been designed to require that this be used instead: Dim com As New ...
0
votes
0answers
56 views

Inventory Management project Unit of measurement conversion issue

We are currently working on an inventory module. We have purchase requisition, purchase order, goods receipt modules etc. There is obviously the need for UOM or Unit of measurement conversion needed. ...
0
votes
0answers
204 views

Managing child worker thread list

After so much research, I thought I should ask the experts. I am working on a project for my corporate employer, we have android and iPhone mobile apps that make request to a web service, the request ...
3
votes
2answers
213 views

Improving the performance of a db import process

I have a program in Microsoft Access that processes text and also inserts data in MySQL database. This operation takes 30 mins or less to finished. I translated it into VB.NET and it takes 2 hours ...
1
vote
2answers
379 views

IL and case-sensitivity

Quoted from A Brief Introduction To IL code, CLR, CTS, CLS and JIT In .NET CLS stands for Common Language Specifications. It is a subset of CTS. CLS is a set of rules or guidelines which if ...
2
votes
3answers
315 views

Parallel.For Inconsistency results

I am using VB.net to write a parallel based code. I use Parallel.For to generate pairs of 500 objects or in combination C(500,2) such as the following code; but I found that it didn't always generate ...
1
vote
1answer
447 views

Should I just always Convert.ToInt32 my integers to account for potential nullable integers?

If my MSSQL database contains a data type that is NULL (i.e. null is allowed) then ORMs, such as EntityFramework in my case, create .NET objects that are nullable. This is great, and the way I use ...
-1
votes
1answer
464 views

Increase speed of a VB.net Application to SQL server 2008 and Hamachi VPN [closed]

Our current Information System (complete with path for pictures for records stored in db) has the following specifications: A desktop application was developed in vb.net We use SQL server 2008 r2 as ...
4
votes
2answers
338 views

Is CType() ever the preferred option?

Is there any time CType() is the proper option over other methods? I did plenty of thinking on this myself, but wanted to put the question in hopes there would be answer to my question so I can put ...
3
votes
5answers
1k views

Inner workings of the IF() function - why aren't expressions evaluated?

Short version How does the IF() function cause the passed expressions to NOT be evaluated prior to being passed in as parameters? Detailed version I am part of a standards committee, and a ...
1
vote
1answer
480 views

How can you denote the access modifiers “friend” and “protected friend” in UML?

The symbols for access modifiers that I know are relevant for many different languages: public:        + private:       - ...
4
votes
1answer
217 views

Reference Passing Style Anti Pattern

I'm working on a legacy VB.Net code base. There are very few functions that return values, most of the code is in subs/void methods. The general strategy seems to be to pass everything in by ...
0
votes
1answer
162 views

How should I implement “queueing” of approval on my objects?

I have a list of objects that will need to go through an approval process. I am curious if it would be best to simply add some properties to my object, like ApprovedBy, and ApprovedOn. Another ...
1
vote
1answer
96 views

Multiple visual studio projects/solutions on the go

I am working on a large asp.net app as a single developer. I will often work on a number of change requests concurrently. For example, a change required to the Finance component and a change ...
1
vote
3answers
633 views

Declare variable as interface

When should or shouldn't a variable be declared as a custom Interface type? When walking through some code, I required to know what was happening here: Public Class MyMainProject .... Public ...
2
votes
5answers
548 views

OOP concept: is it possible to update the class of an instantiated object?

I am trying to write a simple program that should allow a user to save and display sets of heterogeneous, but somehow related data. For clarity sake, I will use a representative example of vehicles. ...
2
votes
1answer
746 views

Mixing Fowlers Transaction Script and Domain Model

I am developing a large application where the previous developer used Martin Fowlers Transaction Script pattern. The requirements are becoming more complex and it is becoming a bit of a maintenance ...
0
votes
1answer
273 views

Is VB.NET a viable migration path for an application currently scripted in VBScript? [closed]

Our C++ MFC application gives the user the ability to define custom scripts in vbscript (via the VBScript engine). Since (parts of) the application are moving to .NET anyway, and since vbscript seems ...
0
votes
1answer
1k views

Introducing Fowler's Table Data Gateway to refactor poorly designed systems

I am developing an application, which currently has about 150,000 lines of code. The previous developer didn't really use any discipline when writing code. Application is in production but is ...
2
votes
2answers
376 views

Not using SQL Transactions

I am looking at a codebase where a developer never uses SQL transactions i.e. each update/insert into the SQL database is an atomic operation. I believe the codebase would benefit from transactions. ...
1
vote
1answer
520 views

VB.NET: Two tiers for three layers or three tiers for three layers

I asked a question on StackOverflow in November about separating a very large application into layers and tiers: http://stackoverflow.com/questions/13342626/net-divorcing-layers. The previous ...
4
votes
2answers
561 views

How do I handle having so many SQL queries?

I have an MVC3 project that uses SQL Server. I use data from the SQL database all the time and I often find that I'm reusing/duplicating some SQL queries. I thought I'd solve this problem by creating ...
5
votes
2answers
693 views

COM INTEROP Support - which is better? C# or VB

I keep hearing that c# is "better" than vb... but as far as I can see, aside from syntactical differences, both compile down to the same IL. I've found some good articles by googling that explain what ...
2
votes
4answers
324 views

Should we hire a new developer now, or wait until the code is refactored to make it suitable for a team environment?

I support and develop a large system that uses various technologies e.g. c++,.net,vb6 etc. I am a sole developer. I am debating whether now is the right time to approach my manager (who is not a ...
0
votes
4answers
1k views

Obtain reference to Parent object during instantiation

I have a situation where a custom class is a property of another class. What i need to be able to do, if it is possible at all, is obtain a reverse to the "parent" class (ie the the class that holds ...
2
votes
6answers
4k views

How get and set accessors work

The standard method of implementing get and set accessors in C# and VB.NET is to use a public property to set and retrieve the value of a corresponding private variable. Am I right in saying that ...
3
votes
2answers
3k views

Does 'Me' in VB.NET refer to the instantiated object only?

Does 'Me' in VB.NET refer only to an instantiation of the type? Just occurred to me that since I can reference properties in my VB.NET class without using 'Me', that I don't see a reason for using it ...
7
votes
3answers
1k views

Naming Convention for Dedicated Thread Locking objects

A relatively minor question, but I haven't been able to find official documentation or even blog opinion/discussions on it. Simply put: when I have a private object whose sole purpose is to serve for ...
2
votes
4answers
3k views

.NET mulithreading and quad core processors

I have a single threaded application that runs on a machine with a quad core processor. The scheduled tasks that run VB.NET forms are too slow. I am new to multi threading and parallel computing. ...
-2
votes
3answers
5k views

How do I Export to excel on aspx page?

I am trying to take data that I request from an access database and put it into and excel file on the client computer. I usually use ajax to request a summary of the data I need. It is formatted ...
2
votes
2answers
1k views

Testing my VB.NET code?

I'm having trouble developing unit testing approaches to testing both if the "code does what I want it to do", and testing "does my code work". For example, I'm writing code to validate input that ...
6
votes
2answers
955 views

.Net Language Interoperability Gotchas [closed]

I hope this is the appropriate forum to ask this question. A group of colleagues and I just starting learning C# a few weeks ago and we are planning on having a discussion about language ...