andrewsw's Profile User Rating: *****

Reputation: 5477 Overlord
Group:
Moderators
Active Posts:
21,875 (17.65 per day)
Joined:
12-December 12
Profile Views:
162,302
Last Active:
User is offline Today, 03:16 PM
Currently:
Offline

Previous Fields

Country:
GB
OS Preference:
Windows
Favorite Browser:
Who Cares
Favorite Processor:
Who Cares
Favorite Gaming Platform:
Who Cares
Your Car:
Who Cares
Dream Kudos:
4725
Expert In:
VB.NET C# JS Python
Icon   andrewsw Giggity, Giggity, Goo!

Posts I've Made

  1. In Topic: Simple Windows Forms Application very slow during testing

    Posted 4 May 2016

    Yup. (I think someone might have added Windows Forms to the title subsequently.)
  2. In Topic: Export data from sql server to excel with headers in vb .net

    Posted 4 May 2016

    You could use the following and write the column names to the Excel row.
    USE [Database Name]
    SELECT COLUMN_NAME,* 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = 'YourTableName' AND TABLE_SCHEMA='YourSchemaName'
    

    Note that you should be using parameterized queries, not concatenating values like '" & (Label13.Text) & "'. Also rename all your controls to something meaningful other than the defaults Label1, TextBox2, etc..



    If you want all the data from the DataTable into Excel then an alternative approach is to save this data as XML and get Excel to open this file (it will include a header row).
  3. In Topic: Simple Windows Forms Application very slow during testing

    Posted 4 May 2016

    Is this ASP.NET? Reads more like a WinForms app to me.

    Moved to C# forum.
  4. In Topic: Need help Connecting program to MS Access database

    Posted 3 May 2016

    java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Exception occuring. Why?

    Not using Access should also be considered.
  5. In Topic: Loop code to apply to an object number

    Posted 3 May 2016

    I gave in as well ;)
    We also cannot add the oval directly to the form, it needs a container.. and the container needs a size, and the ovals need a specified FillStyle otherwise the colour won't show. So I've learnt a few things myself.

My Information

Member Title:
Beach ready
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:
Interests:
Fixing you
Programming Languages:
VB.NET, C#, Java, SQL, PHP, JavaScript, jQuery, HTML, CSS, Python, VBA, VB6, Regex

Contact Information

E-mail:
Private
Website URL:
Website URL  http://andrewg.comuf.com/

Comments

  • (2 Pages)
  • +
  • 1
  • 2
  1. Photo

    zorror Icon

    27 Jan 2016 - 03:56
    Thanks for fix with code tags.
  2. Photo

    livetrainstatus Icon

    13 Dec 2015 - 03:38
    Thanks for your help..help me to get the answer
  3. Photo

    BookMark Icon

    04 Sep 2015 - 16:36
    Thanks for the help, I appreciate it.
  4. Photo

    jeffindenver Icon

    29 Aug 2015 - 05:22
    Thanks for being so active and answering questions on the vb.net subforum.
  5. Photo

    andrewsw Icon

    15 Aug 2015 - 12:49
    You're welcome. You can press the green plus-button if a post has been helpful.
  6. Photo

    alexstrinda Icon

    15 Aug 2015 - 11:31
    Helped me to get to the right answer! Thanks!
  7. Photo

    matt4051 Icon

    23 Jul 2015 - 16:21
    Offers really good help, i am very appreciated that he took the time to check my work out
  8. Photo

    _KABOOSE_ Icon

    05 Jul 2015 - 12:28
    awesome
  9. Photo

    mbole87 Icon

    01 Apr 2015 - 00:58
    Andrewsw helps me second time, awesome.
  10. Photo

    farad Icon

    15 Nov 2014 - 16:34
    One of the best...
  11. Photo

    abdalraheem Icon

    31 Dec 2013 - 04:59
    Thanks
  12. Photo

    Michael26 Icon

    14 Nov 2013 - 04:21
    Boom, 2000 rep points :)
  13. Photo

    laytonsdad Icon

    21 Aug 2013 - 14:03
    Getting close to 1500 rep, you are a robot.
  14. Photo

    Flukeshot Icon

    14 Jul 2013 - 16:09
    1337 reputation points, truely elite!
  15. Photo

    Michael26 Icon

    09 Jun 2013 - 14:11
    Wow andrew, you're on fire this month
    82 reputation points, nice :)
  • (2 Pages)
  • +
  • 1
  • 2