insert
```
public static void insert()
{
string connStr = "Data Source=127.0.0.1:1521;Initial Catalog=orcl;User ID=scott;Pwd=tiger";
using (SqlConnection conn = new SqlConnection(connStr))
{
string sql = "insert into emp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values(1260,'Tom_cat','JVM',7369,to_date('2002-08-26','yyyy-mm-dd'), 9999, 568, 30)";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
conn.Open();
//cmd.EndExecuteNonQuery() insert/delete/update返回影响行数
//cmd.ExecuteScalar() 返回单个结果，如：count() sum()等
//cmd.ExecuteReader() 当查询出多行多列结果的时候使用
int num = cmd.ExecuteNonQuery();
Console.WriteLine("成功插入{0}行数据", num);
}
}
Console.ReadKey();
}
```
