C#中oracle数据库的连接方法.doc

HYPERLINK"http://www.cnblogs.com/salonliudong/archive/2006/12/04/582107.html"C#中oracle数据库的连接方法
一、关于数据库的操作1.数据库连接有2种：第一种：古老的方法（较为死板，不利于灵活操作），即用OracleConnection的类来连接stringmysqlstr="userid=xal;datasource=xal;password=xal";OracleConnectionmycnn=newOracleConnection(mysqlstr);mycnn.open();第二种：新式的方法(使用较为灵活）,即利用OracleConnectoinStringBuilder类来连接OracleConnectionStringBuilderOcnnStrB=newOracleConnectionStringBuilder;OCnnStrB.DataSource="xal";OCnnStrB.UserID="xal";OCnnStrB.Password="xal";myCnn=newOracleConnection(OCnnStrB.ConnectionString);myCnn.open();
2.事务操作myConn.open();OracleCommandinsertComm=newOracleCommand();insertComm.Connection=myCnn;insertComm.Transaction=myCnn.BeginTransaction();try{事务操作语句；insertComm.Transaction.Commit();}catch(exptionex){insertComm.Transaction.Rollback();MessageBox(ex.Message);}finally{myConn.close();}
3.创建命令参数privateOracleParameterCreateOraParam(stringParamName,objectParamValue){OracleParameterResult=newOracleParameter();Result.ParameterName=ParamName;if(ParamValue!=null){Result.Value=ParamValue;}else{Result.Value=DBNull.Value;}returnResult;}这样的话，当要对数据库操作时就可以：insertComm.CommandText="insertintoTESTADODOTNET(ID,NAME,AGE,PIC)values(:pID,:pName,:pAge,:pPic)";insertComm.Parameters.Add(CreateOraParam("pID",(txtID.Text.Trim()!="")?txtID.Text.Trim():null));insertComm.Parameters.Add(CreateOraParam("pName",(txtName.Text.Trim()!="")?txtName.Text.Trim():null));insertComm.Parameters.Add(CreateOraParam("pAge",(txtAge.Text.Trim()!="")?txtAge.Text.Trim():null));
4.数据集的浏览（例：将结果显示在comboBox1中）OracleDataAdapteroda=newOracleDataAdapter(selectCommand);DataTablenewtable=newDataTable();oda.Fill(newtable);foreach(DataRowdrinnewtable.Rows)//共有newtable.rows.count条记录{comboBox1.Items.Add(dr[0].ToString());}
5.设置输入只能是数字（例：现在往textBox1中输入。如只能输入字母的方法类似）privatevoidtextBox1_KeyPress(objectsender,KeyPressEventArgse)//属性中的事件{e.Handled=!((Char.IsNumber(e.KeyChar))||((Keys)e.KeyChar==Keys.Back));}
6.Form窗口关闭时引发的事件：弹出一个确定退出的对话框privatevoidform1_FormClosing(objectsender,FormClosingEvent