如何使用jquery将数据插入SQL数据库。 [英] How to insert data into SQL database using jquery.

问题描述

我正在尝试使用jQuery将数据插入数据库但数据未插入。它显示警告为错误。任何人都可以帮我这个。



< b>我尝试了什么：



cs：

I am trying to insert data into database using jQuery but data is not inserting.It is displaying alert as error.Can anyone help me with this.

What I have tried:

cs:

[WebMethod]
   public static void insertion(string Title,string Description,string Category,string Priority,string Attachment)
   {
       using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["msgscon"].ConnectionString))
       {
           using (SqlCommand cmd = new SqlCommand("INSERTMD", con))
           {
               cmd.CommandType = CommandType.StoredProcedure;
               cmd.Parameters.AddWithValue("@MD_TITLE", Title);
               cmd.Parameters.AddWithValue("@MD_DESC", Description);
               cmd.Parameters.AddWithValue("@MD_CAT_ID", Category);
               cmd.Parameters.AddWithValue("@MD_P_ID", Priority);
               cmd.Parameters.AddWithValue("@MD_ATTACHMENT", Attachment);
               con.Open();
               cmd.ExecuteNonQuery();
               con.Close();
           }
       }
   }

ASPX：

ASPX:

$('#btn_savemd').click(function () {
               var title = $('#tb_title').val();
               var cat = $('#DDL_cat option:selected').index();
               var prior = $('#DDL_prior option:selected').index();
               var desc = $('#tb_desc').val();
               var attach = $('#FileUpload1').val();
               var strfields = ''; var missfields = ''; var i = 0;
               if (title == '') {
                   missfields = true;
                   i = i + 1;
                   strfields += i + " Please enter  Title \n";
               }
               if (cat == 0) {
                   missfields = true;
                   i = i + 1;
                   strfields += i + " Please select Category \n";
               }
               if (prior == 0) {
                   missfields = true;
                   i = i + 1;
                   strfields += i + " Please select Priority \n";
               }
               if (desc == '') {
                   missfields = true;
                   i = i + 1;
                   strfields += i + " Please enter Description \n";
               }

               if (attach == '') {
                   missfields = true;
                   i = i + 1;
                   strfields += i + " Please select Attachment \n";
               }
               if (missfields) {
                   alert('Please fill following details \n' + strfields);
                   return false;
               }
               var data = { Title: title, Description: desc, Category: cat Priority: prior, Attachment: attach };
               $.ajax({
                   type: "POST",
                   contentType: "application/json; charset=utf-8",
                   url: "jQueryMsgs.aspx/insertion",
                   data: '{' + JSON.stringify(data) + '}',
                   dataType: "json",
                   success: function () {
                           alert('Message Details Added Successfully');
                   },
                   error: function () {
                       alert('Error');
                   }
               });
           });

推荐答案

（'＃btn_savemd'）。click（function（）{
var title =

('#btn_savemd').click(function () { var title =

（'＃tb_title'）。val（）;
var cat =

('#tb_title').val(); var cat =

（'＃DDL_cat option：selected'）。index（ ）;
var prior =

('#DDL_cat option:selected').index(); var prior =

这篇关于如何使用jquery将数据插入SQL数据库。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！