以前用Microsoft Visual Studio 2003 C#,由于学习需要转Microsoft Visual Studio 2005 VB,现在还不是很习惯,想请教一个很菜的问题Microsoft Visual Studio 2005 VB如何连接SQL2000的问题.(最好也把要导入的namespace写上,我经常搞错的),谢谢~~各位.
应该跟VB.NET2003类似吧 imports System.Data.SqlClientdim sqlconnection conn as sqlconnection=new sqlconnection(...) dim sqlcommand cmd as sqlcommand= new sqlcommand() ......
using System.Data.SqlClient;//命名空间 SqlConnection con=new SqlConnection("连接字符串"); //打开连接 con.Open(); SqlCommand cmd=new SqlCommand("select * from sysobjects"); //执行数据查找并进行操作//关闭连接 con.Close();
总是提示出错. 数据源的类型无效。它必须是 IListSource、IEnumerable 或 IDataSource。 Dim cn As SqlConnection cn = New SqlConnection("server=localhost;database=master;uid=sa;pwd=;") cn.Open() Dim adr As New SqlDataAdapter("select name from dbo.spt_values", cn) Dim ds As New DataSet adr.Fill(ds, "num") GridView1.DataSource = adr GridView1.DataBind() 各位英雄们指点指点,求求了.
using System.Data.Sqlclient;//导入命名空间 dim con as SqlConnectionnew con=SqlConnection("server=.;database=master;uid=sa;pwd=;") cn.open() Dim adr As New SqlDataAdapter("select name from dbo.spt_values", cn) Dim ds As New DataSet adr.Fill(ds, "num") this.GridView1.DataSource = adr this.GridView1.DataBind()注意:测试数据库是本机数据库,master允许访问用户SA,密码为空.并且SQL属性配置中,安全选项中要有允许SQL Server方式访问.这样应该就没问题了.可以试一下.
imports System.Data.SqlClientdim sqlconnection conn as sqlconnection=new sqlconnection(...)
dim sqlcommand cmd as sqlcommand= new sqlcommand()
......
SqlConnection con=new SqlConnection("连接字符串");
//打开连接
con.Open();
SqlCommand cmd=new SqlCommand("select * from sysobjects");
//执行数据查找并进行操作//关闭连接
con.Close();
数据源的类型无效。它必须是 IListSource、IEnumerable 或 IDataSource。
Dim cn As SqlConnection
cn = New SqlConnection("server=localhost;database=master;uid=sa;pwd=;")
cn.Open()
Dim adr As New SqlDataAdapter("select name from dbo.spt_values", cn)
Dim ds As New DataSet
adr.Fill(ds, "num")
GridView1.DataSource = adr
GridView1.DataBind()
各位英雄们指点指点,求求了.
dim con as SqlConnectionnew
con=SqlConnection("server=.;database=master;uid=sa;pwd=;")
cn.open()
Dim adr As New SqlDataAdapter("select name from dbo.spt_values", cn)
Dim ds As New DataSet
adr.Fill(ds, "num")
this.GridView1.DataSource = adr
this.GridView1.DataBind()注意:测试数据库是本机数据库,master允许访问用户SA,密码为空.并且SQL属性配置中,安全选项中要有允许SQL Server方式访问.这样应该就没问题了.可以试一下.