Question

错误 1 “System.Data.SqlClient.SqlConnection”不包含“CreatCommand”的定义

错误 1 “System.Data.SqlClient.SqlConnection”不包含“CreatCommand”的定义，并且找不到可接受类型为“System.Data.SqlClient.SqlConnection”的第一个参数的扩展方法“CreatCommand”(是否缺少 using 指令或程序集引用?) F:\ack\test\DatarReaderExample\DatarReaderExample\DataReaderExample.cs 14 56 DatarReaderExample

代码来源C#入门经典 调不通呀！
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;

class DataReaderExample
{
public static void Main()
{
SqlConnection thisConnection = new SqlConnection(@"Data Source(192.168.10.111);Integrated Security=SSPI;" + "Initial Catalog=CRJY");
//Open connection
thisConnection.Open();
//Create command for this connection
SqlConnection thisCommand = thisConnection.CreateCommand();
//Specify Sql query for this Command
thisCommand.CommandText= "SELECT UnitCode,ClassName from Classes";
SqlDataReader thisReader=thisCommand.ExecuteReader();
while(thisReader.Read())
{
Console.WriteLine("\t{0}\t{1}",thisReader["UnitCode"],thisReader["ClassName"]);

}
thisReader.Close();
thisConnection.Close();
}
}

Answer 1

SqlConnection thisCommand = thisConnection.CreateCommand();
修改为
SqlCommand thisCommand = thisConnection.CreateCommand();

Answer 2

天誉做的不错