i am trying to save record in database but getting error
Sql Table
SELECT TOP (1000) [Id] ,[Name_Department] ,[Father_OrgName] ,[City] ,[Street] ,[Locality] ,[Pincode] ,[PlotNo] ,[District] ,[Tehsil] ,[Village] ,[Ward] ,[KhasraNo] ,[KhewetNo] ,[KhataNo] ,[Landmesure] ,[CompoundWall] ,[LandDevelopment] FROM [PDA].[dbo].[BasicDetails]
HomeController
string constr ="Data Source=DESKTOP-U788ISC\\SQLEXPRESS;Initial Catalog=PDA;Persist Security Info=True;User ID=sa;Password=sa123;MultipleActiveResultSets=True"; using (SqlConnection con = new SqlConnection(constr)) { string query = "INSERT INTO BasicDetails(Name_Department,Father_OrgName,City,Street,Locality,District,Tehsil,Village,Ward,KhasraNo,KhewetNo,KhataNo,Landmesure,CompoundWall, LandDevelopment) VALUES(@Name_Department,@Father_OrgName,@City,@Street,@Locality,@District,@Tehsil,@Village,@Ward,@KhasraNo,@KhewetNo,@KhataNo,@Landmesure,@CompoundWall,@LandDevelopment)"; query += " SELECT SCOPE_IDENTITY()"; using (SqlCommand cmd = new SqlCommand(query)) { cmd.Connection = con; con.Open(); string Name_Department = Request.Form["Name_Department"]; string Father_OrgName = Request.Form["Father_OrgName"]; string City = Request.Form["City"]; string Street = Request.Form["Street"]; string Locality = Request.Form["Locality"]; string District = Request.Form["District"]; string Tehsil = Request.Form["Tehsil"]; string Village = Request.Form["Village"]; string Ward = Request.Form["Ward"]; string KhasraNo = Request.Form["KhasraNo"]; string KhewetNo = Request.Form["KhewetNo"]; string KhataNo = Request.Form["KhataNo"]; string Landmesure = Request.Form["Landmesure"]; string CompoundWall = Request.Form["CompoundWall"]; string LandDevelopment = Request.Form["LandDevelopment"];
cmd.ExecuteNonQuery(); con.Close(); return View(); }
Error : Must declare the scalar variable "Name_Department"