Search Record functionality using ajax is not working?

rahul patil

6y1.2k.NET

I m working with ajax.

I want to search the record but my ajax call logic is wrong??

I fetch the record from the database using ajax successfully but search functionality using ajax but I think my ajax call is wrong?

Database field:

table name: tblstud

studid int pk auto increment,

studname varchar(50),

studaddress varchar(50),

procedure for getdatalist:

ALTER PROCEDURE [dbo].[selectstud]

BEGIN

select * from tblstud;

END

Emploee.aspx

"form1" runat="server">

StudentName:	"txtname" runat="server">
StudentAddress:	"txtaddress" runat="server">
"button" id="btnsave" value="Submit" onclick="saverecord()" />
Search Record: "txtsearch" runat="server"> "btnsearch" type="button" value="Search" onclick="searchrecord()" />

class="row">

"tbl" border="1">

StudentName

StudentAddress

Edit

"text/javascript">

$(document).ready(function () {

GetData();

});

function searchrecord(studname) { //here is an problem with search record??

if ($("#btnsearch").val() == "Search") {

debugger

$.ajax({

type: "POST",

url: "Emploee.aspx/search",

data: "{ studname:'" + $("#txtsearch").val() + "' }",

contentType: "application/json",

success: function (data) {

debugger

$("#txtsearch").val(data.d);

});

}

//for getdatalist

function GetData() {

$.ajax({

url: 'Emploee.aspx/GetData',

type: 'post',

contentType: 'application/json;charset=utf-8',

datatype: 'json',

success: function (data) {

data = JSON.parse(data.d);

$.each(data, function (index, element) {

$("#tbl").append('' + element.studname + '');

$("#tbl").append('' + element.studaddress + '');

});

error: function (error) {

alert('Not Get Data')

});

}

Emploee.aspx.cs

[WebMethod] //for retrieve the data
public static string GetData()
{
cn.Open();
string data = "";
SqlCommand cmd = new SqlCommand("selectstud", cn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
data = JsonConvert.SerializeObject(ds.Tables[0]);
}
cn.Close();
return data;
}
[WebMethod]
public static void search(string studname)
{
cn.Open();
SqlCommand cmd = new SqlCommand("SELECT studname FROM tblstud WHERE studname LIKE '%'+@studname+'%'", cn);
cmd.Parameters.AddWithValue("@studname", studname);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Console.WriteLine("{1}",reader.GetString(1));
}
}
else
{
Console.WriteLine("No rows found.");
}
reader.Close();
}

see my browser log which place I m going to wrong?

which place I m not correct?help?

19 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajeesh Menoth6y ago
Hi,

Yes, you need to handle one extra check box for validating active and invalid user , for example before searching you can check or unchecked the check box so based on that the search result will be displayed. The value of the check box you must pass in your sql query then only you can filter out the result.
rahul patil6y ago
ok but

it is valid or not I directly use the textbox value? and compare with data?
if (data == "#txtsearch")
Rajeesh Menoth6y ago
Hi Rahul,

The true and false you can setup in your table ( Add new column and type will "bit" ) that you have using for the searching purpose. probably you can pass one flag either true or false so then you can listed the respective result.

Eg :
SELECT studname FROM tblstud WHERE studname LIKE @studname and active=@flagTrueOrFalse
rahul patil6y ago
@Jignesh Kumar and Rajeesh Menoth I m very near to solve this problem but one logic is remaining when I search true record then get the true record and when I search false record then get the false record means whatever I search then get the record. I want the when the user searches true record then gets the true record and when the user searches a false record then display the alert message(record incorrect enter) box?

my if-else condition not work?

see my updated code:
function searchrecord() {

                $('#btnsearch').click(function () {

                    $.ajax({

                        url: "WebForm1.aspx/search",

                        type: 'post',

                        contentType: 'application/json;charset=utf-8',

                        datatype: 'json',

                        data: "{ studname:'" + $("#txtsearch").val() + "' }",

                        success: function (data) {



// here mylogic is wrong --------

                            if (data == "#txtsearch") //if(search record is true then going inside)

                            {

                                txt = "" + data.d + "";

                                $("#tbl").append(txt);

                                alert("it is proper record");

                            }

                            else if (data.studname != "#txtsearch") { //elseif(search record not found then going inside)

                                alert("please enter proper record");

                            }



                        },

                    });

                });

            }
[WebMethod]

        public static string search(string studname)

        {

            string data = "";

            SqlConnection con = new SqlConnection(cn);



            SqlCommand cmd = new SqlCommand("SELECT studname FROM tblstud WHERE studname LIKE @studname", con);

            con.Open();



            cmd.Parameters.AddWithValue("@studname", "%" + studname + "%");



            SqlDataReader reader = cmd.ExecuteReader();



            if (reader.HasRows)

            {

                while (reader.Read())

                {

                    studname = reader[0].ToString();

                }

            }

            else

            {

                Console.WriteLine("No rows found.");

            }



            reader.Close();

            data = studname;

            return data;

        }
Jignesh Kumar6y ago
Hi Rahul patil,

there is problem with your select statement because you have just selected studname in your select statement and your are trying to bind address aslo in your table. You need to get address in your select statement as well
rahul patil6y ago
2 change but not work see console log:
function searchrecord() {



                $('#btnsearch').click(function () {

                    alert("submit handler has fired");

                    $.ajax({

                        url: "WebForm1.aspx/search",

                        type: 'post',

                        contentType: 'application/json;charset=utf-8',

                        datatype: 'json',

                        data: "{ studname:'" + $("#txtsearch").val() + "' }",

                        success: function (data) {



                            data = JSON.parse(data.d);

                            var len = data.length;

                            var txt = "";

                            if (len > 0) {

                                for (var i = 0; i < len; i++) {



                                    txt = "" + data[i].studname + "";

                                    $("#tbl").append(txt);

                                }

                            }

                        },

                    });

                });

            }

my search method retun the search recorcd console log:

Headers : Status Code: 200 RequestPayload { studname:'suraj' }

preview: {d: "suraj"} d: "suraj"

Response : {"d":"suraj"}
"btnsearch" type="button" value="Search" onclick="searchrecord(event )" />
Rajeesh Menoth6y ago
Hi,

The paramater is not required in the function because already you have bind the value with the help textbox value.

Reference :

https://www.c-sharpcorner.com/UploadFile/2a6dc5/auto-save-using-Asp-Net-and-ajax/
Jignesh Kumar6y ago
Hi Rahul,

Please change here and refer below link,
"btnsearch" type="button" value="Search" onclick="searchrecord(event)" />
https://www.dotnetodyssey.com/2015/01/02/calling-asp-net-code-behind-using-jquery-ajax-simple-complete-example/
rahul patil6y ago
admin close this thread because not get any result not solve question?
rahul patil6y ago
I think json position not proper:
still not get searchable record when searching the record?

Uncaught SyntaxError: Unexpected token s in JSON at position 0
at JSON.parse ()
Piyush Pansuriya6y ago
Use single Quote in sql query '%"+studname +"%'
rahul patil6y ago
System.Data.SqlClient.SqlException: 'Incorrect syntax near 'suraj'.'
SqlCommand cmd = new SqlCommand("SELECT studname FROM tblstud WHERE studname LIKE %" + studname + "%", con);

con.Open();

cmd.Parameters.AddWithValue("@studname", studname );

SqlDataReader reader = cmd.ExecuteReader(); //here give an error:
System.Data.SqlClient.SqlException: 'Incorrect syntax near 'suraj'.'
Piyush Pansuriya6y ago
Hi,
write this code in your ajax.
success: function (data) {
    sName = JSON.parse(data.d);
    var len = data.length;
    var txt = "";
    if (len > 0) {
        for (var i = 0; i < len; i++) {
            txt = "" + sName + "";
            $("#tbl").append(txt);
        }
    }
},
rahul patil6y ago
I m very near to solve my question and my console log return the searchable record but the problem is my searchable record is not dispaly in table?
Piyush Pansuriya6y ago
Hi,
Change in the web method.
SqlCommand cmd = new SqlCommand("SELECT studname FROM tblstud WHERE studname LIKE '%"+studname +"%'", con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
rahul patil6y ago
sorry I m frustrating but my search record did not get still I m find the issue??

2 change above code:
function searchrecord() {



               $('#btnsearch').click(function () {

                   alert("submit handler has fired");

                   $.ajax({

                       url: "WebForm1.aspx/search",

                       type: 'post',

                       contentType: 'application/json;charset=utf-8',

                       datatype: 'json',

                       data: "{ studname:'" + $("#txtsearch").val() + "' }",

                       success: function (data) {



                           data = JSON.parse(data.d);

                           var len = data.length;

                           var txt = "";

                           if (len > 0) {

                               for (var i = 0; i < len; i++) {



                                   txt = "" + data[i].studname + "";

                                   $("#tbl").append(txt);

                               }

                           }

                       },

                   });

               });

           }

[WebMethod]

       public static string search(string studname)

       {

           string data = "";

           SqlConnection con = new SqlConnection(cn);



           SqlCommand cmd = new SqlCommand("SELECT studname FROM tblstud WHERE studname LIKE @studname", con);



           con.Open();



           cmd.Parameters.AddWithValue("@studname", "%" + studname + "%");



           SqlDataReader reader = cmd.ExecuteReader();



           if (reader.HasRows)

           {

               while (reader.Read())

               {

                   studname = reader[0].ToString();

               }

           }

           else

           {

               Console.WriteLine("No rows found.");

           }



           reader.Close();

           data = studname;

           return data;

       }
see my search method retun the search recorcd console log: prview: ``` {d: "suraj"} d: "suraj" ``` and Response : ``` {"d":"suraj"} ```
Piyush Pansuriya6y ago
I am telling you, no need to pass parameter.
Use your function without parameter.
rahul patil6y ago
see my code function searchrecord(studname)

I already pass the studname
Piyush Pansuriya6y ago
Hi,
In your function you had decalre the parameter
function searchrecord(studname)
But you haven't pass the value into the parameter and used it ever.
So No need to declare parameter for that function.
Just use this only
function searchrecord()