OK I am supplying my code with stored proc here: My stored proc: USE [UniqueCorp] GO /****** Object: StoredProcedure [dbo].[uspUpdateUser_Step2] Script Date: 06/05/2012 12:12:38 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[uspUpdateUser_Step2] @userID uniqueidentifier, @Username nvarchar(50), @CompanyName nvarchar(50), @Address nvarchar(100), @Country nvarchar(50), @State nvarchar(50) = '', @City nvarchar(50) = '', @MobileNo nvarchar(50) = '', @TelephoneNo nvarchar(50) = '', @Password nvarchar(50) AS set nocount on; IF Exists (SELECT [ID] FROM dbo.Users WHERE [ID] = @userID) begin update dbo.Users set UserName=@Username, CompanyName=@CompanyName, [Address]=@Address, Country=@Country, [State]=@State, City=@City, Mobileno=@MobileNo, TelephoneNo=@TelephoneNo, Password=@Password WHERE [ID] = @userID end GO and the code behind is this....... public static int AddUpdateUser(Users user) { SqlParameter prmUserId = new SqlParameter("@userID", SqlDbType.UniqueIdentifier); prmUserId.Value = user.ID; SqlParameter prmUsername = new SqlParameter("@Username", SqlDbType.NVarChar, 50); prmUsername.Value = user.UserName; SqlParameter prmCompanyName = new SqlParameter("@CompanyName", SqlDbType.NVarChar, 50); prmUsername.Value = user.CompanyName; SqlParameter prmAddress = new SqlParameter("@Address", SqlDbType.NVarChar, 100); prmUsername.Value = user.Address; SqlParameter prmCountry = new SqlParameter("@Country", SqlDbType.NVarChar, 50); prmUsername.Value = user.Country; SqlParameter prmState = new SqlParameter("@State", SqlDbType.NVarChar, 50); prmUsername.Value = user.State; SqlParameter prmCity = new SqlParameter("@City", SqlDbType.NVarChar, 50); prmUsername.Value = user.City; SqlParameter prmMobileNo = new SqlParameter("@MobileNo", SqlDbType.Int, 50); prmUsername.Value = user.MobileNo; SqlParameter prmTelephoneNo = new SqlParameter("@TelephoneNo", SqlDbType.Int, 50); prmUsername.Value = user.TelephoneNo; SqlParameter prmPassword = new SqlParameter("@Password", SqlDbType.NVarChar, 50); prmUsername.Value = user.Password; return DataAccessObject.Execute("uspUpdateUser_Step2",prmUserId, prmUsername, prmCompanyName, prmAddress, prmCountry, prmState, prmCity, prmMobileNo, prmTelephoneNo,prmPassword); } Please help me the problem is still there... Procedure or function expects parameter @Username That was not supplied..... But i debug and confirm dat value is

OK I am supplying my code with stored proc here: My stored proc: USE [UniqueCorp] GO /****** Object: StoredProcedure [dbo].[uspUpdateUser_Step2] Script Date: 06/05/2012 12:12:38 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[uspUpdateUser_Step2] @userID uniqueidentifier, @Username nvarchar(50), @CompanyName nvarchar(50), @Address nvarchar(100), @Country nvarchar(50), @State nvarchar(50) = '', @City nvarchar(50) = '', @MobileNo nvarchar(50) = '', @TelephoneNo nvarchar(50) = '', @Password nvarchar(50) AS set nocount on; IF Exists (SELECT [ID] FROM dbo.Users WHERE [ID] = @userID) begin update dbo.Users set UserName=@Username, CompanyName=@CompanyName, [Address]=@Address, Country=@Country, [State]=@State, City=@City, Mobileno=@MobileNo, TelephoneNo=@TelephoneNo, Password=@Password WHERE [ID] = @userID end GO and the code behind is this....... public static int AddUpdateUser(Users user) { SqlParameter prmUserId = new SqlParameter("@userID", SqlDbType.UniqueIdentifier); prmUserId.Value = user.ID; SqlParameter prmUsername = new SqlParameter("@Username", SqlDbType.NVarChar, 50); prmUsername.Value = user.UserName; SqlParameter prmCompanyName = new SqlParameter("@CompanyName", SqlDbType.NVarChar, 50); prmUsername.Value = user.CompanyName; SqlParameter prmAddress = new SqlParameter("@Address", SqlDbType.NVarChar, 100); prmUsername.Value = user.Address; SqlParameter prmCountry = new SqlParameter("@Country", SqlDbType.NVarChar, 50); prmUsername.Value = user.Country; SqlParameter prmState = new SqlParameter("@State", SqlDbType.NVarChar, 50); prmUsername.Value = user.State; SqlParameter prmCity = new SqlParameter("@City", SqlDbType.NVarChar, 50); prmUsername.Value = user.City; SqlParameter prmMobileNo = new SqlParameter("@MobileNo", SqlDbType.Int, 50); prmUsername.Value = user.MobileNo; SqlParameter prmTelephoneNo = new SqlParameter("@TelephoneNo", SqlDbType.Int, 50); prmUsername.Value = user.TelephoneNo; SqlParameter prmPassword = new SqlParameter("@Password", SqlDbType.NVarChar, 50); prmUsername.Value = user.Password; return DataAccessObject.Execute("uspUpdateUser_Step2",prmUserId, prmUsername

Procedure or function expects parameter that was not supplied why it arise and if arise how to resolve it