请教...在C#中链接SQL2005链接不到什么原因！

Question

class Program
    {
        static void Main(string[] args)
        {
            string cString = "Data Source=.;User ID=sa;password=zaza;Initial Catalog=tempDB;";
            using (SqlConnection conn = new SqlConnection(cString))
            {
                conn.Open();
                SqlCommand comm = new SqlCommand("SELECT FirstName, LastName, HomePhone, Title FROM Employees;", conn);
                SqlDataReader reader = comm.ExecuteReader();
                using (SqlConnection conn2 = new SqlConnection(cString)) 
                {
                    conn2.Open();
                    using (SqlBulkCopy bcp = new SqlBulkCopy(conn2))
                    {
                        DataTable dt = new DataTable();
                        DataRow dr;
                        DataColumn dc;
                        bcp.DestinationTableName = "dbo.Employees_bcp";
                        dc = new DataColumn();
                        dc.ColumnName = "Last";
                        dt.Columns.Add(dc);
                        dc = new DataColumn();
                        dc.ColumnName = "First";
                        dt.Columns.Add(dc);
                        dc = new DataColumn();
                        dc.ColumnName = "HomePhone";
                        dt.Columns.Add(dc);
                        dc = new DataColumn();
                        dc.ColumnName = "Title";
                        dt.Columns.Add(dc);
                        StreamReader sr = new StreamReader(@"c:emp.txt");
                        string input;
                        while ((input = sr.ReadLine()) != null) 
                        {
                            string[] s = input.Split(new char[4]);
                            dr = dt.NewRow();
                            dr["Last"] = s[0];
                            dr["First"] = s[1];
                            dr["HomePhone"] = s[2];
                            dr["Title"] = s[3];
                            dt.Rows.Add(dr);
                        }
                            sr.Close();
                        try 
                        {
                            bcp.ColumnMappings.Add("Last", "LastName");
                            bcp.ColumnMappings.Add("First", "FirstName");
                            bcp.ColumnMappings.Add("Title","Title");
                            bcp.ColumnMappings.Add("HomePhone","HomePhone");
                            bcp.WriteToServer(dt);
                        } 
                        catch (Exception ex)
                        {
                            Console.WriteLine(ex.Message);
                        } 
                        finally 
                        {
                            reader.Close();
                        } 
                        
                    } 
                }
            }
        }
    }
这是代码..

Answer 1

Data Source=.;User ID=sa;password=zaza;Initial Catalog=tempDB;查查这句, Data Source=.
. 是什么?

Answer 2

在我感觉还是在web.config里面设置数据库的链接哦
    
<appSettings>
    <add key="SQLConn" value="server=.;database=centerLF;UID=sa;PWD=1111"></add>
    <add key="SQLConnCIS" value="server=.;database=cisdb;UID=sa;PWD=1111"></add>
</appSettings>
具体用到数据链接的界面：
 SqlConnection cn = new SqlConnection((string)Page.Cache["SQLConn"] + ";Pooling=true;Connection Reset=false;Connection Lifetime=30;Min Pool Size=3");

Answer 3

在我感觉还是在web.config里面设置数据库的链接哦
    
<appSettings>
    <add key="SQLConn" value="server=.;database=centerLF;UID=sa;PWD=1111"></add>
    <add key="SQLConnCIS" value="server=.;database=cisdb;UID=sa;PWD=1111"></add>
</appSettings>
具体用到数据链接的界面：
 SqlConnection cn = new SqlConnection((string)Page.Cache["SQLConn"] + ";Pooling=true;Connection Reset=false;Connection Lifetime=30;Min Pool Size=3");

Answer 4

web.config?    <connectionStrings>
        <add name="cString" connectionString="Data Source=.;User ID=sa;password=zaza;Initial Catalog=tempDB"
            providerName="System.Data.SqlClient" />
    </connectionStrings>

Answer 5

string conText = @"database=demo;server=yueluo\sqlexpress;Integrated Security=SSPI";
                   数据库名=demo; 服务器=服务器名称；Integrated Security=SSPI      服务器=服务器名称主要是这句话的设置！sql2005 ，测试过了，保证可用！

Answer 6

参看：http://www.connectionstrings.com我想你不该是连TempDB吧，默认地，该数据库没这个表。