[ brenas @ 07.10.2011. 17:12 ] @
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 |