oracle连接数据库的方法有很多种,结合自己用到的在此持续更新记录。
方法一:
using System.Data.Odbc;
public class OracleDataClass
{
/// <summary>
/// 连接数据库的语句,可get
/// </summary>
private string connstr = "Dsn=alice;uid=scott;pwd=tiger";
public string Connstr
{
get { return connstr; }
}
/// <summary>
/// 从数据库读取数据
/// </summary>
/// <param name="sqlstr">sql语句</param>
/// <returns>返回数据集,null为发生错误</returns>
public DataSet ReadFromOracle(string sqlstr)
{
try
{
OdbcConnection conn = new OdbcConnection(connstr);
conn.Open();
OdbcDataAdapter data = new OdbcDataAdapter(sqlstr, connstr);
DataSet ds = new DataSet();
data.Fill(ds);
conn.Close();
return ds;
}
catch
{
return null;
}
}
/// <summary>
/// 向数据库写入
/// </summary>
/// <param name="sqlstr">sql语句</param>
/// <returns>返回影响的行数,负数为发生错误</returns>
public int WriteToOralce(string sqlstr)
{
int count = -1;
try
{
OdbcConnection conn = new OdbcConnection(connstr);
conn.Open();
OdbcCommand comm = new OdbcCommand(sqlstr, conn);
count = comm.ExecuteNonQuery();
conn.Close();
}
catch
{
}
return count;
}
}