Help me.
I have Gridweb that bind with a table got of the next store procedure
ALTER PROCEDURE [QUERIES].[spUploadSpecif_GetSpecificationsStatus]
@specification nvarchar(4000) = null,
@product nvarchar(50) = null,
@side int
AS
BEGIN
SET NOCOUNT ON;
declare @XmlHandle int
declare @outSpecificationID int
EXEC sp_xml_preparedocument @XmlHandle output, @specification
SELECT IDENTITY(int, 1,1) as id, *
INTO #specification
FROM OPENXML (@XmlHandle, '/root/SPEC',1)
WITH (E nvarchar(10), D float, T float,M float,C float,P nvarchar(50),R nvarchar(10),S nvarchar (10))
select s.E, s.D as Diam, s.T as Thick, s.M as Mand, s.C as Coup, s.P as Plano, s.R as Rev, s.S as Subn ,case when (select count(*) from EPREMIUM.ESPECIFICACIONES SP
where SP.DIAMETRO = s.D and SP.ESPESOR = s.T and SP.MANDRIL = s.M and SP.DIAM_EXT_COPLE = s.C and SP.PRODUCTO=@product and SP.CVE_LADO=@side )> 0 then cast('True' as bit) else cast('False' as bit) end as [Exists], e.MATRICULA1 as Firma1, e.MATRICULA2 as Firma2, case when (select count(*) from EPREMIUM.ESPECIFICACIONES SP
where SP.DIAMETRO = s.D and SP.ESPESOR = s.T and SP.MANDRIL = s.M and SP.DIAM_EXT_COPLE = s.C and SP.PRODUCTO=@product and SP.CVE_LADO=@side )> 0 then cast('False' as bit) else cast('True' as bit) end as [Pasar]
into #tmp
from EPREMIUM.ESPECIFICACIONES E right join #specification s
on E.DIAMETRO = s.D and E.ESPESOR = s.T and E.MANDRIL = s.M and E.DIAM_EXT_COPLE = s.C and E.PRODUCTO = @product and E.CVE_LADO = @side
group by id, s.E, s.D , s.T , s.M, s.C ,s.P, s.R, s.S,e.MATRICULA1, e.MATRICULA2
order by id
select * from #tmp
END
in the "Pasar" column your value is showed with a check box, this value may be modified by the user, but when is checked/uncheked by the user and the values of the gridweb are readed to set in the database, the screen show me the next error:
System.nullreferenceException: Reference to object not established like instance of an object
Thanks by your help