對oracle資料的的插入、更新和讀取資料

 1 private void insertIntoMes(string dayTime, string strNYCode, string strNYName, string strActWT, string strComName, string strNote)
 2     {
 3         string connectionString = ConfigurationManager.ConnectionStrings["AppDBServer"].ConnectionString;
 4         OracleConnection con = new OracleConnection(connectionString);
 5             con.Open();
 6             OracleCommand selectCmd = new OracleCommand("select * from SGPRNY01 where DATE_CODE=:v_date_CODE and NY_CODE=:v_ny_code ", con);
 7             selectCmd.Parameters.Add("v_date_CODE", dayTime);
 8             selectCmd.Parameters.Add("v_ny_code", strNYCode);
 9             OracleDataReader dr = selectCmd.ExecuteReader();
10             if (dr.Read())
11             {
12                 //string str = dr["NOTE"].ToString();這個就是來讀取裡面欄位的資訊，其實note就是表在的欄位

                   OracleCommand updateCmd = new OracleCommand("update  SGPRNY01 set NY_NAME=:v_ny_name,ACT_WT=:v_act_wt,COM_NAME=:v_com_name,NOTE=:v_note,LOAD_TM=:v_load_tm  where DATE_CODE=:v_date_CODE and NY_CODE=:v_ny_code ", con);
13                 updateCmd.Parameters.Add("v_date_CODE", dayTime);
14                 updateCmd.Parameters.Add("v_ny_code", strNYCode);
15                 updateCmd.Parameters.Add("v_ny_name", strNYName);
16                 updateCmd.Parameters.Add("v_act_wt", strActWT);
17                 updateCmd.Parameters.Add("v_com_name", strComName);
18                 updateCmd.Parameters.Add("v_note", strNote);
19                 updateCmd.Parameters.Add("v_load_tm", System.DateTime.Now);
20                 updateCmd.ExecuteNonQuery();
21             }
22             else
23             {
24                 //插入操作
25                 OracleCommand cmd = new OracleCommand("insert into  SGPRNY01(DATE_CODE,NY_CODE,NY_NAME,ACT_WT,COM_NAME,NOTE,LOAD_TM) values(:v_date_CODE,:v_ny_code,:v_ny_name,:v_act_wt,:v_com_name,:v_note,:v_load_tm)", con);
26                 //OracleCommand cmd = new OracleCommand("insert into  SGPRNY01(DATE_CODE,LOAD_TM) values(:v_date_CODE,:v_load_tm)", con);
27                 cmd.Parameters.Add("v_date_CODE", dayTime);
28                 cmd.Parameters.Add("v_ny_code", strNYCode);
29                 cmd.Parameters.Add("v_ny_name", strNYName);
30                 cmd.Parameters.Add("v_act_wt", strActWT);
31                 cmd.Parameters.Add("v_com_name", strComName);
32                 cmd.Parameters.Add("v_note", strNote);
33                 cmd.Parameters.Add("v_load_tm", System.DateTime.Now);
34                 cmd.ExecuteNonQuery();
35             }
36             con.Close();
37 }

AppDBServer是webconfig中配置的連結字串；

<connectionStrings>
        <add name="AppDBServer" connectionString="user id=dagang; data source=orcl; password=dagang" providerName="System.Data.OracleClient"/>
    </connectionStrings>

讀取的方法這常用的就是dateset和OracleDataReader，後者在上面的代碼中舉過例子了，dateset參見http://www.cnblogs.com/vieri122/archive/2009/05/04/1449108.html