Create a database through visual studio and manage the interaction with code written in c#

Question

0.00/5 (No votes)

See more:

, +

Hi all,

I've a problem with my project in c#, specifically with the creation of a database and the interaction with it. I would like some tips and guidelines.
Starting with the kind of db:
-)premise that the bulk of my data is quite small, wich kind of database should I create? (I prefer work with no local database, and sql server)

Let's connection with the project: how should i connect my project with the database? Could someone give me some guidelines, and some code's example?

Thanks in advance to all

Alessio

Posted 24-Aug-11 21:40pm

alessio.gastaldo

Add a Solution

1 solution

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)

OriginalGriff · Answer 1 · 2011-08-24T21:59:00

If you have SQL Server, then use an SQL server database. Unless you are going to be distributing your application, and each instance will use the DB as a standalone store, in which case SQL server is a bit overkill. Then I would use SQLCE or SQLite instead.
For SQL server databases:

C#

using (SqlConnection con = new SqlConnection(strCon))
    {
    con.Open();
    string strcmd = "SELECT fileName FROM myTable WHERE iD=@ID";
    using (SqlCommand cmd = new SqlCommand(strcmd, con))
        {
        cmd.Parameters.AddWithValue("@ID", iD);
        using (SqlDataReader r = cmd.ExecuteReader())
            {
            while (r.Read())
                {
                Console.Write((string) r["fileName"]);
                }
            }
        }
    }