Ado.net 介绍:Command对象属性-方法与示例
Ado.net的Command对象是用来执行数据库操作命令如对数据库中数据表的添加删除,记录的增加删除修改更新等.
下载写三种创建Command对象的代码示例:连接数据库请看 Ado.net 介绍:Connection对象与方法

  1. SqlConnection conn2 = new SqlConnection("Data Source=CNGOTHIC;Initial Catalog=pubs;User ID=sa;Password=gothic");
  2. conn2.Open();
  3.  
  4. string sqlcmd = "insert into jobs (job_desc,min_lvl,max_lvl) values (15,11,88)";
  5. string sqlcmd2 = "select count(*) from jobs";
  6. string sqlcmd3 = "select * from authors where au_id=@id";
  7.  
  8. 表现方式1:
  9. SqlCommand selcmd = new SqlCommand(); 
  10. selcmd.CommandText = sqlcmd;
  11. selcmd.Connection = conn;
  12.  
  13. 表现方式2:
  14. SqlCommand selcmd2 = conn.CreateCommand();
  15. selcmd2.CommandText = sqlcmd2;

Read the rest of this entry »

, , ,