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

Reputation: 180 Stalwart
Group:
Expert
Active Posts:
1,609 (0.6 per day)
Joined:
17-April 07
Profile Views:
32,599
Last Active:
User is offline May 26 2014 12:40 AM
Currently:
Offline

Previous Fields

Country:
IN
OS Preference:
Windows
Favorite Browser:
FireFox
Favorite Processor:
Intel
Favorite Gaming Platform:
PC
Your Car:
Who Cares
Dream Kudos:
400

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 vb.net it's a big thing to me
    i go search for everything in dreamincode, google, yahoo, and some search sites

    you know
       app.path
    
    

    to
    my.application.info.directorypath()
    
    

    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 vb.net 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 vb.net
    when i came to post a tutorial on vb.net section here PsychoCoder insist me avoid the old msgbox function and use the messagebox.show 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
            Else
                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
    reason
    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
    ok
    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
    NET USE  LPT1:  \\SERVERNAME\PRINTERNAME
    
    

    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

My Information

Member Title:
D.I.C Lover
Age:
32 years old
Birthday:
May 11, 1982
Gender:
Location:
m-162, malligainagar, anniyur, madurai-17, tamilnadu
Years Programming:
6
Programming Languages:
vb,vb.net,c#,c#.net, MS SQL,SSIS,SSRS, SSAS

Contact Information

E-mail:
Private
AIM:
AIM  Thavarajan
Website URL:
Website URL  http://
Yahoo:
Yahoo  thava_niit@yahoo.co.in

Comments

Page 1 of 1
  1. Photo

    thava Icon

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

    jesicalbaby Icon

    16 Sep 2013 - 14:30
    Hello
    My name is Miss jesical,
    i saw your profile today
    and,i fill more interest to contact you ,
    i will like you to please send me
    an email via (jesicalduncan22@yahoo.com)
    for me to send you my picture
    jesicalduncan22@yahoo.com
  3. Photo

    raziel_ Icon

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