в 16:40, 26 мая 2010

2010-05-26T16:40:16Z

Admin: 1 версия

2010-05-26T12:49:39Z

1 версия

Новая страница

==New DataView==

<source lang="vbnet">

Imports System
Imports System.Data
Imports System.Data.SqlClient

public class MainClass
Shared Sub Main()
Dim thisConnection As New SqlConnection("server=(local)\SQLEXPRESS;" & _
"integrated security=sspi;database=MyDatabase")
Dim sql As String = "SELECT FirstName, LastName FROM Employee"
Try
Dim da As New SqlDataAdapter
da.SelectCommand = New SqlCommand(sql, thisConnection)
Dim ds As New DataSet
da.Fill(ds, "Employee")
Dim dt As DataTable = ds.Tables("Employee")
Dim dv As New DataView(dt, _
"FirstName = "Joe"", _
"FirstName", DataViewRowState.CurrentRows)
" Display Data In Data View
For Each row As DataRowView In dv
For i As Integer = 0 To dv.Table.Columns.Count - 1
Console.Write(row(i).PadRight(20))
Next
Console.WriteLine()
Next
Catch ex As SqlException
" Display error
Console.WriteLine("Error: " & ex.ToString())
Finally
" Close Connection
thisConnection.Close()
Console.WriteLine("Connection Closed")
End Try
End Sub
End Class

</source>

← Предыдущая	Версия 16:40, 26 мая 2010
(нет различий)

VB.Net by API/System.Data/DataView - История изменений

в 16:40, 26 мая 2010

Admin: 1 версия