Type: Posts; User: JohnnyD
Search took 0.03 seconds.
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...
Click Here to Expand Forum to Full Width