handling of databse connection

Question

i am working on asp.net +C#
my problem is that if due to any reason net connection is failed while user was entering his details.and as he clicked submit ........so how it should be handle that what ever user has entered must be saved afterward as net connection is regained
automatically!
how its hud be done automatically.

Vijaya Kadiyala · Answer

Hi Deepak, "my problem is that if due to any reason net connection is failed while user was entering his details.and as he clicked submit " Your question is at the front-end side i.e entering some detailes in the form and use hits the sunit buton and if DB connection is not available!!! You want to retain the same values in the front-end form!!! Thanks -- Vijaya Kadiyala www.dotnetvj.com

deepika agarwal · Answer

thanku Niradhip sir and abhishek sir i will try with abv code then reply you. thankyou!!

Abhishek h · Answer

i think u have to implement Transaction in your application,as suggested by Niradip.

Niradhip Chakraborty · Answer

Normal 0 false false false MicrosoftInternetExplorer4 /* 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-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:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} If the database connection goes down, say after entering into two table. What you can do is rollback the transaction. Because you don’t know how long the connection will be down. You can show a message to user as "Try after some time." Please check below the rollback code. private void updateData() { SqlConnection sqlCon = null ; sqlCon = new SqlConnection ( ConfigurationManager .AppSettings[ "ConnectionString" ].ToString()); SqlCommand sqlCmd = new SqlCommand (); SqlDataAdapter adpData = null ; SqlDataReader sdrData = null ; DataSet dstData = new DataSet (); SqlTransaction myTrans = null ; try { sqlCon.Open(); myTrans = sqlCon.BeginTransaction(); sqlCmd.Connection = sqlCon; sqlCmd.Transaction = myTrans; // =================================== All your insert statement code will come here //======================================= myTrans.Commit(); myTrans = null ; sqlCon.Close(); sqlCon = null ; sqlCmd = null ; } catch ( Exception ex) { if (myTrans != null ) { try { myTrans.Rollback(); } catch { } } if (sqlCon != null ) { if (sqlCon.State == ConnectionState .Open) { sqlCon.Close(); } sqlCon = null ; } if (sqlCmd != null ) { sqlCmd = null ; } } finally { } }

handling of databse connection

Answers (4)