Imports System
Imports System.data
Imports System.data.SqlClient
Partial Class _Default
Inherits System.Web.UI.Page Dim str As String = "server=(local);database=newdb;uid=sa;pwd=sa"
Dim con As SqlConnection = New SqlConnection(str)
'在这里出的错,说的是New SqlConnection的sqlconnection未声明,,,怎么解决???
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
con.Open()
Dim loadcommand As SqlCommand = New SqlCommand("updatetable", con)
0...............
end sub
Imports System.data
Imports System.data.SqlClient
Partial Class _Default
Inherits System.Web.UI.Page Dim str As String = "server=(local);database=newdb;uid=sa;pwd=sa"
Dim con As SqlConnection = New SqlConnection(str)
'在这里出的错,说的是New SqlConnection的sqlconnection未声明,,,怎么解决???
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
con.Open()
Dim loadcommand As SqlCommand = New SqlCommand("updatetable", con)
0...............
end sub
必须写成:Dim str As String = "server=(local);database=newdb;uid=sa;pwd=sa"
Dim con As SqlConnection = New Data.SqlClient.SqlConnection(str)的形式
我不是定义了 imports System.data.SqlClient了么,为什么还要这样写?
你放到某个方法内部new试试
代码在本页写好 还是在.aspx.vb里写好啊
它们有什么区别吗?
Imports System
Imports System.data
Imports System.data.SqlClientPartial Class _Default
Inherits System.Web.UI.Page Dim str As String = "server=(local);database=newdb;uid=sa;pwd=sa"
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim con As SqlConnection = New SqlConnection(str)
con.Open()
Dim loadcommand As SqlCommand = New SqlCommand("updatetable", con)
0...............
end sub