[:$] Setting a connection

Question

User452964888 posted

Hi,

 I have tables in Access, in employee.mdb file.

I need to connect to the Data Base.

I'm working with SqlDataAdapter in C# in .Net.

Can someone PLEASE explain or write an example how should I do it??

Thanks ahead,

Yael

Answer 1

User1872574491 posted

Hi,

You can use System.data.oledb for connecting to access database.

There you can get oledbconnection,oledbcommand objects.

Answer 2

User-821857111 posted

You need an OleDbDataAdapter with Access. 

http://authors.aspalliance.com/aspxtreme/sys/data/oledb/OleDbDataAdapterClass.aspx

 

Answer 3

User452964888 posted

Thank you guys, it is working now [:)]