17,090
社区成员
发帖
与我相关
我的任务
分享请教用Oracle客户端直接连接数据库时如何将结果放在DataGridView?
大家好，我刚接触Oracle。请教用Oracle客户端直接连接数据库时如何将结果高效的放在DataGridView中?
Dim strSQL As String
Dim strCN = "User ID=LTON;Password=db;Data Source=TESTDB;"
Dim SchemaName = "LTON"
strSQL = "SELECT customer_name_ FROM job_list WHERE customer_name_ LIKE '%为%'"
Dim conn As New OracleConnection(strCN)
conn.Open()
Dim cmd As New OracleCommand
cmd.Connection = conn
cmd.CommandText = strSQL
cmd.CommandType = CommandType.Text
Dim dr As OracleDataReader = cmd.ExecuteReader()
'......
Dim strSQL As String
Dim strCN = "User ID=LTON;Password=db;Data Source=TESTDB;"
Dim SchemaName = "LTON"
strSQL = "SELECT customer_name_ FROM job_list WHERE customer_name_ LIKE '%为%'"
Dim conn As New OracleConnection(strCN)
conn.Open()
Dim cmd As New OracleCommand
cmd.Connection = conn
cmd.CommandText = strSQL
cmd.CommandType = CommandType.Text
Dim dr As OracleDataReader = cmd.ExecuteReader()
'......
...全文
请发表友善的回复…
发表回复
leon51 2016-09-06
- 打赏
- 举报
多谢1楼的回复，问题解决了
卖水果的net 2016-09-06
- 打赏
- 举报
到 C# 区问问吧，那边有好多这方面的例子；
leon51 2016-09-06
- 打赏
- 举报
能不能写的详细点啊，我是个新手
chuzhaowei 2016-09-05
- 打赏
- 举报
DataGridViewid.DataSource=查询结果集; (DataTable等对象)
DataGridViewid.DataBind();
