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.
| Author |
Topic |
|
jamie123
Starting Member
15 Posts |
 Posted - 2008-05-30 : 12:03:47
|
| I know this thread is sql, and i'm asking a vb.net question but I cannot find a straight forward answer anywhere else. I am using visual studio 2008 designing a vb.net application where I created a stored procedure using sql management studio 2005. Here is the stored procedure:CREATE PROCEDURE dbo.StoredProcedure2@intPID char(10)ASSELECT SUM(Financial.Fee) from dbo.Financial WHERE CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, getdate())))=CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, Financial.Date))) AND [SPatient Number]=@intPID /* SET NOCOUNT ON */ RETURNIt takes the sum of my Fee column in my financial table where the current date is equal to the column named Date in my Financial table and SPatient Number equals my variable intPID, which the value is defined for in my application (yes, i know that is a horrible name for a column but I cannot change it for it is not my project). Now, to my knowledge this procedure works fine and should output a single value. However, like i said, i am using visual studio 2008 and therefore am using vs's more automated way of connecting to sql servers(and by that I mean configuring the server through visual studio rather than manually defining datasets, dataadapters, and connection strings through code) All of the tutorials I find use data adapters and are done by manually declaring sql connections and so forth. I like visual studios more automated method of doing sql tasks, and would like to know if there is a simple way to call a stored procedure using visual studio in such a fashion where I would write something like "exec dbo.StoredProcedure2 'intPID' "Any help is much appreciated, thank youedit: If i did not provide enough information please let me know, i'm using a strongly typed dataset |
|
|
jamie123
Starting Member
15 Posts |
Posted - 2008-05-30 : 12:38:29
|
| found it out on my own, for anyone who is having the same problem as me; look in the dataset designer, right click and add query from existing stored procedure, select your stored procedure settings, create it. wherever you need the stored procedure to be executed, do this mytableadapter.mynamedquery(whateverparametersyouhave). |
 |
|
|
|
|
|
|
|
calling a stored procedure from vb.net