How do I show the results of a stored procedure in a datagrid?

[Jim]

Can someone, please, show me how to display the results of
a stored procedure in a VB.NET datagrid on a winform? I'm
a newbie.

Here's my SQL 2000 stored precedure that returns the
status of SQL Jobs as a table.

=============== =============== =============== =====
CREATE PROCEDURE [dbo].[GetRunningJobs] AS

EXEC msdb.dbo.sp_hel p_job @execution_stat us = 0

GO
=============== =============== =============== =====
Thanks,

Jim

[CJ Taylor]

Create a dataadapter and assign the select query to this stored proc in your
database. Then, you could create a strongly typed dataset from this, and
assign your datagrid's datasource to your new dataset.

Peace,
cege
"Jim" <an*******@disc ussions.microso ft.com> wrote in message
news:05******** *************** *****@phx.gbl.. .

Can someone, please, show me how to display the results of
a stored procedure in a VB.NET datagrid on a winform? I'm
a newbie.

Here's my SQL 2000 stored precedure that returns the
status of SQL Jobs as a table.

=============== =============== =============== =====
CREATE PROCEDURE [dbo].[GetRunningJobs] AS

EXEC msdb.dbo.sp_hel p_job @execution_stat us = 0

GO
=============== =============== =============== =====
Thanks,

Jim

[Jim]

It's not a select query. I can do select queries. I can
start a stored procedure and get the single integer result
that says the procedure completed. I just can't seem to
get the returned table into a datagrid.

Jim

-----Original Message-----
Create a dataadapter and assign the select query to this stored proc in yourdatabase. Then, you could create a strongly typed dataset from this, andassign your datagrid's datasource to your new dataset.

Peace,
cege
"Jim" <an*******@disc ussions.microso ft.com> wrote in messagenews:05******* *************** ******@phx.gbl. ..

Can someone, please, show me how to display the results of a stored procedure in a VB.NET datagrid on a winform? I'm a newbie.

Here's my SQL 2000 stored precedure that returns the
status of SQL Jobs as a table.

=============== =============== =============== =====
CREATE PROCEDURE [dbo].[GetRunningJobs] AS

EXEC msdb.dbo.sp_hel p_job @execution_stat us = 0

GO
=============== =============== =============== =====
Thanks,

Jim

.

[CJ Taylor]

Dude...

it has to be a select query... thats how data grids work... if you want to
return a single result from a stored proc, don't use a datagrid. Thats like
using a backhoe to plant a daisy...

and if its a "returned table" then yes, thats a select query.

"Jim" <an*******@disc ussions.microso ft.com> wrote in message
news:0c******** *************** *****@phx.gbl.. .

It's not a select query. I can do select queries. I can
start a stored procedure and get the single integer result
that says the procedure completed. I just can't seem to
get the returned table into a datagrid.

Jim

-----Original Message-----
Create a dataadapter and assign the select query to this

stored proc in your

database. Then, you could create a strongly typed

dataset from this, and

assign your datagrid's datasource to your new dataset.

Peace,
cege
"Jim" <an*******@disc ussions.microso ft.com> wrote in

message

news:05******* *************** ******@phx.gbl. ..

Can someone, please, show me how to display the results of a stored procedure in a VB.NET datagrid on a winform? I'm a newbie.

Here's my SQL 2000 stored precedure that returns the
status of SQL Jobs as a table.

=============== =============== =============== =====
CREATE PROCEDURE [dbo].[GetRunningJobs] AS

EXEC msdb.dbo.sp_hel p_job @execution_stat us = 0

GO
=============== =============== =============== =====
Thanks,

Jim

.

[Jim]

Maybe I'm confused? Are you saying that "GetRunningJobs "
is my SELECT statment? This returns a table.

Here's where I'm getting stuck:

Dim myConn As SqlConnection = New _
SqlConnection
("server=abc;da tabase=Northwin d;integrated security=SSPI")
Dim myDA As New SqlDataAdapter

myDA.SelectComm and = New SqlCommand
myDA.SelectComm and.Connection = myConn

'-------What do I do here?
myDA.SelectComm and.CommandText = "GetRunningJobs "
myDA.SelectComm and.CommandType = _
CommandType.Sto redProcedure
'-------
' OR
'-------
myDA.SelectComm and.CommandText = "EXEC GetRunningJobs"
myDA.SelectComm and.CommandType = _
CommandType.Tex t
'--------

myConn.Open()

' Then which execute command do I use and how?
myDA.SelectComm and.??????????? ?
.ExecuteNonQuer y
.ExecuteReader
myConn.Close()
Jim

[Jim]

Thanks for your help. The light bulb just lit up in my
head! Here's how I got it to work:

=========
myDA.SelectComm and = New SqlCommand
myDA.SelectComm and.Connection = myConn

'Note I'm running the stored procedure through t-sql.
myDA.SelectComm and.CommandText = "Exec GetRunningJobs"

myDA.SelectComm and.CommandType = CommandType.Tex t

myConn.Open()
myDA.SelectComm and.ExecuteNonQ uery()
myDA.Fill(myDS, "Jobs")
myConn.Close()

DataGrid1.DataS ource = myDS
DataGrid1.DataM ember = "Jobs"
=========

Jim

[CJ Taylor]

Awesome. =) Nice job.
"Jim" <an*******@disc ussions.microso ft.com> wrote in message
news:01******** *************** *****@phx.gbl.. .

Thanks for your help. The light bulb just lit up in my
head! Here's how I got it to work:

=========
myDA.SelectComm and = New SqlCommand
myDA.SelectComm and.Connection = myConn

'Note I'm running the stored procedure through t-sql.
myDA.SelectComm and.CommandText = "Exec GetRunningJobs"

myDA.SelectComm and.CommandType = CommandType.Tex t

myConn.Open()
myDA.SelectComm and.ExecuteNonQ uery()
myDA.Fill(myDS, "Jobs")
myConn.Close()

DataGrid1.DataS ource = myDS
DataGrid1.DataM ember = "Jobs"
=========

Jim