Login or Register to Ask a Question and Join Our Community


MySQL DevZone RSS

Exception Error Handling Implementation in MySQL/VB.NET Windows Database Applications

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Web Development MySQL DevZone RSS Exception Error Handling Implementation in MySQL/VB.NET Windows Database Applications
# 1  
Old 02-10-2009
Exception Error Handling Implementation in MySQL/VB.NET Windows Database Applications
Error handling implementation in Windows database applications is a must for any Application Developer today. The main idea of error handling is to avoid application crashes by finding out the occurred errors and fixing them. Different programming languages have different ways of implementing error handling. Microsoft Visual Basic .NET (VB.NET) is the most common programming language for developing windows database applications today. VB.NET codes are provided in many websites, books and materials without error handling implementation. In this article I would like to introduce you to the basics of error handling implementation in MySQL/VB.NET windows database applications. I'll be covering structured exception error handling, which was introduced for the first time in VB.NET 2002. I will also go over the latest technologies of disposing unmanaged recourses in .NET Framework with the Using statement. To write exception errors to a log text file, a generic procedure will be developed while MySQL data is loading, inserting, updating and deleting.

More...
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. Programming

Exception Handling C++

Hello All, I have a question ....which I am totally confused about! If I have a fxn foo in a program which returns a logical value. But it has a posssiblity to throw some exception. Now my exception handler returns a value as a string stating why the exception occured. But my... (1 Reply)
Discussion started by: mind@work
1 Replies

2. Shell Programming and Scripting

Exception handling

Sometimes when I try to use curl to upload to an ftp server, I get the message: $curl -T file.wmv ftp.eu.filesonic.com --user user:password curl: (8) Got a 421 ftp-server response when 220 was expected How do I get the script to try again if I get the message curl: (8)? (2 Replies)
Discussion started by: locoroco
2 Replies

3. Programming

Advanced Exception Handling in C++

Hi Friend, Could you please provide me with some tutorial for Advanced Exception handling in C++, mainly set_terminate() and set_unexpected() functions? Please find the details below: OS: Unix Compiler: gcc. Thanks. :) Awesome001 (0 Replies)
Discussion started by: awesome001
0 Replies

4. Shell Programming and Scripting

Exception Handling

Hi, I have written a script to load csv files into a mysql database, however, i would like for the shell script to exit in the event of an error (missing file, load error etc.) - currently if an error is encountered the next statement is processed - This is how i am loading the csv scripts ... (5 Replies)
Discussion started by: bertpereira
5 Replies

5. Shell Programming and Scripting

Exception-handling in Shell programs

Hi all, I am writing a set of scripts and some of these are nested within others. I want to be able to execute a single high-level script at the command-line, which in turn may invoke other scripts as required, and when a failure occurs in any of the nested scripts, I want to be able to track... (2 Replies)
Discussion started by: chaitu_inmage
2 Replies

6. Programming

Linux g++ 2.95.3 exception handling

Anybody happen to be familiar with any deficiencies with g++ 2.95.3 regarding exception handling, specifically in multi-threaded / multi-module (shared library) based applications? I'm seeing behavior where thrown exceptions are not caught, but basically ignored causing the application to... (0 Replies)
Discussion started by: earl
0 Replies

7. UNIX for Advanced & Expert Users

exception handling

Does exception handling exist in any UNIX enviornment? I develop on Windows MSVC++ land and need to port to UNIX. (1 Reply)
Discussion started by: RichardS
1 Replies
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

mysql::diff::database

MySQL::Diff::Database(3pm)				User Contributed Perl Documentation				MySQL::Diff::Database(3pm)

NAME

       MySQL::Diff::Database - Database Definition Class

SYNOPSIS

	 use MySQL::Diff::Database;

	 my $db = MySQL::Diff::Database->new(%options);
	 my $source    = $db->source_type();
	 my $summary   = $db->summary();
	 my $name      = $db->name();
	 my @tables    = $db->tables();
	 my $table_def = $db->table_by_name($table);

	 my @dbs = MySQL::Diff::Database::available_dbs();

DESCRIPTION

       Parses a database definition into component parts.

METHODS

   Constructor
       new( %options )
	   Instantiate the objects, providing the command line options for database access and process requirements.

   Public Methods
       o   source_type()

	   Returns 'file' if the data source is a text file, and 'db' if connected directly to a database.

       o   summary()

	   Provides a summary of the database.

       o   name()

	   Returns the name of the database.

       o   tables()

	   Returns a list of tables for the current database.

       o   table_by_name( $name )

	   Returns the table definition (see MySQL::Diff::Table) for the given table.

FUNCTIONS

   Public Functions
       o   available_dbs()

	   Returns a list of the available databases.

	   Note that is used as a function call, not a method call.

COPYRIGHT AND LICENSE

       Copyright (c) 2000-2011 Adam Spiers. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

SEE ALSO

       mysqldiff, MySQL::Diff, MySQL::Diff::Table, MySQL::Diff::Utils

AUTHOR

       Adam Spiers <mysqldiff@adamspiers.org>

perl v5.14.2							    2012-04-06						MySQL::Diff::Database(3pm)