sub Page_Load(obj as object,e as eventargs) 'set up connection dim objConn as new SqlConnection("Provider=Microsoft.Jet.OLEDB.4.0;"&"Data Sourse=C:\Program Files\Microsoft SQL Server\MSSQL\Data\CVE Library_Data.MDF")不对啊
这句写错了: dim objCmd as SqlDataAdapter=new SqlDataAdapter("select * from CVELibrary where sb=name",objConn)改为: dim objCmd as SqlDataAdapter=new SqlDataAdapter("select * from CVELibrary where sb="&name,objConn)
dim objConn as new SqlConnection("Data Source=C:\Program Files\Microsoft SQL Server\MSSQL\Data\CVE Library_Data.MDF"&"Initial Catalog=pubs"&"Integrated Security=SSPI") 我这样连接对吗,为什么还是连接不上啊!大哥帮忙啊!
你用的是sql server? 參考下面的連接 data source=服務名稱 or ip;initial catalog=數據庫名稱;persist security info=True;user id=sa;password=;connect timeout=15000
http://www.csdn.net/Develop/read_article.asp?id=16437
dim objCmd as SqlDataAdapter=new SqlDataAdapter("select * from CVELibrary where sb=name",objConn)改为:
dim objCmd as SqlDataAdapter=new SqlDataAdapter("select * from CVELibrary where sb="&name,objConn)
我这样连接对吗,为什么还是连接不上啊!大哥帮忙啊!
參考下面的連接
data source=服務名稱 or ip;initial catalog=數據庫名稱;persist security info=True;user id=sa;password=;connect timeout=15000