如何获取webservice(数据集)结果为textbox.text? [英] How to get webservice (dataset) result as textbox.text?

问题描述

我想问一下如何获取Web服务结果(我将其返回值设置为Dataset，但不是必须的.如果有必要，我也可能将其返回为String或Datatable)作为文本框(textbox.text)中的值或标签?

我将此作为我的网络服务(例如)

Hi,
I wanted to ask on how to get webservice result ( i made it return value as Dataset, but it''s NOT must. I might be return it as String or Datatable too if it necessary) as value in textbox (textbox.text) or label?

I have this as my webservice ( for example )

<WebMethod()> _
   Public Function AmbilBuku() As Dataset
       Dim conn As String
       conn = "server=localhost;uid=root;pwd=;database=uptbahasa"

       Dim sql As String = "Select * from buku

       Dim konek As New MySqlConnection(conn)
       Dim OdbcDa As New MySqlDataAdapter(sql, conn)
       konek.Open()
       Dim ds As New DataSet
       OdbcDa.Fill(ds)
       Return ds
   End Function

然后，我将查询结果作为数据集返回，并抛出一些类似这样的结果(如果我通过浏览器进行浏览).

From that I return the query result as dataset, and will throw me some result like this (if I browse it through browser).

<dataset>>
	<xs:schema id="NewDataSet">
	<xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
		<xs:complexType><xs:choice minOccurs="0" maxOccurs="unbounded">
			<xs:element name="Table">
				<xs:complexType>
					<xs:sequence>
						<xs:element name="id" type="xs:int" minOccurs="0"/>
						<xs:element name="username" type="xs:string" minOccurs="0"/>
						<xs:element name="password" type="xs:string" minOccurs="0"/>
						<xs:element name="grup" type="xs:string" minOccurs="0"/>
					</xs:sequence>
				</xs:complexType>
			</xs:element></xs:choice></xs:complexType></xs:element>
	</xs:schema>
<diffgr:diffgram>
	<NewDataSet>
		<Table diffgr:id="Table1" msdata:rowOrder="0">
			<id>1</id>
			<username>admin</username>
			<password>21232f297a57a5a743894a0e4a801fc3</password>
			<grup>administrator</grup></Table>
		<Table diffgr:id="Table2" msdata:rowOrder="1">
		<id>11</id>
		<username>Yoyo</username>
		<password>48dc8d29308eb256edc76f25def07251</password>
		<grup>operator</grup>
		</Table>
</NewDataSet>
</diffgr:diffgram>
</DataSet>

我的问题是如何在Windows窗体中获取例如ID和用户名作为textbox.text?

提前非常感谢.

My question is how to get for example ID and Username as textbox.text in my windows form?

Thanks a lot in advance.

推荐答案

感谢大家，我已经完成了.

我是怎么做到的

在FOR LOOP上，我使用以下代码:
ds.tables(0).rows(0).item(i).tostring

现在，我面临有关如何在Smartdevice中创建报告的新问题.我需要的报告就像交易的结果(就像在PoS软件中一样).

有人知道吗?

Thanks everyone, I had it finished.

This how I do it

on the FOR LOOP I use this :
ds.tables(0).rows(0).item(i).tostring

Now I facing new problem, on how to create Report in Smartdevice. The report I need is just like the result of transactions (just like in PoS software).

Anyone know?

return ctype(ds, dataset)

这迫使它成为数据集，而不是差异图数据集

This forces it to be a dataset rather than being a diffgram dataset

这篇关于如何获取webservice(数据集)结果为textbox.text?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！