从SQL Server Express读取 [英] Reading from SQL Server Express

问题描述

我曾经使用adodb.connection库中的adodb.dll库中的记录集来处理MS:Access数据库

我可以movenext()，movefirst() ... etc
+检查BOF或EOF ... etc

问题是:

如何使用Sqlclient库做到这一点?

可能吗?或者我可以使用adodb库连接到SQL Server?

Hi,

I used to deal with MS:Access database using recordset in adodb.dll library with adodb.connection

and I can movenext(), movefirst()...etc
+ checking if BOF or EOF...etc

The question is:

How I can do this with Sqlclient library?

Is it possible? or I can use adodb library to connect to sql server? How?

推荐答案

使用BindingSource，这是为您准备的CP文章

C#2.0中的BindingSource和BindingNavigator [

Use BindingSource, here a CP article for you

BindingSource and BindingNavigator in C# 2.0[^]

Access 2007的提供程序
ACE OLEDB 12.0
OLE DB(OleDbConnection)的.NET Framework数据提供程序
Microsoft Access accdb ODBC驱动程序
ODBC的.NET Framework数据提供程序(OdbcConnection)

访问权限提供商
Microsoft Jet OLE DB 4.0
OLE DB(OleDbConnection)的.NET Framework数据提供程序
Microsoft Access ODBC驱动程序
ODBC的.NET Framework数据提供程序(OdbcConnection)

在这里，您会找到可能的连接:
http://www.connectionstrings.com/access-2007 [ http://www.connectionstrings.com/access [

Providers for Access 2007
ACE OLEDB 12.0
.NET Framework Data Provider for OLE DB(OleDbConnection)
Microsoft Access accdb ODBC Driver
.NET Framework Data Provider for ODBC(OdbcConnection)

Providers for Access
Microsoft Jet OLE DB 4.0
.NET Framework Data Provider for OLE DB(OleDbConnection)
Microsoft Access ODBC Driver
.NET Framework Data Provider for ODBC(OdbcConnection)

Here you''ll find possible connections:
http://www.connectionstrings.com/access-2007[^]
http://www.connectionstrings.com/access[^]

这篇关于从SQL Server Express读取的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！