Execute Method (SqlStatement)
On this page
Executes the statement and returns result set.
Syntax
Return Value
Result set returned by the statement execution.
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() |
See Also
