错误提示如下:程序大体如下:
private OracleConnection m_Connection; //数据库连接
private OracleCommand m_Command; //数据库操作
m_Connection = new OracleConnection(strConnectString);
m_Command = m_Connection.CreateCommand();
m_Command.CommandText = i_strSQL;
m_Command.Connection.Open(); //这里出错了
intCount = m_Command.ExecuteNonQuery();
再请教OracleConnection和OracleCommand,怎么用呢?
能不能给个简单的例子谢谢了!!
private OracleConnection m_Connection; //数据库连接
private OracleCommand m_Command; //数据库操作
m_Connection = new OracleConnection(strConnectString);
m_Command = m_Connection.CreateCommand();
m_Command.CommandText = i_strSQL;
m_Command.Connection.Open(); //这里出错了
intCount = m_Command.ExecuteNonQuery();
再请教OracleConnection和OracleCommand,怎么用呢?
能不能给个简单的例子谢谢了!!
"Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.123)(PORT=1521)))(CONNECT_DATA=(SID=orcl)(SERVER=DEDICATED)));User ID=user01;Password=123;Unicode=true"第二种
"Data Source=10.8.9.123/orcl;User ID=xsekt2;Password=123;Unicode=true"
<appSettings>
<add key="ConnectionString" value="Data Source=csugra;User ID=xjmu_yjsy;Password=123456"></add>
</appSettings>程序里调用
OracleConnection cn = new OracleConnection(ConfigurationSettings.AppSettings["ConnectionString"].ToString()); /// <summary>
/// 这是一个执行SQL语句的方法,它是连接状态下的返回受影响的行数
/// </summary>
/// <param name="sqlstr">要执行的SQL语句</param>
/// <returns>返回受影响的行数如果为0则表示执行失败!</returns>
public int F_Jcsj_ExecConnamd(string sqlst)
{
int i=0;
OracleCommand cmd=new OracleCommand(sqlst,cn);
try
{
cn.Open();
i=cmd.ExecuteNonQuery();
cn.Close();
F_Datawritelog(sqlst,"成功");
}
catch(Exception ex)
{
if(cn.State==ConnectionState.Open)
cn.Close();
F_Datawritelog(ex.Message+"\n"+sqlst,"失败");//写日志
}
return i;
}
public void InsertRow(string connectionString)
{
string queryString =
"INSERT INTO Dept (DeptNo, Dname, Loc) values (50, 'TECHNOLOGY', 'DENVER')";
using (OracleConnection connection = new OracleConnection(connectionString))
{
OracleCommand command = new OracleCommand(queryString);
command.Connection = connection;
try
{
connection.Open();
command.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
参考: MSDN
是你用oracle客户端注册的连接名称
跟sql不一样
ConfigurationManager.AppSettings[""].ToString();
string constring = "Data Source=myoracle;User Id=sys;Password=123;"
using(OracleConnection conn = new OracleConnection(constring ))
{
conn.Open();
}
http://topic.csdn.net/u/20091005/14/b54f7e21-ed75-46a6-bbb4-a5bf1db8a946.html