Simple Database Connection Code

[Poewood]

Does anyone have some basic code and the corresponding resources needed that
will enable me to connect to an Access Database in .net compact frmwrk using
C#. I need to learn how to create a recordset and do some reading, updating
and appending. I can't seem to find any straight forward examples. It's all
blah, blah, blah. I would appreciate any code that I can build on.

Thank you.

[Lord2702]

Thu. Aug. 26, 2004 10:10 PM PT

MyDataBase = your Access .MDB file, give a full path of your file location,
check the syntax
MyTable = your table in Access database.
If you want ODBC connection string Let me know.
I hope this will solve your probs.

Good Luck.
[C#]
// OLE DB Driver string for MS Access database

SqlConnection con = new SqlConnection(( "Data
Source="c:\\tem p\\MyDataBase.m db";Provider=\" Microsoft.Jet.O LEDB.4.0\";Jet
OLEDB:Engine Type=5;");
SqlCommand cmd = con.CreateComma nd();
cmd.CommandText = "Select from MyTable";
cmd.ExecuteQuer y();
or
cmd.ExecuteRead er();
con.Close()
"Poewood" <Po*****@discus sions.microsoft .com> wrote in message
news:2D******** *************** ***********@mic rosoft.com...

Does anyone have some basic code and the corresponding resources needed that will enable me to connect to an Access Database in .net compact frmwrk using C#. I need to learn how to create a recordset and do some reading, updating and appending. I can't seem to find any straight forward examples. It's all blah, blah, blah. I would appreciate any code that I can build on.

Thank you.

[Morten Wennevik]

Hi Poewood,

The connection strings can be found here:

http://www.connectionstrings.com/

You can use OleDbDataAdapte r to fill data from the database into a dataset.
You can use the same dataadapter to write data back to the database.

Maybe one of these are what you are looking for:

http://www.codeproject.com/cs/databa...rpaccessdb.asp
http://www.c-sharpcenter.com/Tutoria...aseConn_01.htm
http://c-sharpcenter.com/Tutorial/Database2.htm
http://c-sharpcenter.com/Tutorial/DB_part3.htm
http://www.c-sharpcenter.com/Tutorial/DB_part4.htm

--
Happy Coding!
Morten Wennevik [C# MVP]

[Tim Anderson]

"Poewood" <Po*****@discus sions.microsoft .com> wrote in message
news:2D******** *************** ***********@mic rosoft.com...

Does anyone have some basic code and the corresponding resources needed
that
will enable me to connect to an Access Database in .net compact frmwrk
using
C#. I need to learn how to create a recordset and do some reading,
updating
and appending. I can't seem to find any straight forward examples. It's
all
blah, blah, blah. I would appreciate any code that I can build on.

There's no Access database driver for the Compact Framework. I'd suggest SQL
Server CE.

Tim

[Poewood]

But isn't the SQL Server CE database really a "pocket Access Dbase"? How do
I convert an Access Database to a SQL Server CE databse?

"Tim Anderson" wrote:

"Poewood" <Po*****@discus sions.microsoft .com> wrote in message
news:2D******** *************** ***********@mic rosoft.com...

Does anyone have some basic code and the corresponding resources needed
that
will enable me to connect to an Access Database in .net compact frmwrk
using
C#. I need to learn how to create a recordset and do some reading,
updating
and appending. I can't seem to find any straight forward examples. It's
all
blah, blah, blah. I would appreciate any code that I can build on.

There's no Access database driver for the Compact Framework. I'd suggest SQL
Server CE.

Tim