简介
用于执行数据库的SQL语法。
学习此类前需先了解SqlConnection类。
构造函数
SqlCommand(String cmdText, SqlConnection connection)
通过数据库指令cmdText和数据库链接connection来创建SqlCommand实例。参数后期可以通过CommandText和Connection属性来修改。
static void Main(string[] args)
{
string connectString = "server=.;database=student;User ID=lgh;Pwd=asd123";
SqlConnection connection = new SqlConnection(connectString);
string commandString = "delete from student.dbo.info";
SqlCommand command=new SqlCommand(commandString, connection);
Console.ReadKey();
}
常用属性
CommandText
获取或设置要在数据源中执行的 Transact-SQL 语句、表名或存储过程。
static void Main(string[] args)
{
string connectString = "server=.;database=student;User ID=lgh;Pwd=asd123";
SqlConnection connection = new SqlConnection(connectString);
string commandString = "delete from student.dbo.info";
SqlCommand command=new SqlCommand(commandString, connection);
Console.WriteLine("执行命令为:"+command.CommandText);
Console.ReadKey();
}
运行结果:
执行命令为:delete from student.dbo.info
Connection
获取当前sqlCommand实例的数据库连接对象。
常用方法
BeginExecuteNonQuery()
执行Sql指令,返回一个IAsyncResult类型的值,把值作为参数输入到EndExecuteNonQuery()方法中,可以完成Sql指令的异步执行,并返回一个受影响的行数。
Cancel()
取消执行Sql指令。
EndExecuteNonQuery (IAsyncResult asyncResult)
输入异步执行结果对象后,执行Sql指令,并返回受影响的行数。
static void Main(string[] args)
{
string connectString = "server=.;database=student;User ID=lgh;Pwd=asd123";
SqlConnection connection = new SqlConnection(connectString);
connection.Open();
string commandString = "create database tiger";
SqlCommand command=new SqlCommand(commandString, connection);
IAsyncResult rst=command.BeginExecuteNonQuery();
int line=command.EndExecuteNonQuery(rst);
Console.WriteLine("isComplete:"+rst.IsCompleted);
Console.WriteLine("受影响的行数:"+line);
Console.WriteLine("按下任意键退出");
Console.ReadKey();
}
ExecuteNonQuery()
执行Sql语句并返回受影响的行数,其效果等同于
IAsyncResult rst=command.BeginExecuteNonQuery();
int line=command.EndExecuteNonQuery(rst);
static void Main(string[] args)
{
string connectString = "server=.;database=student;User ID=lgh;Pwd=asd123";
SqlConnection connection = new SqlConnection(connectString);
connection.Open();
string commandString = "create database tiger";
SqlCommand command=new SqlCommand(commandString, connection);
int line=command.ExecuteNonQuery();
Console.WriteLine("受影响的行数:"+line);
Console.WriteLine("按下任意键退出");
Console.ReadKey();
}