[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 |
댓글 없음:
댓글 쓰기