In network transmission, DataSet is easy to be large, and if the amount of data is transmitted, it affects speed. The DataSet package can be placed in a multi-dimensional array in the intermediate layer, and the capacity passed will greatly decrease. A class that is discovered by the client is broken, and then bound by another control. Examples are as follows: Intermediate Public ArrayList Pro_Stock_Seek1 () {
// OracleConnection myCn = new OracleConnection ( "Data Source = STZYD; User ID = zyd; PASSWORD = www8739146; persist security info = False;"); OracleConnection myCn = new OracleConnection (Login.strConn); try {myCn.Open () ; // object [] getstr = new object [2]; ArrayList arr1 = new ArrayList (); ArrayList arr2 = new ArrayList (); ArrayList arr3 = new ArrayList (); OracleCommand MyDa = new OracleCommand ( "pro_stock_seek1", myCn) Myda.commandtype = commandtype.storedProcedure;
OracleParameter [] pa = {new OracleParameter ( "cur_recorder", OracleType.Cursor)}; pa [0] .Direction = ParameterDirection.Output; MyDa.Parameters.Add (pa [0]); OracleDataReader MyDataRead = MyDa.ExecuteReader () While (MyDataRead.Read ()) {Arr1.add (MyDataRead.GetInt32); arr2.add (myDataRead.getstring (1));} arr3.add (arr1); arr3.add (arr2);
return arr3;} catch (System.Data.SqlClient.SqlException er) {zydlogin mylog = new zydlogin (); throw mylog.GetException (er, er.Message);} finally {//myCommand.Dispose (); myCn.Close ();}} Client: Public class listbox // Package the object with a listbox to facilitate ComboBox to use {private string myshortname; private string mylongname;
Public ListBox (String strlongname, string strshortname) {
THIS.MYSHORTNAME = STRSHORTNAME; this.Mylongname = strlongname;}
Public string displaymember {get {return myshortname;}}
