C_连接SQL_Server_2005_Express的问题.doc

完就全明白了. ?using System;using System.Collections.Generic;using System.Text;using System.Data.SqlClient;using System.Data; namespace ConsoleApplication1{??? class Program??? {??????? static void Main(string[] args)??????? {??????????? // uid=sa:连接数据库的用户名为sa.??????????? // password=:连接数据库的验证密码为空.他的别名为pwd,所以我们可以写为pwd=.??????????? // initial catalog=Northwind:使用的数据源为Northwind这个数据库.他的别名为Database,本句可以写成Database=Northwind.??????????? // Server=YourSQLServer:使用名为YourSQLServer的服务器.他的别名为Data Source,Address,Addr.??????????? // Connect Timeout=30:连接超时时间为30秒.(根据情况添加)??????????? // PS:??????????? //? 1.你的SQL Server必须已经设置了需要用户名和密码来登录,否则不能用这样的方式来登录.如果你的SQL Server设置为Windows登录,那么在这里就不需要使用uid和password这样的方式来登录,而需要使用Trusted_Connection=SSPI来进行登录.??????????? //? 2. 如果使用的是本地数据库且定义了实例名,则可以写为Server=(local)\实例名;如果是远程服务器,则将(local)替换为远程服务器的名称或IP地址.??????????? string strConnection = Trusted_Connection=SSPI;;??????????? strConnection += database=NTF_Navision_enlistment60;Server=CAIXIATA-6BE823;;??????????? strConnection += Connect Timeout=30;??????????? using (SqlConnection objConnection = new SqlConnection(strConnection))??????????? {??????????????? objConnection.Open();??????????????? // method 1??????????????? SqlCommand myCommand = new SqlCommand(select * from Couse, objConnection); ??????????????? Console.WriteLine(open);??????????????? SqlDataReader myReader = myCommand.ExecuteReader();??????????????? while (myReader.Read())??????????????? {??????????????????? Console.WriteLine(myReader.GetFieldType(0));??????????????????? Console.WriteLine(myReader.GetFieldType(1));??????????????????? Console.WriteLine(myReader.GetFieldType(2));??????????????????? Console.WriteLine(myReader.GetDecimal(0));??????????????????? Console.WriteLine(myReader.GetDecimal(1));??????????????????? Console.WriteLine(myReader.GetDecimal(2));??????????????? }??????????????? myReader.Close(); ??????????????? // method 2??????????????? SqlDataAdapter myCommandd = new SqlDataAdapter(selec