如何讀取一個webservers接口
瀏覽量：4780
有些客戶往往要求讀取一個接口中的數據，給了接口，讀取出來了，但是如何轉換成自己數據庫中的數據呢？
首先要添加Webservers, 在下面紅框中輸入Url:
1 實例化對象:
引用名. CollectionService obj=new引用名. CollectionService();
2調取方法:
System.Xml.XmlNode xml = obj.方法名("用戶名", "密碼");
3.讀取xml
DataSetds = new DataSet();
// 讀取XML字符串到XmlNodeReader中，再轉化成Dataset
XmlNodeReader reader = new XmlNodeReader(xml);
{
ds.ReadXml(reader);
}
現在已經把從接口中讀取的數據綁定到了你要綁定中的地方。
#region網站數據與遠程數據混排
if (paixu == "0")
{
foundRows = dt.Select(" " + valuelist + " ", " lzjiage " + paixutype1 + ", lzzhongliang " + paixutype2 + ", lzjingdu " + paixutype3 + " , lzyanshe " + paixutype4 + ", lzqiegong " + paixutype5 + " ");
}
if (paixu == "1")
{
foundRows = dt.Select(" " + valuelist + " ", " lzzhongliang " + paixutype2 + " ,lzjiage " + paixutype1 + " , lzjingdu " + paixutype3 + " , lzyanshe " + paixutype4 + ", lzqiegong " + paixutype5 + " ");
}
if (paixu == "2")
{
foundRows = dt.Select(" " + valuelist + " ", " lzjingdu " + paixutype3 + ", lzzhongliang " + paixutype2 + " ,lzjiage " + paixutype1 + " , lzyanshe " + paixutype4 + ", lzqiegong " + paixutype5 + " ");
}
if (paixu == "3")
{
foundRows = dt.Select(" " + valuelist + " ", " lzyanshe " + paixutype4 + " , lzjingdu " + paixutype3 + ", lzzhongliang " + paixutype2 + " ,lzjiage " + paixutype1 + " ,lzqiegong " + paixutype5 + " ");
}
if (paixu == "4")
{
foundRows = dt.Select(" " + valuelist + " ", " lzqiegong " + paixutype5 + " ,lzyanshe " + paixutype4 + " , lzjingdu " + paixutype3 + ", lzzhongliang " + paixutype2 + " ,lzjiage " + paixutype1 + " ");
}
//dt.Clear();
這樣就把數據混排到了數據庫數據中了。