关于VB.NET应用程序访问数据库时出现的问题 麻烦大侠解惑
应用程序是:
Imports System.Data
Imports System.Data.SqlClient
Public Class Form1
Inherits System.Windows.Forms.Form
Dim connStr As String
Dim selectCmd As String
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
connStr = "Server=localhost;database=spj;uid=sa;pwd=;"
selectCmd = "SELECT * FROM spj"
Dim conn As SqlConnection
Dim myAdapter As SqlDataAdapter
Dim mydataset As New DataSet()
conn = New SqlConnection(connStr)
conn.Open()
myAdapter = New SqlDataAdapter(selectCmd, conn)
myAdapter.Fill(mydataset, "J")
DataGrid1.DataSource = mydataset.Tables("J")
conn.Close()
End Sub
End Class
spj是数据库 J 是数据库中的数据表
错误是:
未处理的“System.Data.SqlClient.SqlException”类型的异常出现在 System.Data.dll 中。
其他信息: 用户 'sa' 登录失败。
这是什么原因?