Search:

Hi,

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...

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...

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...

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.

I think...

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...

Out of interest, why hasn't anyone suggested using:

\d{6}$

for the bit after the period (to match 6 numbers)?

Am I missing something?

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;"
...

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).

It...

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...

Sorry, you're right. I stand corrected.

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).

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...

Does On Error Goto even work in VB.NET any more?

What exactly is a dropdown list? Assuming it is some kind of customised ComboBox you should do this:



Public Class Form1
Inherits System.Windows.Forms.Form

Private WithEvents...

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...

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...

Hi,

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.

My...

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...

Hi,

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...

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...

Hi,

I am using SQL Server 2005. I have two tables:

Products - has the following columns:

PK_ProdID
ProdName
etc..

Out of interest, can SSRS be set up to pull data from two separate databases into one report?

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...

Hi,

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...