thava's Profile User Rating: *****

Reputation: 180 Stalwart
Active Posts:
1,627 (0.49 per day)
17-April 07
Profile Views:
Last Active:
User is offline Mar 30 2016 12:32 AM

Previous Fields

OS Preference:
Favorite Browser:
Favorite Processor:
Favorite Gaming Platform:
Your Car:
Who Cares
Dream Kudos:

Latest Visitors

Icon   thava thinking about future....

Posts I've Made

  1. In Topic: Accessing Excel through SQL Server

    Posted 15 May 2014

    the following one is for CSV, you may Argue Bulk copy will more handy, This is just for a knowledge sharing
    SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Text;Database=D:\From\RamITM\;Extended Properties="text;HDR=Yes;FMT=Delimited"','SELECT * FROM vgusers.csv');
    SELECT * FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0','Data Source = D:\From\RamITM;Extended Properties = "Text;HDR=YES;"')...vgusers#csv
  2. In Topic: VB.NET Roll Call

    Posted 14 May 2014

    View Postthava, on 17 April 2010 - 03:11 AM, said:

    hi to all
    basically i am a vb6 programmer with some basic maths knowledge
    so when i switch over to it's a big thing to me
    i go search for everything in dreamincode, google, yahoo, and some search sites

    you know


    i search this thing also

    then very later i know there is a built in utility in VS in the tools menu,
    so i decided to go to a basic course for to know about the VSIDE

    there, i only know about the known things,
    then i self study it

    i use the old vb6 functions in
    when i came to post a tutorial on section here PsychoCoder insist me avoid the old msgbox function and use the and also insist me to avoid the legacy vb6 functions

    now i am work with in an account's application with some neat coding thank's to dream-in-code

    i think, still a long way to go in this journey

    well almost 4 years hope i will be in that list soon
  3. In Topic: if() and iif(), when might we use the latter?

    Posted 14 May 2014

    i think My example explain what you need
            Dim Rowcount As Integer
            If Table IsNot Nothing AndAlso Table.Rows.Count > 0 Then
                Rowcount = Table.Rows.Count
                Rowcount = 0
            End If
            Rowcount = IIf(Table IsNot Nothing AndAlso Table.Rows.Count > 0, Table.Rows.Count, 0)

    in the above snippet look like both if and iif are doing the same but in real when you run this code
    IIF will raise an error
    if block is executed step by step first the expression then based on the expression either true part or false part
    where as IIF is executed at a single stroke,(i.e) IIF evaluate the entire expression
  4. In Topic: Why should I call RemoveHandler before AddHandler ?

    Posted 9 May 2014

    it is always better to learn from our mistake instead of some one teach us
    i will give you a simple idea
    show a messagebox in the keypress event and comment the removehandler lines

    now run and edit the cells 5 times,
    now you are able to understand why remove handler is there and what went wrong if you remove it! ;)
  5. In Topic: How to Print from VB.Net to Printer zebra z4m

    Posted 9 May 2014

    actually you need to send this file via a command mode through LPT1

    you have two way
    one is you need to set the printer configuration by setting the allow Printer spooling enabled under the ports Tab and select the LPT1

    or else Redirect the printer by using NEt USE command
    like this

    keep in mind the printer should be access by command mode

    set the sharing printer as your default printer
    now print the file you are able to see the barcode now


Page 1 of 1
  1. Photo

    thava Icon

    18 Sep 2013 - 20:02
    sorry dear,your are bit of late
  2. Photo

    raziel_ Icon

    10 Dec 2010 - 06:13
    sup dude where have you been :)
Page 1 of 1