It can be accomplished by using javascript's alert:
Code:
//Somewhere in your code...
Response.Write("<script langauge=\"javascript\">alert(\"Your data was inserted successfully\");</script>");