Posted on: 4/7/2011 7:29:18 AM | Views : 414

Hi all
how to display pop up message when data not found in database?
I have  TextBox1 for user type word and button for search search, textbox2,3 & 4 for output. Code in C#.
Below is my code;;;
namespace KIO.BM { public partial class Kamus : System.Web.UI.Page { private DataTable GetData(string translateWord) { String connectionString = ConfigurationManager.ConnectionStrings["kamusConnectionString"].ConnectionString; SqlConnection conn = new SqlConnection(connectionString); DataTable dt = new DataTable(); try { conn.Open(); String sql = "SELECT translateWord, definitionBm, definitionBi FROM dataTable WHERE originalWord = @originalWord"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@originalWord", translateWord); ...

Go to the complete details ...