从 SQL 数据库中检索数据到 VB.NET
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/15268826/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Retrieving data from a SQL database to VB.NET
提问by 112221
Can anyone please tell me what i am doing wrong here? Very basic level of Visual Basic experience.
谁能告诉我我在这里做错了什么？非常基本的 Visual Basic 体验水平。
Im trying to retrieve the ORDERID, ORDERDATE and CUSTOMERID from the database provided and show them in a dataGridView?
我试图从提供的数据库中检索 ORDERID、ORDERDATE 和 CUSTOMERID 并将它们显示在 dataGridView 中？
Dim con1 As New OleDbConnection
con1.ConnectionString = _
"Provider=msdaora;Data Source=orabis;User Id=112221800;Password=112221800;"
'Dim con1 As New SqlConnection("Provider=msdaora;Data Source=orabis;User Id=112221800;Password=112221800;")
con1.Open()
Dim cmd1 As New SqlCommand("select ORDERID, ORDERDATE AND CUSTOMERID from CUSORDER", con1)
Dim ada1 As New SqlDataAdapter(cmd1)
Dim ds1 As New DataSet
ada1.Fill(ds1)
ViewDeliverys.DataGridView1.DataSource = ds1.Tables(0)
con1.Close()
回答by Tim Schmelter
You cannot use a OleDbConnectionwhith a SqlCommand(SQL-Server). Which rdbms are you using?
你不能使用OleDbConnection蒙山一个SqlCommand（SQL服务器）。您使用的是哪个 rdbms？
This works for SQL-Server:
这适用于 SQL-Server：
Using con = New SqlConnection(connectionString)
Using da = New SqlDataAdapter("SELECT ORDERID, ORDERDATE AND CUSTOMERID from CUSORDER", con)
Dim table = New DataTable()
da.Fill(table)
ViewDeliverys.DataGridView1.DataSource = table
End Using
End Using
Edit: Here's the OleDbversion:
编辑：这是OleDb版本：
Using con = New OleDbConnection(connectionString)
Using da = New OleDbDataAdapter("SELECT ORDERID, ORDERDATE AND CUSTOMERID from CUSORDER", con)
Dim table = New DataTable()
da.Fill(table)
ViewDeliverys.DataGridView1.DataSource = table
End Using
End Using
回答by BizApps
What Database are you using SQL Sever or MS Access? If you are uing SQL Server use SQL Connection then OleDBConnection on MS Access.
您使用 SQL Sever 或 MS Access 的数据库是什么？如果您使用 SQL Server，请使用 SQL Connection，然后在 MS Access 上使用 OleDBConnection。
For the correct connection string check it on:
对于正确的连接字符串，请检查：
http://www.connectionstrings.com
http://www.connectionstrings.com
Check also this tutorial from:
另请查看本教程：
http://vb.net-informations.com/ado.net-dataproviders/ado.net-sqldataadapter
http://vb.net-informations.com/ado.net-dataproviders/ado.net-sqldataadapter
And also Replace your query from:
并且还从以下位置替换您的查询：
Dim cmd1 As New SqlCommand("select ORDERID, ORDERDATE AND CUSTOMERID from CUSORDER", con1)
where ORDERDATE AND CUSTOMERIDwill throws you an error
哪里ORDERDATE AND CUSTOMERID会给你一个错误
Change it to:
将其更改为：
Dim cmd1 As New SqlCommand("select ORDERID, ORDERDATE,CUSTOMERID from CUSORDER", con1)
