Ventuz之連接配接資料[用C#腳本]

接口Json格式資料

string uri = url;//此處的Url就是接口位址，在外部C#腳本傳進來的。
		HttpWebRequest request = (HttpWebRequest) WebRequest.Create(uri);
		request.Proxy = null;
		request.KeepAlive = false;
		request.Method = "GET";
		request.ContentType = "application/json; charset=UTF-8";
		request.AutomaticDecompression = DecompressionMethods.GZip;
		HttpWebResponse response = (HttpWebResponse) request.GetResponse();
		Stream myResponseStream = response.GetResponseStream();
		StreamReader myStreamReader = new StreamReader(myResponseStream, Encoding.UTF8);
		string str = myStreamReader.ReadToEnd();//Json資料
		Root root = JsonConvert.DeserializeObject<Root>(str);
		//以下就是擷取值的操作，舉1：
		L30 = root.resources.rwayOperation.westHalfHourCnt.ToString();
		//關閉操作
		myStreamReader.Close();
		myResponseStream.Close();
		if (response != null)
		{
			response.Close();
		}
		if (request != null)
		{
			request.Abort();
		}
		//一定要加的一個步驟，隻有加了才會重新整理資料。要不然隻會是第一個值
		changed = true;
		
		//還要建相對應的實體類
	    public class Root
	    {
		     public Resources resources { get; set; }
	    }
           

Oracle資料庫自查擷取資料

OracleConnection con = new OracleConnection(conStr);//conStr:資料庫連接配接位址
		con.Open();
		OracleCommand cmd = con.CreateCommand();
		cmd.CommandText = "select * from table_1";
		OracleDataReader o1 = oCommand.ExecuteReader();
		//按照正常邏輯，我這邊數不能寫死的。但是V不能自動生成控件，是以隻能預置。
		//查詢一組數組
		for (int i = 0; i < 21; i++)
		{
			while (o1.Read())
			{
			bigname1[i] = o1.GetString(0);
			break;
			}
		}		
		o1.Close();
		//查詢單一值
		//bigname1 = o1.GetString(0);
		con.Dispose();
		changed = true;