当前位置:我的异常网» C# » C#程序和oracle解决方法
C#程序和oracle解决方法
www.myexceptions.net 网友分享于:2014-08-28 浏览:1次
C#程序和oracle
别人写的一个连接oracle的程序,然后我测试能否运行,我该在oracle中创建那些数据表呢?
程序如下:using (CoreLab.Oracle.OracleConnection objConn = new CoreLab.Oracle.OracleConnection(ConfigurationManager.AppSettings["connectionString"]))
{
CoreLab.Oracle.OracleTransaction trans = null;
try
{
objConn.Open()
trans = objConn.BeginTransaction();
string sql = "select DataID from system.SSJ_Data where ServerName=:ServerName and FileName=:FileName";
CoreLab.Oracle.OracleCommand objCmd = objConn.CreateCommand();
objCmd.Transaction = trans;
objCmd.CommandText = sql;
objCmd.CommandType = CommandType.Text;
objCmd.Parameters.Add(":ServerName", ServerName);
objCmd.Parameters.Add(":FileName", Path.GetFileName(p));
//CoreLab.Oracle.OracleDataReader objDR = objCmd.ExecuteReader();
int dataID = int.MinValue;
object objResult = null;
objResult = objCmd.ExecuteScalar();
if (objResult != DBNull.Value && objResult != null)
{
dataID = int.Parse(objResult.ToString()); }
objCmd.Parameters.Clear();
bool isInserted = false;
if (dataID == int.MinValue)
文章评论