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(idname) 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(idname) 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:Calibrisans-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;}

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