protected void Button2_Click(object sender, EventArgs e)
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
con.Open();
SqlCommand cmd = new SqlCommand("InsertRec", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Fname", Fname.Text);
cmd.Parameters.AddWithValue("@Lname", Lname.Text);
if (RdMale.Checked)
{
cmd.Parameters.AddWithValue("@Gender", RdMale.Text);
}
cmd.Parameters.AddWithValue("@Gender", RdFemale.Text);
cmd.Parameters.AddWithValue("@Email", Email.Text);
cmd.Parameters.AddWithValue("@Mobile", Mobile.Text);
cmd.Parameters.AddWithValue("@Address", Address.Text);
cmd.Parameters.AddWithValue("@Edu", Qualification.Text);
cmd.Parameters.AddWithValue("@Course", Course.Text);
cmd.Parameters.AddWithValue("@ClName", ClName.Text);
cmd.Parameters.AddWithValue("@UnvName", UnvName.Text);
cmd.ExecuteNonQuery();
}
}
}
}
cmd.ExecuteNonQuery();
on this line i am gettoing error.....Could not find stored procedure 'InsertRec'.
below is my Stored Procedure
CREATE PROCEDURE InsertRec@Fname varchar(50),@Lname varchar(10),@Gender varchar(5),@Email varchar(10),@Mobile nchar(10),@Address varchar(50),@Qualification varchar(15),@Course varchar(10),@College varchar(20),@University varchar(15), ASBEGIN
insert into Practice.dbo.task (Fname,Lname,Gender,Email,Mobile,Address,Qualification,Course,College,University) values (@Fname,@Lname,@Gender,@Email,@Mobile,@Address,@Qualification,@Course,@College,@University);
END