Send to database using ASP.NET, c# and jQuery

Question

New to AJAX here. Been trying to send to my database using AJAX but is is not working. In my aspx.cs:

[WebMethod]
    public static void saveMsg(string roomCode, string userName, string msg)
    {
        using (SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["LBConnectionString"].ConnectionString))
        {
            SqlCommand cmd = con.CreateCommand();

            cmd.CommandText = "INSERT into chatTable(roomCode, uName, msg) VALUES (" + roomCode + ", '" + userName + "', + '" + msg + "')";
            cmd.Connection = con;
            con.Open();

            cmd.ExecuteNonQuery();

            con.Close();
        }
    }

I am trying to insert data using AJAX and C# ASP.NET. This is my aspx file

$.ajax({
                    type:'POST',
                    contectType: "application/json; charset=utf-8",
                    dataType: "json",
                    url:"Room.aspx?Board='" + roomCode + "'",
                    data: "{'roomCode':'" + roomCode + "','uName':'" + userName + "','msg':'" + <%=message.ClientID %> + "'}",
                })

The full url is http://localhost:1759/Room?Board='//roomcode'.

Is there anything that went wrong? Like how I put the url into the AJAX function? Thanks in advance!

EDIT: Is it needed to put data type as JSON? New to JSON too...

you shouldn't concatenate string while passing parameters. For example, data: { roomCode: roomCode, uName: userName, msg: message.ClientID }. Read similar question http://stackoverflow.com/questions/1916309/pass-multiple-parameters-to-jquery-ajax-call — kashi_rock, Aug 01 '16 at 11:43
@kashi_rock but my data need user input can just put like tat? sorry new here... :) — Centrifudge, Aug 01 '16 at 11:45
Please take a look here [http://stackoverflow.com/questions/7081054/calling-a-function-database-update-using-ajax-via-jquery/40427446#40427446](http://stackoverflow.com/questions/7081054/calling-a-function-database-update-using-ajax-via-jquery/40427446#40427446) for a similar question if it helps.. — Jeff D, Nov 04 '16 at 16:29

score 1 · Accepted Answer · answered Aug 01 '16 at 11:48

1

Try this code :

Javascript :

function Getpath() {
if (!window.location.origin) {
    window.location.origin = window.location.protocol + "//" + window.location.hostname + (window.location.port ? ':' + window.location.port : '');
}
var Domainpath = window.location.origin + "/";
if (Domainpath.indexOf("localhost") == -1) {
    return Domainpath;
}
else {
    return Domainpath;
}
}

Ajax:

You will get the path in Getpath() Method.

var path = Getpath();
$.ajax({
                type:'POST',
                contectType: "application/json; charset=utf-8",
                dataType: "json",
                url: path +"Room.aspx?Board='" + roomCode + "'",
                data: "{'roomCode':'" + roomCode + "','uName':'" + userName + "','msg':'" + <%=message.ClientID %> + "'}",
            })

answered Aug 01 '16 at 11:48

Rajeesh Menoth

1,704
3
17
33

It's not working.. but anyway I'm using signalr together with ajax is it fine? – Centrifudge Aug 01 '16 at 11:58
@Zoey Debug ur code then you will get the exact issue and also check url . – Rajeesh Menoth Aug 01 '16 at 12:13
Try it..!! Welcome :) – Rajeesh Menoth Aug 01 '16 at 12:20
@Zoey The answer is helpful. then please accept it..!! – Rajeesh Menoth Aug 01 '16 at 12:26

score -1 · Answer 2 · answered Aug 17 '16 at 11:35

-1

You Need to Pass correct URL to call method.

$.ajax({
       type:'POST',
       contectType: "application/json; charset=utf-8",
       dataType: "json",
       url:"Room.aspx/saveMsg",
       data: "{'roomCode':'" + roomCode + "','uName':'" + userName + "','msg':'" + <%=message.ClientID %> + "'}",
   })

answered Aug 17 '16 at 11:35

DBB

137
1
4

Thank you for your help! :)) – Centrifudge Oct 25 '16 at 02:45
Based on @zoey problem he want to put url in ajax function. In your solution you just accessing the webmethod without passing url. – Rajeesh Menoth Oct 25 '16 at 04:16

Send to database using ASP.NET, c# and jQuery

2 Answers2