August 24th, 2010 06:33 AM
I have a situation in a program I'm writing where I'm not sure of the best way of coding a couple of objects and was hoping for a few pointers.
I am using VB.NET 2003, so F/wrk v1.1. My...
August 24th, 2010 03:44 AM
Glad to help :)
I can't take full credit for the code, it is based on code I learnt from a really great book - "Building Client/Server applications with VB.NET: An example driven approach" by...
August 20th, 2010 12:38 PM
Not sure if it meets your requirements but I've been using Subversion (hosted with www.devguard.com) for the past 6 months with TortoiseSVN and have found it pretty useful. The only slight pain is...
August 20th, 2010 12:23 PM
That was weird.. i just walked in front of my pc and this notification just popped up in front of me. Seeing as I'm here and still in programming mode I'll try and help you out right now.
August 20th, 2010 06:23 AM
in VB6 you used to be able to do a single API call which would make windows think your app was a screensaver and would therefore not show up in any task manager-style programs at all.
Can you not...
August 20th, 2010 06:08 AM
Out of interest, why hasn't anyone suggested using:
for the bit after the period (to match 6 numbers)?
Am I missing something?
August 20th, 2010 05:48 AM
I also just noticed that your connection string has two data sources:
dbProvider = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\database1.accdb;Persist Security Info=False;"
August 20th, 2010 05:39 AM
I hope you don't mind, but I have had a go at re-writing your code in a way which I think should help you understand what I meant in my previous post (about encapsulating things into classes).
August 20th, 2010 04:41 AM
As a side-note you might want to use a StringBuilder to build your SQL statements. It can make things a lot easier to read once your SQL statements get really long. It can also help performance...
August 18th, 2010 06:26 AM
Sorry, you're right. I stand corrected.
August 18th, 2010 06:24 AM
I had no idea. I moved from VB6 to VB.NET a few years ago and I haven't used a single GOTO yet. TBH I thought it had been phased out completely with VB6 (and was glad of it).
August 18th, 2010 06:09 AM
Also agree this is incredibly bad as the sqlConn.Close() line would never get executed.
As a side-note to this, I have read that you should never close a database connection in a Finally block...
August 18th, 2010 05:44 AM
Does On Error Goto even work in VB.NET any more?
August 18th, 2010 05:37 AM
What exactly is a dropdown list? Assuming it is some kind of customised ComboBox you should do this:
Public Class Form1
August 13th, 2010 02:47 AM
I think for the amount of hassle that would take, I'm better off just having an overloaded method in each of my manager classes.
Thanks for the suggestions though. Out of interest, am I right in...
August 12th, 2010 11:18 AM
I hadn't thought of that but after a bit of investigating I think my manager classes would have to implement IList but, because they inherit from DictionaryBase, they don't.
I thought of adding...
August 12th, 2010 10:02 AM
I'm using VB.NET 2003 with .NET Framework v1.1. I know it's getting a bit old now but I'm stuck with an existing program and don't have the time/knowhow to convert it to anything newer.
March 31st, 2010 07:05 AM
I have just been playing around with indexes and it seems I can make a surrogate primary key on a table eg - ShiftID and also set up a unique index consisting of the Date and ShiftNo columns which...
March 30th, 2010 09:45 AM
I am trying to figure something out for an app I'm developing. I hope some people on here can point me in the right direction.
I need to have a database table (SQL Server 2005) which...
March 30th, 2010 09:04 AM
I think the confusion has occured because I didn't explain myself very well. These two tables are to store lists of products and the components that make up a product.
So any product can be made...
March 26th, 2010 05:53 AM
I am using SQL Server 2005. I have two tables:
Products - has the following columns:
March 25th, 2010 07:33 AM
Out of interest, can SSRS be set up to pull data from two separate databases into one report?
March 23rd, 2010 03:33 AM
Interesting.. thanks for the replies. I tried installing SQL reporting services a few days ago so I could play around with it but came across so many problems that I couldn't find answers to on the...
March 15th, 2010 07:05 AM
I'm currently writing an application for my company which takes all the orders on our system and batches them up into a day's work for a specified number of people. It will store basic timings...