How to connect to database in visual studio 2010 using C#.net with sqlExpress2008

Question

5.00/5 (1 vote)

See more:

HI
i want to connect the C# Application with database in visual studio 2010 with
SQL Express2008 , but i don't know how to connect,

please help me
Regards shams

Posted 3-Jul-11 8:23am

ShamsAfridi

Add a Solution

5 solutions

Solution 5

1313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313

3333333333333333333333333333333333333333333333333333333333333
33333333333333333333333333333333333333333333333333333333
131313131111111111111111111111111111111111113111111111111111111111311111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111113111111111111111111111111111111111111111111111111111111311333313131313333333333333333333333313333333333333333333333131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131313131133333333333333333333333333

Posted 18-Dec-13 20:10pm

Member 10476103

Solution 4

http://csharp-sqlconnection.blogspot.in/ visit this for easy and short code for database access

Posted 19-Nov-13 6:31am

Kannannns

Comments

CHill60 19-Nov-13 18:35pm

Very badly formatted blog I'm afraid, and doesn't really add to the solutions posted 2 years ago

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)

Uday P.Singh · Accepted Answer · 2011-07-03T08:29:00

Solution 1

check these out:

http://csharp.net-informations.com/data-providers/csharp-sql-server-connection.htm[^]

Beginners guide to accessing SQL Server through C#[^]

http://www.homeandlearn.co.uk/csharp/csharp_s12p3.html[^]

hope this helps :)

for code related queries comment here!!

Posted 3-Jul-11 8:29am

Uday P.Singh

RaviRanjanKr · Accepted Answer · 2011-07-03T09:13:00

hey! Uday gives you some nice links which is enough to know how to connect SQL server 2008 but if you are trying to connect your Application from Visual Studio 2010 to SQL Server by using wizard then you can follow some simple steps. take a look
a) Click on Tools menu from menu
b) click on "Connect to Database" it will open "Choose Data Source" dialog
c) select your SQL server 2008 as "Microsoft SQL Server" out of all installed Data Source on your System
e) press Continue button, after that it will give you option to put your Server name,user ID and password
so follow all steps with as a appropriate way. it will easily connect SQL server 2008 databases to you Visual Studio 2010 application.

De, Subhendu · Accepted Answer · 2011-07-03T09:13:00

private void BindData()
{
    try
    {
        string _connectionstring = @"Data Source=.\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True";
        string _sql = "SELECT * FROM [Order Details] WHERE OrderID <= 10250";
        SqlConnection _connection = new SqlConnection(_connectionstring);
        SqlCommand _command = new SqlCommand(_sql,_connection);
        SqlDataAdapter _adapter = new SqlDataAdapter(_command);
        DataTable _table = new DataTable();
        _adapter.Fill(_table);

        GridView1.DataSource = _table;
        GridView1.DataBind();
    }
    catch
    {
        throw;
    }
}