REcord is not inserting as supplies

umair mohsin

9y893.NET

here is my stored procedure

CREATE PROCEDURE [dbo].[InsertRecord]

-- Add the parameters for the stored procedure here

@name varchar,

@gender varchar

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

-- Insert statements for procedure here

insert into Test values('@name','@gender');

END

here is my code behind

string constr = ConfigurationManager.ConnectionStrings["JPConstr"].ConnectionString.ToString();

SqlConnection conn = new SqlConnection(constr);

conn.Open();

SqlCommand cmd = new SqlCommand("InsertRecord", conn);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@name",TextBox1.Text);

cmd.Parameters.AddWithValue("@gender",TextBox2.Text);

cmd.ExecuteNonQuery();

Label2.Text = "Record inserted";

conn.Close();

record inserted in database like this

name=@name

gender=@gender

what is the problem with my code can anyone please tell

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhinav Abhishek9y ago
Accepted answer
please remove quotes from the insert statement in procedure like this

insert into Test values(@name,@gender);
Khaja Moizuddin9y ago
May be problem with this line
insert into Test values('@name','@gender');
check this

CREATE PROCEDURE [dbo].[InsertRecord]
-- Add the parameters for the stored procedure here
@name Varchar (50),
@gender Varchar (50),
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
Insert into Test(name,gender) values (@name,@gender)
END
As you are directly passing @name & @gender into insert statement , you can rename your procedure like above one.