how to select or update or delete in VB6 using msSQL server 2005

Page 1 of 1

6 Replies - 3435 Views - Last Post: 16 April 2011 - 03:42 PM Rate Topic: ****- 1 Votes

#1 amyntas17  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 9
  • Joined: 10-April 11

how to select or update or delete in VB6 using msSQL server 2005

Posted 10 April 2011 - 10:55 PM

hi good afternoon to all....ahmm im new in vb6 because we started at VB.net 2k5 and my friend asks me to help him on his project using VB6 professional and the database would be a msSQL server 2005...we have established a connection and now our problem is this...

we can't select or update or delete the stored data in the database....i don't know the syntax because in .net we will just import the System.data.sqlclient...and in VB6 im totally no idea how to do that thing...

i hoped someone may find this thread and help us here...

i advance thank you for your help...

Is This A Good Question/Topic? 0
  • +

Replies To: how to select or update or delete in VB6 using msSQL server 2005

#2 maj3091  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 274
  • View blog
  • Posts: 1,652
  • Joined: 26-March 09

Re: how to select or update or delete in VB6 using msSQL server 2005

Posted 11 April 2011 - 01:55 AM

look in the tutorials section....it is in there
Was This Post Helpful? 1
  • +
  • -

#3 amyntas17  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 9
  • Joined: 10-April 11

Re: how to select or update or delete in VB6 using msSQL server 2005

Posted 12 April 2011 - 08:10 PM

View Postmaj3091, on 11 April 2011 - 01:55 AM, said:

look in the tutorials section....it is in there



i can't find it at the tutoriall the tutorial thread seems to be full of unfinish post....almost all are questions....too....


could you give me the link where i can find a sample for a INSERT SELECT UPDATE DELETE code using the msSQL server 2005....
Was This Post Helpful? 0
  • +
  • -

#4 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 562
  • View blog
  • Posts: 2,935
  • Joined: 19-May 09

Re: how to select or update or delete in VB6 using msSQL server 2005

Posted 12 April 2011 - 08:16 PM

just read the t-sql documentation that comes with it.
Was This Post Helpful? 1
  • +
  • -

#5 maj3091  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 274
  • View blog
  • Posts: 1,652
  • Joined: 26-March 09

Re: how to select or update or delete in VB6 using msSQL server 2005

Posted 13 April 2011 - 03:51 AM

Did you actually look at the tutorials??

THIS shows you how to connect to SQL server using ADO in VB6.

The Select, update, delete commands are SQL commands, so Bob as said, look at the T-SQL docs, or put your .net experience to use.
Was This Post Helpful? 1
  • +
  • -

#6 amyntas17  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 9
  • Joined: 10-April 11

Re: how to select or update or delete in VB6 using msSQL server 2005

Posted 16 April 2011 - 06:30 AM

View Postmaj3091, on 13 April 2011 - 03:51 AM, said:

Did you actually look at the tutorials??

THIS shows you how to connect to SQL server using ADO in VB6.

The Select, update, delete commands are SQL commands, so Bob as said, look at the T-SQL docs, or put your .net experience to use.


ahmm...i have already solve thanks for the reply guys...it really helps....
Was This Post Helpful? 0
  • +
  • -

#7 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 562
  • View blog
  • Posts: 2,935
  • Joined: 19-May 09

Re: how to select or update or delete in VB6 using msSQL server 2005

Posted 16 April 2011 - 03:42 PM

All right. Glad you've solved the problem. Now you see why it's best to let everyone know, yes? :)
Was This Post Helpful? 1
  • +
  • -
Page 1 of 1