Command

 

1.  无参数构造函数SqlCommand()

SqlCommand scmd = new SqlCommand();

scmd.Connection = sconn;

scmd.CommandText = "select * from product";

2.  有参数构造函数SqlCommand(“SQL命令”,连接对象);

SqlCommand scmd = new SqlCommand("select * from product",sconn);

3.使用Connection对象的CreateCommand()方法创建Command对象，无参数 。

SqlConnection sconn= new SqlConnection("Server=(local);Initial Catalog=sales;Uid=sa;Pwd=123456;");

SqlCommand scmd = sconn .CreateCommand ();

scmd.CommandText = "select * from product";

二、ExecuteNonQuery方法 知识点

ExecuteNonQuery方法 举例：

例1：使用Command对象执行insert语句

string str="insert into product(productid,productname)values('"+this .TextBox1 .Text .Trim ()+"' ,'"+TextBox2 .Text .Trim ()+"')";

SqlCommand insert = new SqlCommand(str,conn );

insert.ExecuteNonQuery();

例2：使用Command对象执行update语句

  string str = "update product set productname='"+TextBox2 .Text .Trim ()+"' where productid='"+TextBox1 .Text .Trim ()+"'";

SqlCommand update = new SqlCommand(str, conn);

update.ExecuteNonQuery();

例3：使用Command对象执行delete语句

string str ="delete from product where productid='" + TextBox1.Text.Trim() + "'";

SqlCommand delete = new SqlCommand(str, conn);

delete.ExecuteNonQuery();