Cita:
CREATE PROCEDURE sp_Relacion_ParaDatosAdicionales_Gas
@nSolicitudes Integer
as
select nSolicitudes, b.cDescripcion as NomFinanciera, c.cDescripcion as NomTalleres,
d.cDescripcion as NomTipoCredito, a.dFechaRegistro, a.cUsuarioRegistro,
e.cDescor as TipoDocumento,
a.cApePaterno, a.cApeMaterno, a.cNombres, a.cNumDocumento
from solicitudes a left outer join Financieras b
on a.nFinancieras = b.nFinancieras
left outer join Talleres c
on a.nTalleres = c.nTalleres
left outer join TipoCredito d
on a.nTipoCredito = d.nTipoCredito
left outer join TablasGenerales e
on a.nTipoDocumento = convert(numeric,e.cCodtab)
where e.nDigide = 3
And a.nSolicitudes = @nSolicitudes
GO
@nSolicitudes Integer
as
select nSolicitudes, b.cDescripcion as NomFinanciera, c.cDescripcion as NomTalleres,
d.cDescripcion as NomTipoCredito, a.dFechaRegistro, a.cUsuarioRegistro,
e.cDescor as TipoDocumento,
a.cApePaterno, a.cApeMaterno, a.cNombres, a.cNumDocumento
from solicitudes a left outer join Financieras b
on a.nFinancieras = b.nFinancieras
left outer join Talleres c
on a.nTalleres = c.nTalleres
left outer join TipoCredito d
on a.nTipoCredito = d.nTipoCredito
left outer join TablasGenerales e
on a.nTipoDocumento = convert(numeric,e.cCodtab)
where e.nDigide = 3
And a.nSolicitudes = @nSolicitudes
GO
tengo este store procedure y ya logre mi conexion sin problema de desd mi codigo
Cita:
lo q m gustaria es como poder recuperar los parametros en 1 label o txt de preferencia en 1 label Dim conexionesglo As SqlConnection = New SqlConnection("Data Source=(local); Initial Catalog=xxxxx; user id=xx; password=xxxxx")
Dim coDetalle As New SqlCommand
coDetalle.CommandText = "sp_Relacion_ParaDatosAdicionales_Gas"
coDetalle.CommandType = CommandType.StoredProcedure
coDetalle.Connection = conexionesglo
Dim coDetalle As New SqlCommand
coDetalle.CommandText = "sp_Relacion_ParaDatosAdicionales_Gas"
coDetalle.CommandType = CommandType.StoredProcedure
coDetalle.Connection = conexionesglo
