'Declaration Public ReadOnly Property Statements As SqlStatementCollection
public SqlStatementCollection Statements {get;}
'Declaration Public ReadOnly Property Statements As SqlStatementCollection
public SqlStatementCollection Statements {get;}
string script = "DROP TABLE IF EXISTS DEPT;"+ "CREATE TABLE DEPT ("+ " DEPTNO INT PRIMARY KEY,"+ " DNAME VARCHAR(14),"+ " LOC VARCHAR(13)"+ ") TYPE = InnoDB;"+ "INSERT INTO DEPT VALUES (10,'ACCOUNTING','NEW YORK');"+ "INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');"+ "INSERT INTO DEPT VALUES (30,'SALES','CHICAGO');"+ "INSERT INTO DEPT VALUES (40,'OPERATIONS','BOSTON');"+ "SELECT * FROM DEPT"; MySqlConnection myConn = new MySqlConnection( "User Id=root;Host=localhost;Database=Test;"); MySqlScript myScript = new MySqlScript(script,myConn); SqlStatementCollection myColl = myScript.Statements; IDataReader myReader; myConn.Open(); foreach (SqlStatement myStatement in myColl) { Console.WriteLine(myStatement.Text); try { myReader = myStatement.Execute(); Console.WriteLine(" Records affected " + myReader.RecordsAffected); while (myReader.Read()) { Console.WriteLine(myReader.GetString(0)); } myReader.Close(); Console.WriteLine(); } catch { Console.WriteLine(" Failed"); } } myConn.Close();
Dim script As String = _ "DROP TABLE IF EXISTS DEPT;" + _ "CREATE TABLE DEPT (" + _ " DEPTNO INT PRIMARY KEY," + _ " DNAME VARCHAR(14)," + _ " LOC VARCHAR(13)" + _ ") TYPE = InnoDB;" + _ "INSERT INTO DEPT VALUES (10,'ACCOUNTING','NEW YORK');" + _ "INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');" + _ "INSERT INTO DEPT VALUES (30,'SALES','CHICAGO');" + _ "INSERT INTO DEPT VALUES (40,'OPERATIONS','BOSTON');" + _ "SELECT * FROM DEPT" Dim myConn As MySqlConnection = New MySqlConnection( _ "User Id=root;Host=localhost;Database=Test;") Dim myScript As MySqlScript = New MySqlScript(script, myConn) Dim myColl As SqlStatementCollection = myScript.Statements Dim myReader As IDataReader myConn.Open() For Each myStatement As SqlStatement In myColl Console.WriteLine(myStatement.Text) Try myReader = myStatement.Execute() Console.WriteLine(" Records affected " & myReader.RecordsAffected) While myReader.Read() Console.WriteLine(myReader.GetString(0)) End While myReader.Close() Console.WriteLine() Catch ex As Exception Console.WriteLine(" Failed") End Try Next myStatement myConn.Close()