看板Programming
标 题请问SQL连线问题...
发信站KKCITY (Sat Jun 17 11:26:39 2006)
转信站ptt!ctu-reader!ctu-gate!news.nctu!news.ntu!bbs.ee.ntu!news.kkcity.com.
我写一个VB.net连线到SQL 2000
用查询方式输入
以lable显示各相对栏位....
可是我都会出现下面错误
我该怎嚜去设定??
http://tw.myblog.yahoo.com/jw!ZdnkH7acGRwOpSJFzUTR0ju0/photo?pid=9
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim cn As New SqlConnection("server=192.111.0.2.;database=test;uid=doctor;pwd=123;")
Dim cmd As New SqlCommand("select * from person where id='" & TextBox1.Text & "'", cn)
Try
cn.Open()
Dim dr As SqlDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection)
dr.Read()
Label1.Text = dr("CategoryID")
Label2.Text = dr("CategoryName")
Label3.Text = dr("Description")
Catch ex As SqlException
MessageBox.Show(ex.Message)
End Try
End Sub
--
┌─────◆ＫＫＣＩＴＹ◆─────┐▇─┐ＫＫＡＤＳＬ→六星级优质连线服务
│ bbs.kkcity.com.tw │┴ └─▇ 马上申请带你上网环游全世界！
└──《From:140.115.70.87
》──┘ KKADSL ┴ http://adsl.kkcity.com.tw
--