hi,
I'm trying to send an ID number in page load to the stored procedure and let the stored procedure to select the correct information. When the data is successful, during page load, the fields are populated with the information. I keep getting this error message: System.InvalidOperationException: String[1]: the Size property has an invalid size of 0. Can someone please assist me? Thank you, CM
The following is my stored procedure:
USE [GAContacts]
GO
/****** Object: StoredProcedure [dbo].[searchbycompany] Script Date: 06/01/2011 15:13:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[searchbycompany]
@compnameID varchar(max),
@selectcompname varchar(MAX) = Null OUTPUT
AS
if @compnameID is NULL
Begin
Set NoCount ON
End
ELSE
Begin
Set NoCount ON
Select Business1.B_name as selectcompname From Business1 where B_ID = @compnameID
En ...
Go to the complete details ...