Click here to Skip to main content
Rate this: bad
good
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
Edited 8-Jun-12 18:22pm
RaisKazi33.1K
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 at 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 at 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
0 BillWoodruff 360
1 Mathew Soji 309
2 DamithSL 225
3 Afzaal Ahmad Zeeshan 202
4 Maciej Los 190
0 OriginalGriff 6,249
1 Sergey Alexandrovich Kryukov 5,853
2 DamithSL 5,183
3 Manas Bhardwaj 4,673
4 Maciej Los 3,865


Advertise | Privacy | Mobile
Web01 | 2.8.1411019.1 | Last Updated 9 Jun 2012
Copyright © CodeProject, 1999-2014
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