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;