Represents a single statement in a script.
public class SqlStatement
'Declaration
Public Class SqlStatement
This sample shows how to retrieve collection of statements that make up the script and execute them one by one.
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()
System.Object
Devart.Common.SqlStatement