Click here to Skip to main content
12,631,374 members (31,770 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C# SQL-Server ADO.NET
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?
Posted 8-Jun-12 12:53pm
Updated 8-Jun-12 18:22pm
RaisKazi34.5K
v2
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

Use BindingSource, here a CP article for you

BindingSource and BindingNavigator in C# 2.0[^]
  Permalink  
Comments
yasser_ja 9-Jun-12 4:52am
   
Is it possible to use binding source without text boxes?
Suppose I wanna do some operations on the rows data and display the result later.
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

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[^]
  Permalink  
Comments
yasser_ja 8-Jun-12 18:53pm
   
Thank you for the hint,

But I need to access Sql server database with same technique used with access2007 but with the sqlclient library

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.161205.3 | Last Updated 9 Jun 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100