Working with database in C#

Question

5.00/5 (1 vote)

See more:

Hello, i am trying to create application using database, can you please explain me easiest way to create a simple database with 2 tables and 1 relation between them and how to connect to that database using C# and do some basic query like

C#

"SELECT x FROM table WHERE ID==10"

Thank you

Posted 7-Jan-12 11:30am

kluni

Updated 8-Jan-12 4:37am

v3

Add a Solution

5 solutions

Solution 5

Hi,
For beginners Ado.net in C#. Follow the bellow links :

Beginners guide to accessing SQL Server through C#

Using ADO.NET for beginners

Posted 7-Jan-12 23:59pm

purnananda behera

Updated 8-Jan-12 0:08am

v2

Solution 2

Hi,

Connecting to a SQL Server Express Database with C# .NET[^]
How to Connect to an Access Database with C# .NET[^]
Datasets and Data Adapters in C# .NET[^]

Posted 7-Jan-12 17:56pm

Neha Thanka

Updated 7-Jan-12 17:59pm

v3

Solution 1

Look here:

http://msdn.microsoft.com/en-us/library/ms228366%28v=VS.80%29.aspx
http://www.codeproject.com/KB/database/sql_in_csharp.aspx

Posted 7-Jan-12 11:42am

Drazen Pupovac

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)

Sergey Alexandrovich Kryukov · Accepted Answer · 2012-01-07T18:53:00

Solution 4

I would recommend this simple, clear, short an informative CodeProject article for beginners: Using ADO.NET for beginners[^].

—SA

Posted 7-Jan-12 18:53pm

Sergey Alexandrovich Kryukov

Comments

Mehdi Gholam 8-Jan-12 1:31am

5'ed

Sergey Alexandrovich Kryukov 8-Jan-12 12:55pm

Thank you, Mehdi. All credit goes to the author of the article though.
--SA

Uday P.Singh 8-Jan-12 4:26am

5ed :)

Sergey Alexandrovich Kryukov 8-Jan-12 12:55pm

Thank you, Uday. All credit goes to the author of the article though.
--SA

Monjurul Habib 8-Jan-12 6:17am

5!

Sergey Alexandrovich Kryukov 8-Jan-12 12:55pm

Thank you, Monjurul. All credit goes to the author of the article though.
--SA

Tanzy123 9-Jan-12 1:28am

Great Article..
+5..

Sergey Alexandrovich Kryukov 9-Jan-12 14:36pm

Thank you Tanzy; all credit to its author; the article is very helpful.
--SA

Wendelius 9-Jan-12 14:22pm

Good link, my 5. And congrats for the MVP! :)

Sergey Alexandrovich Kryukov 9-Jan-12 14:35pm

Thank you very much, Mika.
--SA

Sergey Alexandrovich Kryukov 9-Jan-12 14:42pm

I recently looked at your profile and saw your MVP 2009, was surprised why not 2012 which you well deserve.
Two minutes later your profile page was updated with MVP 2012. My congratulations!
--SA

Wendelius 9-Jan-12 15:02pm

Thanks SA :)

raaaafe 16-Apr-12 3:46am

5ed

Sergey Alexandrovich Kryukov 16-Apr-12 11:29am

Thank you.
--SA

uspatel · Accepted Answer · 2012-01-07T18:20:00

Solution 3

if you want to create database using C#,see this
Create a SQL Server Database
use ADO.net for database connectivity
ADO.Net

otherwise sql server mgmt. studio is easiest way to create database and tables.
see this http://www.sqlserver2005tutorial.com/

Posted 7-Jan-12 18:20pm

uspatel

Comments

Mehdi Gholam 8-Jan-12 1:31am

5'ed

uspatel 8-Jan-12 6:42am

thanks......

Uday P.Singh 8-Jan-12 4:25am

5ed :)

uspatel 8-Jan-12 6:42am

thanks.....

Sergey Alexandrovich Kryukov 8-Jan-12 12:56pm

Right, a 5.
--SA