Hi.
problem in where insert data into table. Using vwd 2012 and Mssql 2012. Insert command is working fine in first record. If add another record, it shows "Procedure or Function has too many argument" I have tried may way, I could not solve. Pls help me. Below
is my Store Procedure, Class file and aspx.vb files.
--------------------------
Store Procedure
GO
/****** Object: StoredProcedure [dbo].[usp_CommonInfo_Insert] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[usp_CommonInfo_Insert]
@Code nvarchar(10) = NULL,
@Name nvarchar(100) = NULL,
@Type nvarchar(10) = NULL,
@BAddress nvarchar(150) = NULL,
@SAddress nvarchar(150) = NULL,
@Tel1 nvarchar(20) = NULL,
@Tel2 nvarchar(20) = NULL,
@Fax1 nvarchar(20) = NULL,
@Fax2 nvarchar(20) = NULL,
@Email nvarchar(30) = NULL,
@ContactName nvarchar(30) = NULL,
@ContactTel nvarchar(20) = NULL,
@BusinessNature nv ...
Go to the complete details ...