目前状况:
1.oracle_net.msi已经安装
2.表结构:
表名:tbname
字段:1.aaa number 10
2.bbb nchar 50
3.代码:
using System data;
using System.Data.OracleClient;
string conn = "Data Source=data;User ID=test;Password=test"
try
{
......................(高手帮助)
}
catch
{
.......................(高手帮助)
}
1.oracle_net.msi已经安装
2.表结构:
表名:tbname
字段:1.aaa number 10
2.bbb nchar 50
3.代码:
using System data;
using System.Data.OracleClient;
string conn = "Data Source=data;User ID=test;Password=test"
try
{
......................(高手帮助)
}
catch
{
.......................(高手帮助)
}
OracleCommand cmd = new OracleCommand(sqlStr, conn);
cmd.ExecuteNonQuery();
<add key="Oraclestr" value="Data Source=;User ID=;Password="/>cs代码:
using System.Data.OracleClient;
using System.Data;public static string dbConnStr =ConfigurationSettings.AppSettings["Oraclestr"];
public System.Data.OracleClient.OracleConnection cnn;string sql = "INSERT INTO TableInfo(Tab_ID,Tab_Title) "
+ " VALUES('" + Table_ID.Text + "','" + Table_Title.Text + "')";cnn=new OracleConnection(dbConnStr);
cnn.Open();
OracleCommand myCmd = new OracleCommand(sql,cnn);
myCmd.ExecuteNonQuery();
Close();