Click here to Skip to main content
15,898,374 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello My SP
SQL
ALTER PROCEDURE InsertData
	(
		@firstName varchar(50),
		@lastName varchar(50),
		@year varchar(50),
		@school varchar(50),
		@city varchar(50),
		@state varchar(50),
		@country varchar(50),
		@e_mail varchar(50),
		@mobile varchar(50)
	)
AS
	/* SET NOCOUNT ON */ 
	DECLARE @Count int
	select @Count = Count(PersonID) from Person WHERE Mobile = @mobile
	
	IF @Count = 0 
		BEGIN
				INSERT INTO Person (FirstName, LastName, Year1,School,City,State,Country,E_mail,Mobile) 
				VALUES 
				(@firstName, @lastName,@year,@school,@city,@state,@country,@e_mail,@mobile)
		END 
		RETURN @Count
	RETURN


My DAL.cs file
C#
public int Insert(Person person)
   {
       SqlConnection conn = new SqlConnection(connStr);
       conn.Open();
       SqlCommand dCmd = new SqlCommand("InsertData", conn);
       dCmd.CommandType = CommandType.StoredProcedure;
       try
       {

          // dCmd.Parameters.AddWithValue("@firstName", person.FirstName);
           dCmd.Parameters.AddWithValue("@firstName", person.FirstName);
           dCmd.Parameters.AddWithValue("@lastName", person.LastName);
           dCmd.Parameters.AddWithValue("@year", person.Year1);
           dCmd.Parameters.AddWithValue("@school", person.School);
           dCmd.Parameters.AddWithValue("@city", person.City);
           dCmd.Parameters.AddWithValue("@state", person.State);
           dCmd.Parameters.AddWithValue("@country", person.Country);
           dCmd.Parameters.AddWithValue("@e_mail", person.E_mail);
           dCmd.Parameters.AddWithValue("@mobile", person.Mobile);

           return dCmd.ExecuteNonQuery();
       }
       catch
       {
           throw;
       }
       finally
       {
           dCmd.Dispose();
           conn.Close();
           conn.Dispose();
       }
   }


Can any one tell me the Solution?
Posted
Comments
Kornfeld Eliyahu Peter 5-Jan-14 14:59pm    
Try to remove this: RETURN @Count

Change your SP in that way:
SQL
ALTER PROCEDURE InsertData
	(
		@firstName varchar(50),
		@lastName varchar(50),
		@year varchar(50),
		@school varchar(50),
		@city varchar(50),
		@state varchar(50),
		@country varchar(50),
		@e_mail varchar(50),
		@mobile varchar(50)
	)
AS
BEGIN
	IF EXISTS(SELECT PersonID FROM Person WHERE Mobile = @mobile)
            BEGIN
                --select PersonId
		SELECT PersonID FROM Person WHERE Mobile = @mobile
            END
	ELSE
            BEGIN
		INSERT INTO Person (FirstName, LastName, Year1,School,City,State,Country,E_mail,Mobile) VALUES (@firstName, @lastName,@year,@school,@city,@state,@country,@e_mail,@mobile)
                --return new PersonID
	        RETURN @@IDENTITY
	    END 
END
 
Share this answer
 
v2
Comments
Pankil_Plus 6-Jan-14 4:14am    
Now I am getting error " Could not load type 'WebApplication4.Global'"
Hello

Finally I got Solution of this Problem, I am using web Application Project, So there is no App_Code Foder,

Quote:
, for Web App Projects, you should instead Add a folder called something like 'CodeFolder' and then add you class in there. Then right click properties on that class file and set its build config to compile rather than content.


I did this & Get answer of my problem.

http://stackoverflow.com/questions/2277742/app-code-folder-is-missing-in-vs-2010[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900