Oracle for net经验.docxVIP

1. 通过DataAdapter访问数据库???????? DataAdapter有四个属性SelectCommand,DeleteCommand,InsertCommand,UpdateCommand?? ?????????? 1.1 当做检索处理的时候，执行SelectCommand的操作，返回数据集。???? // C# 例子using System;using System.Data;using System.Xml;using Oracle.DataAccess.Client;class testSample{static void Main(){???? //数据库连接打开???? OracleConnection con = new OracleConnection();???? con.ConnectionString = User Id=scott;Password=tiger;Data Source=oracle;;???? con.Open();???? Console.WriteLine(Connected Successfully);???? // Create the command??? // sql文???? OracleCommandcmd = new OracleCommand(, con);?? ???? //select statement???? string strSelectSql = SELECT STU_ID, STU_NAME, AGE, BIRTHDAY, SEX FROM TBL_STUDENT +????? WHERE? SEX = :I_SEX AND? BIRTHDAY = :I_BIRTHDAY AND AGE = :I_AGE ; ???? //command和检索sql文关联???? cmd.CommandText = strSelectSql;?? ???? //sql文中变量通过oracle参数传递?? OracleParameteroraParameter; ?? oraParameter = new OracleParameter(I_SEX,OracleDbType.Varchar2, 2);?? oraParameter.Value = 01;?? cmd.Parameters.Add(oraParameter);//字符型?? oraParameter = new OracleParameter(I_BIRTHDAY,OracleDbType.Date);//日期型?? oraParameter.Value = 1986/01/01;?? cmd.Parameters.Add(oraParameter);?? oraParameter = new OracleParameter(I_AGE,OracleDbType.Int32);?? oraParameter.Value = 20;?? cmd.Parameters.Add(oraParameter);???? DataSetdtTmp = new DataSet();???? using(OracleDataAdapterdataAdapter = new OracleDataAdapter())???? {????? dataAdapter.SelectCommand = cmd;//检索command设置????? dataAdapter.Fill(dtTmp);//检索结果保存在dtTmp数据集中???? }???? //???? Console.WriteLine(Number of rows : {0} , dtTmp.Tables[0].Rows.Count);????? // Close and Dispose OracleConnection object???? con.Close();???? con.Dispose();}1.2 ?? 如果sql文只是想count(*) 获得数据库中记录件数，可以直接使用OracleCommand.ExecuteScalar()来快速取得。?// C# 例子Cmd = new OracleCommand( SELECT COUNT(*) FROM TBL_STUDENT, Conn );Object o = Cmd.ExecuteScalar();intnRecordCount = Convert.ToInt32(o.ToString());1.3? 当做更新处理的时候，调用OracleDataAdapter的Update方法，对输入参数DataTable中每行进行循环，??? 根据当前行的状态调用相应的 INSERT、UPDATE