using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        DataSet myDataSet = new DataSet();
        public Form1()
        {
            InitializeComponent();
        }        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                string strCon = "Data Source=localhost;Initial Catalog=DB123456;Integrated Security=True";
                SqlConnection myConn = new SqlConnection(strCon);
                string strCom = "SELECT * FROM DB123456";
                myDataSet = new DataSet();
                myConn.Open();
                SqlDataAdapter myCommand = new SqlDataAdapter(strCom, myConn);
                myCommand.Fill(myDataSet, "DB123456");
                myConn.Close();
                statusStrip1.Text = "连接成功";
                
                            }
            catch (Exception ex2)
            {
                statusStrip1.Text = "失败";
                MessageBox.Show("失败:" + ex2.ToString(), "错误");
            }        }
    }
}

解决方案 »

  1.   

    常用的一些连接字符串(C#代码):SqlConnection conn 
    = new SqlConnection( "Server=(local);Integrated Security=SSPI;database=Pubs");SqlConnection conn 
    = new SqlConnection("server=(local)//NetSDK;database=pubs;Integrated Security=SSPI");SqlConnection conn = new SqlConnection(
    "Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Northwind;");SqlConnection conn = new SqlConnection(
    " data source=(local);initial catalog=xr;integrated security=SSPI;
    persist security info=False;workstation id=XURUI;packet size=4096; ");SqlConnection myConn  = new 
    System.Data.SqlClient.SqlConnection("Persist Security Info=False;Integrated 
    Security=SSPI;database=northwind;server=mySQLServer");SqlConnection conn = new SqlConnection( 
    " uid=sa;pwd=passwords;initial catalog=pubs;data source=127.0.0.1;Connect Timeout=900");
      

  2.   

    連接字符串參照
    http://www.connectionstrings.com/sql-server-2005
      

  3.   

    http://blog.csdn.net/fredrickhu/article/details/4961799