Reading from SQL Server Express

Question

0.00/5 (No votes)

See more:

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 11:53am

yasser_ja

Updated 8-Jun-12 17:22pm

RaisKazi

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

thatraja · Answer 1 · 2012-06-08T21:28:00

Solution 2

Use BindingSource, here a CP article for you

BindingSource and BindingNavigator in C# 2.0[^]

Posted 8-Jun-12 21:28pm

thatraja

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.

Maciej Los · Answer 2 · 2012-06-08T11:59:00

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[^]