给你一个简单的连接数据库的方法（包括增删改差）：
public class CDataBase
{
protected OracleConnection Connection;
protected string ConnectionString;
//构造函数
public CDataBase()
{
//
ConnectionString = "Data Source=pxzx;Persist Security Info=True;User ID=jxpj;Password=jxpj;Unicode=True";
//
}
//保护方法，打开数据库连接
private void Open()
{
//判断数据库连接是否存在
if (Connection == null)
{
//不存在，新建并打开
Connection = new OracleConnection(ConnectionString);
Connection.Open();
}
else
{
//存在，判断是否处于关闭状态
if (Connection.State.Equals(ConnectionState.Closed))
Connection.Open(); //连接处于关闭状态，重新打开
}
}
//公有方法，关闭数据库连接
public void Close()
{
if (Connection.State.Equals(ConnectionState.Open))
{
Connection.Close(); //连接处于打开状态，关闭连接
}
}
/// <summary>
/// 析构函数，释放非托管资源
/// </summary>
~CDataBase()
{
try
{
if (Connection != null)
Connection.Close();
}
catch { }
try
{
Dispose();
}
catch { }
}
//公有方法，释放资源
public void Dispose()
{
if (Connection != null) // 确保连接被关闭
{
Connection.Dispose();
Connection = null;
}
}
public DataSet GetDataSetSql(string XSqlString)
{
Open();
OracleDataAdapter Adapter = new OracleDataAdapter(XSqlString, Connection);
DataSet Ds = new DataSet();
Adapter.Fill(Ds);
Close();
return Ds;
}
//公有方法，根据Sql语句，插入记录
public int Insert(string XSqlString)
{
int Count = -1;
Open();
OracleCommand cmd = new OracleCommand(XSqlString, Connection);
Count = cmd.ExecuteNonQuery();
Close();
return Count;
}
public int Update(string XSqlString)
{
int Count = -1;
Open();
OracleCommand cmd = new OracleCommand(XSqlString, Connection);
Count = cmd.ExecuteNonQuery();
Close();
return Count;
}
public int Delete(string XSqlString)
{
int Count = -1;
Open();
OracleCommand cmd = new OracleCommand(XSqlString, Connection);
Count = cmd.ExecuteNonQuery();
Close();
return Count;
}
}
需要换下你用的连接字符串。
追问还是看不懂