CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: JohnnyD

Search: Search took 0.01 seconds.

  1. Understanding object aggregation and databases

    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...
  2. Replies
    13
    Views
    2,440

    Re: VB and adding data to a database

    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...
  3. Replies
    3
    Views
    1,207

    Re: Source Control suggestions needed

    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...
  4. Replies
    13
    Views
    2,440

    Re: VB and adding data to a database

    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...
  5. Replies
    39
    Views
    101,719

    Re: How to hide your program from the Task Manager

    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...
  6. Replies
    16
    Views
    4,399

    Re: VB Regular Expression Help

    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?
  7. Replies
    13
    Views
    2,440

    Re: VB and adding data to a database

    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;"
    ...
  8. Replies
    13
    Views
    2,440

    Re: VB and adding data to a database

    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...
  9. Replies
    13
    Views
    2,440

    Re: VB and adding data to a database

    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...
  10. Replies
    10
    Views
    5,872

    Re: Dropdownlist add handler

    Sorry, you're right. I stand corrected.
  11. Thread: Code error

    by JohnnyD
    Replies
    15
    Views
    3,350

    Re: Code error

    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).
  12. Replies
    27
    Views
    3,750

    Re: Good Programming practice- using goto

    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...
  13. Thread: Code error

    by JohnnyD
    Replies
    15
    Views
    3,350

    Re: Code error

    Does On Error Goto even work in VB.NET any more?
  14. Replies
    10
    Views
    5,872

    Re: Dropdownlist add handler

    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...
  15. Re: Passing a Type as an argument...

    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...
  16. Re: Passing a Type as an argument...

    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...
  17. [RESOLVED] Passing a Type as an argument...

    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...
  18. Replies
    1
    Views
    874

    Re: Understanding keys and constraints...

    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...
  19. Replies
    1
    Views
    874

    Understanding keys and constraints...

    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...
  20. Re: AutoNumber ID column necessary in link table?

    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...
  21. AutoNumber ID column necessary in link table?

    Hi,

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

    Products - has the following columns:

    PK_ProdID
    ProdName
    etc..
  22. Re: Crystal Reports or SQL Reporting services for printing pick notes...

    Out of interest, can SSRS be set up to pull data from two separate databases into one report?
  23. Re: Crystal Reports or SQL Reporting services for printing pick notes...

    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...
  24. Crystal Reports or SQL Reporting services for printing pick notes...

    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...
Results 1 to 24 of 24





Click Here to Expand Forum to Full Width

Featured