'Declaration Public ReadOnly Property Statements As SqlStatementCollection
public SqlStatementCollection Statements {get;}
'Declaration Public ReadOnly Property Statements As SqlStatementCollection
public SqlStatementCollection Statements {get;}
string script = @"if object_id('dept', 'U') is not null drop table dept; CREATE TABLE Dept( DEPTNO int PRIMARY KEY NOT NULL, DNAME varchar(14) NULL, LOC varchar(13) NULL );"+ "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"; SqlConnection myConn = new SqlConnection( "User Id=sa;Server=localhost;Initial Catalog=Test;"); SqlScript myScript = new SqlScript(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 = _ "if object_id('dept', 'U') is not null" & _ " drop table dept;" & _ "CREATE TABLE Dept(" & _ " DEPTNO int PRIMARY KEY NOT NULL," & _ " DNAME varchar(14) NULL," & _ " LOC varchar(13) NULL" & _ ");" & _ "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 SqlConnection = New SqlConnection( _ "User Id=sa;Server=localhost;Initial Catalog=Test;") Dim myScript As SqlScript = New SqlScript(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()