爱心加油站

Question

帮帮忙，为什么排错提示说不支持关键字: “datasource”？using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;namespace UseSQLserver
{
    class Program
    {
        static void Main(string[] args)
        {
            ShowConnectionProp();
        }
        static void ShowConnectionProp()
        {
            string conStr = "DataSource=yangmingyu\\SQlEXPRESS;InitialCatalog=Students;Integrated Security=True";
            SqlConnection con = new SqlConnection(conStr);
            System.Console.WriteLine(" 数据库连接--Open()前信息：");
            System.Console.WriteLine("   ConnectionString=[{0}]", con.ConnectionString);
            System.Console.WriteLine("   ConnectionStringTimeout=[{0}]", con.ConnectionTimeout);
            System.Console.WriteLine("   DataBase=[{0}]", con.Database);
            System.Console.WriteLine("   DataSource=[{0}]", con.DataSource);
            System.Console.WriteLine("   PacketSize=[{0}]", con.PacketSize);
            System.Console.WriteLine("   StaticsEnabled=[{0}]", con.StatisticsEnabled);
            System.Console.WriteLine("   Workstationld=[{0}]", con.WorkstationId);
            System.Console.WriteLine("   State=[{0}]", con.State);
            System.Console.WriteLine();            con.Open();
            System.Console.WriteLine("数据库连接--Open()后的信息：");
            System.Console.WriteLine("  ServerVition=[{0}]", con.ServerVersion);
            System.Console.WriteLine("  State=[{0}]", con.State);
            System.Console.WriteLine();
            con.Close();
            System.Console.WriteLine("数据库连接--Close()后的信息");
            System.Console.WriteLine("   State=[{0}]", con.State);
            System.Console.Read();
        }    }
}

Answer 1

string conStr = "DataSource=yangmingyu\\SQlEXPRESS;InitialCatalog=Students;Integrated Security=True";
===========================================================string conStr = "Data Source=yangmingyu\\SQlEXPRESS;Initial Catalog=Students;Integrated  Security=True";空格哪去了？

Answer 2

string str= @"server=.\sqlexpress; integrated security=SSPI; database=msdb";Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

Answer 3

Data Source=yangmingyu\SQlEXPRESS;Initial Catalog=Students;Integrated Security=true

Answer 4

System.Console.WriteLine(" DataSource=[{0}]", con.DataSource); 
把这行注释掉看看

Answer 5

提示什么错误
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
没问题

Answer 6

你把连接字符串改成：
Data Source=.;Initial Catalog=Students;Integrated Security=True试试