Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 req

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-01-06 : 08:16:50
elmira writes "i wanna use sql statments in vb , bt i dont know where to write them actullt i just know there is a place in visdata and in datareport, bt i wanna use it in main program ,for example insted of add or del, or update buttoms ,i click them and write sql code insted of vb codes ? how can i make it passible"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-01-06 : 12:11:21
It sounds like you need to pick a book or start doing some tutorials. Also, keep your T-SQL code in stored procedures. That'll require another book.

Tara
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2004-01-06 : 15:09:26
I agree with Tara that some reading is definitely in order because you're going to need to learn about ADO, Connection and Command Objects, and as Tara mentions, stored procedures are better than embedded SQL code for numerous reasons, so that's another subject to get your hands on. I would expect most VB development books to contain a couple of chapters on ADO and the other objects I mentioned.

--------------------------------------------------------------
Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url]
Go to Top of Page
   

- Advertisement -