9th
06.08
Ado.net 介绍:Command对象属性-方法与示例
Ado.net的Command对象是用来执行数据库操作命令如对数据库中数据表的添加删除,记录的增加删除修改更新等.
下载写三种创建Command对象的代码示例:连接数据库请看 Ado.net 介绍:Connection对象与方法
- SqlConnection conn2 = new SqlConnection("Data Source=CNGOTHIC;Initial Catalog=pubs;User ID=sa;Password=gothic");
- conn2.Open();
- string sqlcmd = "insert into jobs (job_desc,min_lvl,max_lvl) values (15,11,88)";
- string sqlcmd2 = "select count(*) from jobs";
- string sqlcmd3 = "select * from authors where au_id=@id";
- 表现方式1:
- SqlCommand selcmd = new SqlCommand();
- selcmd.CommandText = sqlcmd;
- selcmd.Connection = conn;
- 表现方式2:
- SqlCommand selcmd2 = conn.CreateCommand();
- selcmd2.CommandText = sqlcmd2;
Name: Cngothic 













