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

Reputation: 385 Architect
Group:
Expert
Active Posts:
1,057 (0.77 per day)
Joined:
17-July 10
Profile Views:
9,397
Last Active:
User is offline Apr 11 2014 06:23 AM
Currently:
Offline

Previous Fields

Country:
RO
OS Preference:
Windows
Favorite Browser:
Internet Explorer
Favorite Processor:
Who Cares
Favorite Gaming Platform:
PC
Your Car:
Who Cares
Dream Kudos:
0
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

    Quote

    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))
    AS 
        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
Age:
26 years old
Birthday:
August 27, 1987
Gender:
Location:
Bucharest
Full Name:
Ionut Dragu
Years Programming:
2
Programming Languages:
Delphi, C#, VBA, SQL

Contact Information

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

Comments

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!
    http://www.dreamincode.net/forums/topic/285850-read-file-in-ftp-server-and-execute-a-fuction/
  2. Photo

    Bluezap Icon

    15 Jul 2012 - 02:36
    Can you please help me out with this. Thanks
    http://www.dreamincode.net/forums/topic/285850-read-file-in-ftp-server-and-execute-a-fuction/
  3. Photo

    nK0de Icon

    17 May 2012 - 10:48
    having seen your sig, check this out. http://theoatmeal.com/comics/tesla
    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 :http://www.dreamincode.net/forums/topic/215826-how-to-show-people-that-are-online/page__p__1249970__fromsearch__1&#entry1249970
  8. Photo

    cornetto456 Icon

    13 Feb 2011 - 09:55
    Hi can you help me with my question http://www.dreamincode.net/forums/topic/215826-how-to-show-people-that-are-online/ Thanks :D
Page 1 of 1