首先建立connection dim myconn as sqlconnection="server=sqlserver;database=dbname;uid=uid;pwd=pwd;" 如果是直接调用Sql语句: dim strsql as string="Select * from tablename" 如果是调用存储过程: dim strsql as string="Execute SPname" '其中SPNAME是存储过程的名称 dim mycommand as new sqldataadapter(strsql,myconn) dim myds as new dataset mycommand.fill(myds,"tablename") 然后就可以引用了
要在.net中直接调用,是不行的,但你可以试一下SqlDMO
dim myconn as sqlconnection="server=sqlserver;database=dbname;uid=uid;pwd=pwd;"
如果是直接调用Sql语句:
dim strsql as string="Select * from tablename"
如果是调用存储过程:
dim strsql as string="Execute SPname" '其中SPNAME是存储过程的名称
dim mycommand as new sqldataadapter(strsql,myconn)
dim myds as new dataset
mycommand.fill(myds,"tablename")
然后就可以引用了