+++ 本例演示如何使用OracleCommand. ExecuteScalar()
protected void Page_Load(object sender, EventArgs e)
{
string connStr = "Data Source=ora9; uid=scott; pwd=tiger; unicode=true";
string sqlStr = "SELECT COUNT(*) FROM EMP WHERE EMPNO='" + "7369" + "'";
OracleConnection conn = new OracleConnection(connStr);
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = sqlStr;
cmd.CommandType = CommandType.Text;
Int32 count = Convert.ToInt32(cmd.ExecuteScalar());
if (count > 0)
{
Response.Write("OK");
}
else
{
Response.Write("ERROR");
}
conn.Close();
conn.Dispose();
cmd.Dispose();
}
+++ 说明
(1) Oraclecommand.ExecuteScalar方法返回结果中数据集的个数,主要用于用户登录;
(2) 另外,该方法返回查询结果集中的第一行第一列。可以将本例的SQL改成"SELECT * FROM EMP WHERE EMPNO='" + "7369" + "'",用OracleDataAdapter获得数据集,输出结果,试试看。
ADO.NET_第七篇_OracleCommand_03ExecuteScalar
最新推荐文章于 2021-04-15 08:07:15 发布