• 1399/02/16

'ERROR incorrect syntax near the keyword 'into :

با سلام


        [HttpPost]
        [ValidateAntiForgeryToken]
        public ActionResult UsersAuthentication(Models.VerifyModel verifyModel,HttpPostedFileBase file)
        {
            string mainconn = ConfigurationManager.ConnectionStrings["My_EXchange_DBEntities"].ConnectionString;
            SqlConnection sqlconn = new SqlConnection(mainconn);
            string sqlquery = "inster into [dbo].[UsersAuthentication] (Name,UserName,NationalID,ImgBirthcertificate,MobilePhone,PhoneNumber,CreditCardNumber) Values (@Name,@UserName,@NationalID,@[ImgBirthcertificate],@MobilePhone,@PhoneNumber,@CreditCardNumber)";
            SqlCommand sqlcomm = new SqlCommand(sqlquery, sqlconn);
            sqlconn.Open();
            sqlcomm.Parameters.AddWithValue("@Name", verifyModel.Name);
            sqlcomm.Parameters.AddWithValue("@UserName", verifyModel.UserName);
            sqlcomm.Parameters.AddWithValue("@NationalID", verifyModel.NationalID);
            sqlcomm.Parameters.AddWithValue("@MobilePhone", verifyModel.MobilePhone);
            sqlcomm.Parameters.AddWithValue("@PhoneNumber", verifyModel.PhoneNumber);
            sqlcomm.Parameters.AddWithValue("@CreditCardNumber", verifyModel.CreditCardNumber);
            if (file!=null && file.ContentLength>0)
            {
                string filename = Path.GetFileName(file.FileName);
                string imgpath = Path.Combine(Server.MapPath("~/Users-Img/"), filename);
                file.SaveAs(imgpath);
            }
            sqlcomm.Parameters.AddWithValue("@ImgBirthcertificate", "~/Users-Img"+file.FileName);
            sqlcomm.ExecuteNonQuery();
            ViewData["Message"] = "User Record" + verifyModel.Name + " Is Saved Successfully !";
            return View();
        }

در این کد که برای وارد کردن تصویر و اطلاعات مشتری به دیتا بیس است ، در این خط   sqlcomm.ExecuteNonQuery()  ارور incorrect syntax near the keyword 'into میدهد ، لطفا راهنمایی کنید.

logo-enamadlogo-samandehi