Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/mono/mono.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat (limited to 'mcs/class/System.Data/Test/TestSqlException.cs')
-rw-r--r--mcs/class/System.Data/Test/TestSqlException.cs118
1 files changed, 0 insertions, 118 deletions
diff --git a/mcs/class/System.Data/Test/TestSqlException.cs b/mcs/class/System.Data/Test/TestSqlException.cs
deleted file mode 100644
index 294a1ddfba3..00000000000
--- a/mcs/class/System.Data/Test/TestSqlException.cs
+++ /dev/null
@@ -1,118 +0,0 @@
-//
-// TestSqlInsert.cs
-//
-// To Test SqlConnection and SqlCommand by connecting
-// to a PostgreSQL database
-// and then executing an INSERT SQL statement
-//
-// To use:
-// change strings to your database, userid, tables, etc...:
-// connectionString
-// insertStatement
-//
-// To test:
-// mcs TestSqlInsert.cs -r System.Data
-// mint TestSqlInsert.exe
-//
-// Author:
-// Rodrigo Moya (rodrigo@ximian.com)
-// Daniel Morgan (danmorg@sc.rr.com)
-//
-// (C) Ximian, Inc 2002
-//
-
-using System;
-using System.Data;
-using System.Data.SqlClient;
-
-namespace TestSystemDataSqlClient
-{
- class TestSqlInsert
- {
- [STAThread]
- static void Main(string[] args) {
- SqlConnection conn;
- SqlCommand cmd;
- SqlTransaction trans;
-
- int rowsAffected;
-
- String connectionString;
- String insertStatement;
- String deleteStatement;
-
- connectionString =
- "host=localhost;" +
- "dbname=test;" +
- "user=postgres";
-
- insertStatement =
- "insert into NoSuchTable " +
- "(tid, tdesc) " +
- "values ('beer', 'Beer for All!') ";
-
- deleteStatement =
- "delete from sometable " +
- "where tid = 'beer' ";
-
- try {
- // Connect to a PostgreSQL database
- Console.WriteLine ("Connect to database...");
- conn = new SqlConnection(connectionString);
- conn.Open();
-
- // begin transaction
- Console.WriteLine ("Begin Transaction...");
- trans = conn.BeginTransaction();
-
- // create SQL DELETE command
- Console.WriteLine ("Create Command initializing " +
- "with an DELETE statement...");
- cmd = new SqlCommand (deleteStatement, conn);
-
- // execute the DELETE SQL command
- Console.WriteLine ("Execute DELETE SQL Command...");
- rowsAffected = cmd.ExecuteNonQuery();
- Console.WriteLine ("Rows Affected: " + rowsAffected);
-
- // change the SQL command to an SQL INSERT Command
- Console.WriteLine ("Now use INSERT SQL Command...");
- cmd.CommandText = insertStatement;
-
- // execute the INSERT SQL command
- Console.WriteLine ("Execute INSERT SQL Command...");
- rowsAffected = cmd.ExecuteNonQuery();
- Console.WriteLine ("Rows Affected: " + rowsAffected);
-
- // if successfull at INSERT, commit the transaction,
- // otherwise, do a rollback the transaction using
- // trans.Rollback();
- Console.WriteLine ("Commit transaction...");
- trans.Commit();
-
- // Close connection to database
- Console.WriteLine ("Close database connection...");
- conn.Close();
-
- Console.WriteLine ("Assuming everything " +
- "was successful.");
- Console.WriteLine ("Verify data in database to " +
- "see if row is there.");
- }
- catch(SqlException e) {
- // Display the SQL Errors and Rollback the database
- Console.WriteLine("SqlException caught: " +
- e.ToString());
- if(trans != null) {
- trans.Rollback();
- Console.WriteLine("Database has been Rolled back!");
- }
- }
- finally {
- if(conn != null)
- if(conn.State == ConnectionState.Open)
- conn.Close();
- }
- }
- }
-}