Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / Languages / VB.NET / March 2008

Tip: Looking for answers? Try searching our database.

Execute a stored procedure from Visual Basic 2008 express

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Xand3ros - 06 Mar 2008 20:47 GMT
Hi, sorry for what will most likely be seen as a noob question, but
here we go.

in SQL 2000 i have a Stored Proc, (lets call it sp_xxx)
this stored proc requires three pramaters to run as shown below,

EXEC sp_xxx 'param1','param2','param3'

the stored proc runs fine,
my dilemma is that now i have created this lovely stored proc,
management want it to be encased in a lovely GUI.

sadly i am fluent in SQL not VBA.

i can make a VB form (very basic one) and do very basic things, but
what i need to know is the following

1. how do i execute a stored proc from VB (im using Visual basic
express 2008)
2. if possible how do i then have a page that gives the option to
view
on screen or print???

Noobish i know but as i said, fluent in SQL not VBA

Any help is GREATLY APPRECIATED.

Many thanks
Trammel - 07 Mar 2008 00:40 GMT
> Hi, sorry for what will most likely be seen as a noob question, but
> here we go.
[quoted text clipped - 24 lines]
>
> Many thanks

Wait... you tried google first, yeah?
http://216.239.59.104/search?q=cache:d_17Us0VIJ0J:www.databasejournal.com/featur
es/msaccess/article.php/3505836+VBA+SQL+Exec&hl=en&ct=clnk&cd=4

Cor Ligthert[MVP] - 07 Mar 2008 04:20 GMT
Xandros,

For you start you have to know what is Visual Basic 2008 express and what is
Visual Basic for Application, which start both with a V. Almost the same as
Cobol and C#, those start both begin with a C.

In fact you have to search for:
SqlConnection
SqlDataAdapter
SqlDataTable
SqlParameters

This does not matter if it is for managed C#, VB or C++.

You cannot use it with VBA.

The best places to start your search, there where you have downloaded your
VB and Google newsgroups.

Cor

> Hi, sorry for what will most likely be seen as a noob question, but
> here we go.
[quoted text clipped - 24 lines]
>
> Many thanks

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.