C#

string[] Temp = new string[20];
Array.Copy(MyItems, 0, Temp, 0, MyItems.Length);
MyItems = new string[20] {};
Array.Copy(Temp, 0, MyItems, 0, Temp.Length);
Array.Clear(Temp, 0, Temp.Length);
Temp = null;

// Reallocates an array with a new size, and copies the contents
// of the old array to the new array.
// Arguments:
//   oldArray  the old array, to be reallocated.
//   newSize   the new array size.
// Returns     A new array with the same contents.
public static System.Array ResizeArray (System.Array oldArray, int newSize) {
   int oldSize = oldArray.Length;
   System.Type elementType = oldArray.GetType().GetElementType();
   System.Array newArray = System.Array.CreateInstance(elementType,newSize);
   int preserveLength = System.Math.Min(oldSize,newSize);
   if (preserveLength > 0)
      System.Array.Copy (oldArray,newArray,preserveLength);
   return newArray; 
}

<br />
/// <summary><br />
		/// Function to add an array element to a dynamic Array<br />
		/// </summary><br />
		/// <param name="Arr">Dynamic Array</param><br />
		/// <param name="Element">Element to add to the dynamic array</param><br />
		/// <returns>array with the element appended to it</returns><br />
		public static Array RedimNPreserve(int[] Arr,int Element)<br />
		{<br />
			System.Collections.ArrayList al = new System.Collections.ArrayList();<br />
			int i;<br />
			if(Arr!=null)<br />
			{<br />
				for(i=0;i<=Arr.GetUpperBound(0);i++)<br />
				{<br />
					al.Add(Arr[i]);<br />
				}<br />
			}<br />
			al.Add(Element);<br />
			return al.ToArray(typeof(int));<br />
		}

Data Source=schema name;User Id=user name;Password=password"

string sql = "UPDATE Table SET Field1 = :p_Field1 WHERE Field2 = :p_Field2";  // Note the colons to specify parameters
 
OracleCommand cmd = new OracleCommand(sql, conn);
 
cmd.Parameters.Add("p_Field1", someValue);  // Note that there is no colon
cmd.Parameters.Add("p_Field2", someOtherValue);
 
cmd.ExecuteNonQuery();