OracleDataReader的两个用法

1. 在datagrid里创建4个BoundColumn和一个LinkButton。
<asp:DataGrid id="DataGrid1" style="Z-INDEX: 110; LEFT: 16px; POSITION: absolute; TOP: 168px"
Visible="True" runat="server" AutoGenerateColumns="False">
<Columns>
<asp:BoundColumn DataField="ID" HeaderText="ID"></asp:BoundColumn>
<asp:BoundColumn DataField="NUM1" HeaderText="NUM1"></asp:BoundColumn>
<asp:BoundColumn DataField="NUM2" HeaderText="NUM2"></asp:BoundColumn>
<asp:BoundColumn DataField="NUM3" HeaderText="NUM3"></asp:BoundColumn>
<asp:EditCommandColumn ButtonType="LinkButton" UpdateText="Update" HeaderText="Edit!" CancelText="Cancel"
EditText="Edit"></asp:EditCommandColumn>
</Columns>
</asp:DataGrid>
2. datagrid通过OracleDataReader获得数据
Dim Orclcnn As OracleConnection

Dim OrclComm As OracleCommand

Dim OraclReader As OracleDataReader

Try

Orclcnn = New OracleConnection

OrclComm = New OracleCommand

Orclcnn.ConnectionString = "Data Source=edc81;User Id=test;Password=test"

Orclcnn.Open()

OrclComm.CommandText = "select * from test1 where id = 1"

OrclComm.CommandType = System.Data.CommandType.Text

OrclComm.Connection = Orclcnn

OraclReader = OrclComm.ExecuteReader

DataGrid2.DataSource = OraclReader

DataGrid2.DataBind()

Catch ex As Exception

Throw ex

Finally

OraclReader.Close()

Orclcnn.Close()

End Try

3. 获取OracleDataReader里特定列
Dim Orclcnn As OracleConnection

Dim OrclComm As OracleCommand

Dim OraclReader As OracleDataReader

Try

Orclcnn = New OracleConnection

OrclComm = New OracleCommand

Orclcnn.ConnectionString = "Data Source=edc81;User Id=test;Password=test"

Orclcnn.Open()

OrclComm.CommandText = "select * from test1 where id = 1"

OrclComm.CommandType = System.Data.CommandType.Text

OrclComm.Connection = Orclcnn

OraclReader = OrclComm.ExecuteReader

OraclReader.Read()

If OraclReader.HasRows = False Then

Exit Try

End If

Label1.Text = CStr(OraclReader.Item(0)) + "aaaa" + _

CStr(OraclReader.Item(1)) + _

"bbbbb" + CStr(OraclReader.Item(2)) + "cccc" + _

CStr(OraclReader.Item(3))

Catch ex As Exception

Throw ex

Finally

OraclReader.Close()

Orclcnn.Close()

End Try