[ADO.NET]ODP.Net을 이용한 DataAdapter 예제
간단한 예제 입니다. 참고하세요~
Dim mydeptno, mydname As String:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Dim connectStr As String = "User Id=scott;Password=tiger;Data Source=onj"
Dim con As New OracleConnection(connectStr)
Dim objAdapter As OracleDataAdapter = New OracleDataAdapter()
objAdapter.SelectCommand = New OracleCommand("Select * from emp", con)
Dim objDataSet As DataSet = New DataSet("objDataSet")
objAdapter.Fill(objDataSet, "Emp")
Me.myDataGrid.SetDataBinding(objDataSet, "EMP")
con.Close()
con.Dispose()
| 12-27 | 2437 | |||
| 12-11 | 1788 | |||
| 53 | 03-15 | 1599 | ||
| 52 | 01-31 | 1692 | ||
| 51 | 01-31 | 2319 | ||
| 50 | 01-31 | 1335 | ||
| 49 | 01-19 | 1644 | ||
| 48 | 01-11 | 1500 | ||
| 47 | 01-03 | 2029 | ||
| 46 | 12-27 | 2437 | ||
| 45 | 12-19 | 1755 | ||
| 44 | 12-14 | 1731 | ||
| 43 | 12-11 | 1788 | ||
| 42 | 12-09 | 1403 | ||
| 41 | 12-01 | 1631 | ||
| 40 | 12-01 | 1806 | ||
| 39 | 12-01 | 1280 | ||
댓글 없음:
댓글 쓰기