Click here to Skip to main content
15,920,896 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
I am saving text into database using Jquery ajax call by pressing of enter key. When I pressing enter key then, I have a button on master page it is redirecting to that button URL (In ASP.NET)

What I have tried:

I already apply below method but ajax success part is not working,



*HTML Code-----
ASP.NET
<asp:Panel ID="panSearch" runat="server" DefaultButton="btnTemp" Width="100%">
<asp:Button ID="btnTemp" style="display:none;" runat="server" />
<input type="text" id="commentText<%# ((RepeaterItem)Container).ItemIndex + 1%>" class="form-control" placeholder="Your Comment" />


*AJAX Code-----
JavaScript
function SaveComment(e, cmntValue, UserId) {
            //console.log(e.keyCode);
            //console.log(e.which);
            //console.log(cmntValue);
            var code = e.keyCode ? e.keyCode : e.which;
            if (code === 13) {
                var commentId = "#" + cmntValue.id;
                var loginId = $('#ContentPlaceHolder1_sessionVal').val();
                var username = $('#ContentPlaceHolder1_activeUser').val();

                var obj = {};
                obj.comment = $.trim($(commentId).val());
                obj.userid = UserId;
                obj.username = username;
                obj.loginId = loginId;

                console.log(obj.comment);
                console.log(obj.userid);
                console.log(obj.loginId);
                console.log(obj.username);

                if (obj.comment != '' && obj.userid != '' && obj.username != '' && obj.UserId != '') {
                    $.ajax({
                        type: "post",
                        url: "News.aspx/insertData",
                        data: JSON.stringify(obj),
                        contentType: "application/json; charset=utf-8",
                        dataType: "json",
                        success: function (data) {
                            console.log(data.d);
                            $(commentId).val("");
                            alert(0);
                            window.location.reload();
                            alert(1);
                            //var countComment = '#C' + cmntValue.id;
                            //var val = data.commentCount;
                            //$(countComment).html('Comments (' + val + ')');                            
                        },
                        error: function (result) {
                            alert("Error");
                        }
                    });
                }
            }
        }


*aspx.cs Code-----
C#
public static string insertData(string userid, string username, string comment, string loginId)//
    {
        string userImage = "images/avatar5.png";
        var commentCount = "";
        // int username = Convert.ToInt32(SqlHelper.ExecuteScalar(Connection.Getconstring(), CommandType.Text, "select FirstName from Regconvask where UserId='" + + "'"));
        SqlCommand cmddd;
        String strConnString = System.Configuration.ConfigurationManager.ConnectionStrings["WebsiteDatabaseConnection"].ConnectionString;
        SqlConnection connectify = new SqlConnection(strConnString);


        SqlCommand cmd1 = new SqlCommand("SELECT FilePath FROM imageconnect WHERE UserId = '" + Convert.ToInt32(loginId) + "' ", connectify);

        SqlDataReader CommentImage = null;
        connectify.Open();
        CommentImage = cmd1.ExecuteReader();
        if (CommentImage.HasRows)
        {
            while (CommentImage.Read())
            {
                userImage = CommentImage["FilePath"].ToString();
            }
        }
        else
        {
            userImage = "images/avatar5.png";
        }
        connectify.Close();

        cmddd = new SqlCommand("insert into commentnews (userid,username,comment,timeago,userImage)" + " values(@userid,@username,@comment,@timeago,@userImage)", connectify);
        cmddd.Parameters.AddWithValue("@userid", userid);
        cmddd.Parameters.AddWithValue("@username", username);
        cmddd.Parameters.AddWithValue("@comment", comment);
        cmddd.Parameters.AddWithValue("@timeago", DateTime.Now);
        cmddd.Parameters.AddWithValue("@userImage", userImage);
        cmddd.CommandType = CommandType.Text;
        cmddd.Connection = connectify;
        try
        {
            connectify.Open();
            cmddd.ExecuteNonQuery();

            string query = "UPDATE newstable SET NumOfComment=(SELECT COUNT(*) FROM commentnews WHERE Userid='" + userid + "') WHERE UserId='" + userid + "'";
            SqlHelper.ExecuteDataset(Connection.Getconstring(), CommandType.Text, query);
            connectify.Close();
        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            connectify.Close();
            connectify.Dispose();
        }     
        return string.Format("userid: {0},username: {1},commentCount: {2}", userid, username, commentCount, Environment.NewLine);        
    }
Posted
Updated 20-Apr-16 3:41am
v3
Comments
ZurdoDev 19-Apr-16 8:14am    
Then post the code that isn't working and explain the problem.
Member 12003400 19-Apr-16 9:13am    
Try to set tab index properly

1 solution

Add "return false;" in the if condition where you checking the event code
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900