when using Stored Procedure called from C# ?

[dongtrien]

In SQL Server 2005 Stored Procedure I have the following:

CREATE FUNCTION [dbo].[LISTSTAFF]()
RETURNS TABLE
AS    
RETURN(select * from tblStaff);

In C#2005 I assign staff style table for gridview an error, can you help me fix this ?

...
SqlCommand cmd = new SqlCommand("LISTSTAFF", cnn);
cmd.CommandType = CommandType.StoredProcedure;
gridview.DataSource = cmd.ExecuteReader();// waring error in here
...

I want assign list database style table for gridview.DataSource =... how assign ?

[dglienna]

Try to EXECUTE the query, and THEN assign it.

[dongtrien]

I try to run the EXEC good as when brought into the program will not run

[dglienna]

The QUERY doesn't run? That means it's wrong

[dongtrien]

it don't run in program C# but I did it.