imam jednu proceduru u MS SQL 2008:
CREATE PROCEDURE dbo.izlistavanje_proizvoda
AS
/*SET NOCOUNT ON*/
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
declare @ID_P smallint;
declare @NAZ_P varchar(50);
declare @DAT date;
DECLARE c CURSOR for select ID_PROIZVODA, NAZIV_PROIZVODA, DATUM_KREIRANJA from PROIZVOD
open c
fetch next from c into @ID_P, @NAZ_P, @DAT;
while @@fetch_status=0
begin
fetch next from c into @ID_P, @NAZ_P, @DAT
end
close c
deallocate c
/*SET NOCOUNT OFF*/
RETURN
sada bih trebao da vratim rezultate selekt-a u dataGridView, ali ne znam kako.
Jel možepomoću DataReader-a ili već nekako