C#.net database application

Question

0.00/5 (No votes)

See more:

Hi all..

I am new to c#.I need to connect a small table in my c#.net project so i don't want to use SQL database.

Can any one give me a simple application which uses microsoft Access database with c#.net.

So i can store and retreive data from a small table.

please help me in this regard...

Regards

Sunit parmar

Posted 3-May-11 10:41am

sunitadit11

Updated 5-May-11 7:23am

v3

Add a Solution

Comments

AspDotNetDev 3-May-11 16:50pm

Have you considered SQL Server CE? It's a lightweight version of SQL that should already be installed on the user's computer with the .Net Framework.

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

Patrick Kalkman · Answer 1 · 2011-05-03T10:53:00

Solution 1

There are two articles here on codeproject that show you how to connect to an DB2 database from an Microsoft .Net application.

Connection to DB2 from .NET[^]
Connect to DB2 from Microsoft .NET[^]

Hope this helps.

Posted 3-May-11 10:53am

Patrick Kalkman

pt1401 · Answer 2 · 2011-05-03T11:26:00

Solution 2

SQLite

Serverless, SQL-92 compliant, tiny footprint, embedded in loads of mainstream apps including Firefox, and easily used from C#.

Just search for articles on this site for it - here's one:
[^]

Posted 3-May-11 11:26am

pt1401

anvas kuttan · Answer 3 · 2011-05-03T18:33:00

SqlConnection cs1 = new SqlConnection("Data Source=sedc;Initial Catalog=ur databasename;Persist Security Info=True;User ID=ur databaseusername;Password=ur databasepassword");
                        SqlCommand cmd1 = new SqlCommand();
                        cs1.Open();
                        cmd1.CommandText = "sql query";
                        cmd1.Connection = cs1;
                        int a = cmd1.ExecuteNonQuery();
                        cs1.Close();

eg: query: select * from usermaster
usermaster is a table in your database provided .

happy coding

Abhinav S · Answer 4 · 2011-05-05T08:00:00

Solution 4

I would recommend having a look at some tutorials on msdn etc. They should help you get started.

Posted 5-May-11 8:00am

Abhinav S