On this page
Represents a single statement in a script.
Syntax
|
|---|
'Declaration
Public Class SqlStatement |
|
|---|
public class SqlStatement |
Example
This sample shows how to retrieve collection of statements that make up the script and execute them one by one.
|
|---|
string script =
"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";
MongoDBConnection mongoDBConn = new MongoDBConnection(
"Host=localhost;Port=27017;Database=sample;User Id=user;Password=pwd;");
MongoDBScript mongoDBScript = new MongoDBScript(script,mongoDBConn);
SqlStatementCollection mongoDBColl = mongoDBScript.Statements;
IDataReader mongoDBReader;
mongoDBConn.Open();
foreach (SqlStatement mongoDBStatement in mongoDBColl)
{
Console.WriteLine(mongoDBStatement.Text);
try
{
mongoDBReader = mongoDBStatement.Execute();
Console.WriteLine(" Records affected " + mongoDBReader.RecordsAffected);
while (mongoDBReader.Read())
{
Console.WriteLine(mongoDBReader.GetString(0));
}
mongoDBReader.Close();
Console.WriteLine();
}
catch
{
Console.WriteLine(" Failed");
}
}
mongoDBConn.Close(); |
|
|---|
Dim script As String = _
"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 mongoDBConn As MongoDBConnection = New MongoDBConnection( _
"Host=localhost;Port=27017;Database=sample;User Id=user;Password=pwd;")
Dim mongoDBScript As MongoDBScript = New MongoDBScript(script, mongoDBConn)
Dim mongoDBColl As SqlStatementCollection = mongoDBScript.Statements
Dim mongoDBReader As IDataReader
mongoDBConn.Open()
For Each mongoDBStatement As SqlStatement In mongoDBColl
Console.WriteLine(mongoDBStatement.Text)
Try
mongoDBReader = mongoDBStatement.Execute()
Console.WriteLine(" Records affected " & mongoDBReader.RecordsAffected)
While mongoDBReader.Read()
Console.WriteLine(mongoDBReader.GetString(0))
End While
mongoDBReader.Close()
Console.WriteLine()
Catch ex As Exception
Console.WriteLine(" Failed")
End Try
Next mongoDBStatement
mongoDBConn.Close() |
Inheritance Hierarchy
System.Object
Devart.Common.SqlStatement
See Also
