Show a Message box, whenever Data is inserted in DataBase.

Question

Hi All Show a Message box in WinForm(C#), whenever Data is inserted in DataBase from BackEnd or Front-End Thanks in Advance Anurag

Rakesh Kaushik · Answer

Please add this line right after data insertion code. MessageBox.Show("Record save successfully !");

Satyapriya Nayak · Answer

OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "insert into student(id,name) values (@id,@name)"; com = new OleDbCommand(str, con); com.Parameters.AddWithValue("@sid", textBox1.Text); com.Parameters.AddWithValue("@sname", textBox2.Text); int affectedRows = com.ExecuteNonQuery(); con.Close(); MessageBox.Show(affectedRows + ":::Records Successfuly Inserted");

Anurag Srivastava · Answer

ya thats true, when i insert the data from the front end, but whenever i insert the data from the backend using query, it will not show any popup or msg box....I want that too....Anyway Thanks for the effort...But do u have any idea for the Backend problem

Satyapriya Nayak · Answer

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 OleDbConnection con = new OleDbConnection (ConnectionString); con.Open(); str = "insert into student(id,name) values (@id,@name)" ; com = new OleDbCommand (str, con); com.Parameters.AddWithValue( "@sid" , textBox1.Text); com.Parameters.AddWithValue( "@sname" , textBox2.Text); com.ExecuteNonQuery(); con.Close(); MessageBox .Show( "Records Successfuly Inserted" ); /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin:0in;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:"Times New Roman";mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:"Times New Roman";mso-bidi-theme-font:minor-bidi;}