protected void ExecuteNonQuery(string sql) { SqlConnection sqlConn = new SqlConnection(); try { string connString = ConfigurationManager.ConnectionStrings["DbConnection"].ToString(); sqlConn.ConnectionString = connString; sqlConn.Open(); SqlCommand sqlCommand = new SqlCommand(sql, sqlConn); sqlCommand.ExecuteNonQuery(); } catch(Exception ex) { labelSuccess.Text = ex.Message; } finally { if(sqlConn.State == System.Data.ConnectionState.Open) { sqlConn.Close(); } } }
Last Updated on October 26, 2015