How to show message box if no matching word is search.

Question

0.00/5 (No votes)

See more:

Hello guys i created an search and i want to have an popup message that will tell the user like "no records found" if the user search word doesn't exist record. heres my code for searching. btw guys this is asp vb

What I have tried:

Dim searchword As String
searchword = "select * from tblstudinfo where (studentid like '%" + searchtxt.Text.ToString() )"
SqlDataSource1.SelectCommand = searchword

Posted 28-Dec-16 4:28am

Member 12919944

Updated 28-Dec-16 5:02am

Add a Solution

Comments

[no name] 28-Dec-16 10:38am

Okay and so what is your question?

Member 12919944 28-Dec-16 10:55am

that my question sir . how ti create a popup window like or error message ?

[no name] 28-Dec-16 12:06pm

Nowhere in your posting is a question. You would create a popup window by using jquery.

Member 12919944 28-Dec-16 21:41pm

what plugins of jquery isi it ?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Peter Leow · Answer 1 · 2016-12-28T05:02:00

Solution 1

Make use of SqlDataSource.Selected Event[^] and one of its arguments SqlDataSourceStatusEventArgs[^] such like:

VB.NET

Protected Sub SqlDataSource1_Selected(ByVal sender As Object, ByVal e As SqlDataSourceStatusEventArgs)

  If e.AffectedRows = 0 Then

     Response.Write("<script language=""javascript""> alert('No match records.');</script>")

  End If

End Sub

Last but not least, you should learn Using Parameters with the SqlDataSource Control[^] instead of injecting parameters into the sql statement directly owing to potential risks posed by SQL injection.[^]

Posted 28-Dec-16 5:02am

Peter Leow

Updated 28-Dec-16 7:38am

v9

Comments

Member 12919944 28-Dec-16 11:16am

selecting or selected ?

Protected Sub SqlDataSource1_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles SqlDataSource1.Selecting

End Sub

Peter Leow 28-Dec-16 11:21am

The link will tell.

Peter Leow 28-Dec-16 13:39pm

Added the pop up message box using JavaScript alert.