Open Office database with c#

Question

5.00/5 (1 vote)

See more:

.NET3.5

HI,

Currently I have open office database. Now I need to get that database data to c# windows form application. I want to connect the open office database with connection string and get the dataset from c#. Can any one help me.
Thank you,

Posted 6-Jun-12 17:14pm

Soft009

Add a Solution

Comments

Bernhard Hiller 8-Jun-12 4:06am

It's an interesting question. I followed Abhinav's link and did not find anything useful: there are many drivers for retrieving data from other database into OpenOffice database, but no hints at all for conencting from a .Net application.
Perhaps you could ask your question also in a OpenOffice developer forum, and StackOverflow - in case you get a useful answer there, please come back and tell us.

Soft009 8-Jun-12 4:29am

Thanks a lot, I'll submit this in the Open office developer forum. Definitely I'll come back. :)

3 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)

Abhinav S · Answer 1 · 2012-06-06T17:21:00

Solution 1

http://wiki.services.openoffice.org/wiki/Database[^] should provide you with some solutions.

Posted 6-Jun-12 17:21pm

Abhinav S

Comments

Soft009 6-Jun-12 23:36pm

Thank you,
I just want to set the connection with the database in c#. Is it possible.

codeBegin · Answer 2 · 2012-06-06T17:57:00

I just want to set the connection with the database in c#
Yes it is possible, for that you have to follow some steps:

1) First add

C#

"using System.Data.OleDb;"

at to top of the CS file.

2) Create connection string and open connection.
For access 2007

C#

string ConnStr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\abc.mdb;Jet OLEDB:Database Password=password";

OleDbConnection MyConn = new OleDbConnection(ConnStr);

3) Open this connection.

MyConn.Open();

4) Create object for command and reader to get the data from access database.

C#

OleDbCommand Cmd =  new OleDbCommand(StrCmd, MyConn);;
 OleDbDataReader ObjReader = Cmd.ExecuteReader();

5) Now lood through the reader object to get the data

C#

if (ObjReader != null)
{

}

6) After completing the processing

C#

ObjReader.Close();
MyConn.Close();

Member 10562032 · Answer 3 · 2014-01-30T19:14:00

Solution 3

https://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native/1.0[^]

This has your and mine aswers
:)
Peace Out Buddy

Posted 30-Jan-14 19:14pm

Member 10562032