Ionut's Profile User Rating: -----

Reputation: 385 Architect
Active Posts:
1,057 (0.63 per day)
17-July 10
Profile Views:
Last Active:
User is offline Sep 28 2014 04:37 AM

Previous Fields

OS Preference:
Favorite Browser:
Favorite Processor:
Who Cares
Favorite Gaming Platform:
Your Car:
Who Cares
Dream Kudos:
Expert In:
VB.NET, Databases

Latest Visitors

Icon   Ionut .Invoke(Chillin)

Posts I've Made

  1. In Topic: Excel through VB

    Posted 10 Nov 2013

    To achieve your goal, you have different objects:
    1. Range: as in
     oSheet.Range("A"&i) = value

    2. Cells: as in
     oSheet.Cells(i, 1) = value 

    3. Rows
    4. Range.AutoFill

    And probably others. Check help file and MSDN for details and examples.
    Print is mainly used to print to a file.
  2. In Topic: Question about "Colfax Solution" VB Prob

    Posted 10 Nov 2013

     accumulator += Convert.ToDouble(ProbablySomeTextBox.Text)

    which is the same as
     accumulator = accumulator + Convert.ToDouble(ProbablySomeTextBox.Text)

    Read about assignment operators in VB.NET
  3. In Topic: ERROR in .NET Code: SQLException was unhandled - Invalid Column Name

    Posted 10 Nov 2013

     Acmd.Parameters.AddWithValue("InayName", SqlDbType.VarChar).Value = InlayNameTextBox.Text

    Maybe something wrong because here you have InayName and the name in your SQL statement is InlayName?
  4. In Topic: Database update with new columns

    Posted 8 Nov 2013


    AcceptChanges and RejectChanges only apply to DataRow related changes (that is, Add, Remove, Delete, and Modify). They are not applicable to schema or structural changes.

    This is taken from MSDN as I saw that you call this function to add new columns.
    To accomplish this task, I would use another query or a stored procedure (if you use MSSQL or something similar for other database engines).
    CREATE PROCEDURE uspAddColumns(@ColumnName as VARCHAR(20))
        DECLARE @query VARCHAR(500) 
        SET @query = '
        ALTER TABLE MyTable ADD ' + @Column + ' DATETIME'
        EXEC @query

    Then use a SqlCommand object to execute it. You can also write the query in code and past it to the command object as a commandType.Text.
  5. In Topic: Check if SQL Server Job already running?

    Posted 1 Mar 2013

    SMO may be the answer.
    Job class seems to be what you need.

My Information

Member Title:
D.I.C Lover
27 years old
August 27, 1987
Full Name:
Ionut Dragu
Years Programming:
Programming Languages:
Delphi, C#, VBA, SQL

Contact Information

Click here to e-mail me
MSN  ionut.dragu
Yahoo  dragu.ionut
Skype  ionut_dragu


Page 1 of 1
  1. Photo

    Bluezap Icon

    17 Jul 2012 - 08:05
    Could you please take a look at this if it isn't any trouble? Thnx!
  2. Photo

    Bluezap Icon

    15 Jul 2012 - 02:36
    Can you please help me out with this. Thanks
  3. Photo

    nK0de Icon

    17 May 2012 - 10:48
    having seen your sig, check this out.
    thought it would be interesting! :)
  4. Photo

    giorgospsk Icon

    02 Jan 2012 - 07:59
    hello. Have you seen the database i posted?
  5. Photo

    smohd Icon

    02 Sep 2011 - 11:31
    Congratulation and welcome to VB.NET experts
  6. Photo

    Tareshukla Icon

    26 Feb 2011 - 09:06
    Thanks for your kind suggestions.
  7. Photo

    cornetto456 Icon

    16 Feb 2011 - 08:49
    can you help me please :
  8. Photo

    cornetto456 Icon

    13 Feb 2011 - 09:55
    Hi can you help me with my question Thanks :D
Page 1 of 1