Database.ExecuteWithResults Method (String)
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
A String value that contains a Transact-SQL command.
Return ValueA DataSet system object value that contains the returned results set.
Updated text: 17 July 2006
The results from this method are returned as a DataSet object. The DataSet object contains a collection of DataTable objects, from which the column and row information can be extracted.
This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.
'Connect to the local, default instance of SQL Server. Dim srv As Server srv = New Server 'Reference the AdventureWorks database. Dim db As Database db = srv.Databases("AdventureWorks") 'Run a Transact-SQL command on the database. db.ExecuteNonQuery("CHECKPOINT") 'Run a Transact-SQL command with results and display. Dim ds As DataSet ds = db.ExecuteWithResults( _ "SELECT * FROM Person.Address") Dim t As DataTable Dim r As DataRow Dim c As DataColumn For Each t In ds.Tables For Each r In t.Rows For Each c In r.Table.Columns Console.WriteLine( _ c.ColumnName + " = " + r(c).ToString) Next Next Next