62,046
社区成员
发帖
与我相关
我的任务
分享
DataTable dt = QueryDataTable(strSQL, commandParameters);
return dt.Rows.Count;
DataTable dt = QueryDataTable(strSQL, commandParameters);
return dt.Rows.Count > 0;
public static DataTable QueryDataTable(string strConn, string strSQL, List<OracleParameter> commandParameters = null)
{
using (OracleConnection conn = new OracleConnection(strConn))
{
OracleCommand cmd = new OracleCommand(strSQL, conn)
{
CommandType = CommandType.Text
};
//将传入的参数信息赋值给命令参数
if (commandParameters != null && commandParameters.Count > 0)
{
cmd.Parameters.AddRange(commandParameters.ToArray());
}
OracleDataAdapter oda = new OracleDataAdapter(cmd);
conn.Open();
DataSet ds = new DataSet();
oda.Fill(ds);
conn.Close();
return ds.Tables[0];
}
//var odr = (OracleDataReader)SQLCommand(strConn, strSQL, commandParameters, o => o.ExecuteReader());
//DataTable dt = new DataTable();
//dt.Load(odr);
//return dt;
}
public static int QueryDataTable(string strConn, string strSQL, List<OracleParameter> commandParameters = null)
{
using (OracleConnection conn = new OracleConnection(strConn))
{
OracleCommand cmd = new OracleCommand(strSQL, conn)
{
CommandType = CommandType.Text
};
//将传入的参数信息赋值给命令参数
if (commandParameters != null && commandParameters.Count > 0)
{
cmd.Parameters.AddRange(commandParameters.ToArray());
}
conn.Open();
int count =Convert.toInt32(cmd.ExecuteScalar());
conn.Close();
return count;
}
}
因为在sql中就返回了行数,所以调用时直接返回bool就行
直接调用 QueryDataTable()>0就行了
纯手打