OracleCommandCommandText属性.doc

第三种：利用OracleCommand的CommandText属性 ?OracleCommand?myConnection?=?new?OracleCommand();?Comm.Connection?=?myConnection;?Comm.Transaction?=?myConnection.BeginTransaction();?Comm.CommandText?=?select?*?from?table;?Comm.ExecuteNonQuery();?Comm.Transaction.Commit(); ? 2.3 HYPERLINK /salonliudong/admin/数据库的例子/使用ADO.NET操作Oracle数据库/WindowsApplication1/WindowsApplication1.sln 事务的操作。Commit,rollback //连接数据库并打开string?myConnString?=” Password=microsoft;Persist Security Info=false;User ID=scott;Data Source=orcl；Integrated Security=true” ; OracleConnection?myConnection?=?new?OracleConnection(myConnString);myConnection.Open();{???????//创建事务???????OracleTransaction?myTransaction?=?myConnection.BeginTransaction();???????OracleCommand?myocmd?=?new?OracleCommand(,?myConnection);???????myocmd.Transaction?=?myTransaction;???????try????????{?????????????//语句块???????????????myTransaction.Commit();????????}????????catch?(Exception?ex)????????{??????????????MessageBox.Show(ex.Message);???????????????myTransaction.Rollback();????????}????????finally????????{??????????????myConnection.Close();????????}?????} 2.4从数据表中读取图片数据 HYPERLINK /salonliudong/admin/数据库的例子/使用ADO.NET操作Oracle数据库/WindowsApplication1/WindowsApplication1.sln 从数据库中取一个图片数据，用二进制数组来存储，然后将其显示在指定的控件上。 byte[]?tmpImage?=?(byte[])curRow[Pic];//?fileLength是数组的长度（图片的大小）和curImageFormat图片格式。fileLength?=?tmpImage.Length;MemoryStream?curStream?=?new?MemoryStream(tmpImage);picPersonel.Image?=?Image.FromStream(curStream);curImageFormat?=?picPersonel.Image.RawFormat; ? 2.5 命令参数的创建和使用 创建命令参数 private?OracleParameter?CreateOraParam(string?ParamName,?object?ParamValue){????OracleParameter?Result?=?new?OracleParameter();?????Result.ParameterName?=?ParamName;?????if?(ParamValue?!=?null)??????{???????????Result.Value?=?ParamValue;??????}??????else??????{???????????Result.Value?=?DBNull.Value;??????}??????Result;} 这样的话，当要对数据库操作时就可以运用了： insertComm.CommandText?=?insert?into?TESTADODOTNET?(ID)?values?(:pID