Question

C#中如何添加删除记录

connectionString=.....
OracleConnection con = new OracleConnection(connectionString);
OracleCommand cmd = new OracleCommand("select * from a");
cmd.Connection = con;
con.Open();
(这里在oracle数据库里添加记录,怎么添加?a表中有两个栏位,分别为:NAME,AGE,我想添加一条 NAME=小李 AGE=26 的记录)

OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{

(如果数据库里的NAME栏位为空,则删除该记录)

}
你按我的提问来好不好,name栏位和age栏位分两步添加记录,不要写到一起,我好看懂些
照顾一下新手.还有,cmd.ExecuteNonQuery(); 什么意思?

Answer 1

添加:
cmd.CommandText = "Insert into a values('小李','26')";
cmd.ExecuteNonQuery();
删除:
cmd.CommandText = "delete from a";
cmd.ExecuteNonQuery();

Answer 2

好像不用这样吧.. 一条SQL语句就能办到了..
Delete from a where name='' or name=null

Answer 3

cmd=new sqlcommand( "Insert into a values('小李','26')",sqlcon)

"delete from a"

Answer 4

cmd.ExecuteNonQuery();的意思是执行SQL语句并返回影响到的数据行数。

Answer 5

这个是数据库的功能