如何把数据库连接用类创建（VB.net）？

sdenly 发布于 2006-12-04 23:45， 649 次点击

如何把数据库连接用类创建（VB.net）？
public class DB:System.Web.UI.Page
{
public DB()
{
}
public static SqlConnection CreateDBcon()
{
return new SqlConnection("server=.;database=mydb;uid=sa;pwd=123456;");
}
}
}
这句代码如何转换成VB.net的？

3 回复

Reejay2006-12-08 16:16

Function CreateDBcon() as SqlConnection
Return conn.ConnectionString = "server=.;database=mydb;uid=sa;pwd=123456";
End Function

bygg2006-12-08 16:32

以下是引用Reejay在2006-12-8 16:16:19的发言：

Function CreateDBcon() as SqlConnection
Return conn.ConnectionString = "server=.;database=mydb;uid=sa;pwd=123456" ;
End Function

VB里面没有后面的分号,呵.

cxk9532007-05-09 23:05

回复：（sdenly）如何把数据库连接用类创建（VB.net）...

Imports System.Data.SqlClient
Imports System
Public MustInherit Class DB
'Implements IDisposable

Public Shared con As SqlConnection

Shared Function CreateDBcon() As SqlConnection

con = New SqlConnection("server=.;database=mydb;uid=sa;pwd=123456")
Return con
End Function

End Class
类的共享方法.