VB.Net中怎么将一个数据集返回？

[bafenghan]

我新建一个WebService,自己写了个函数
<WebMethod()> Public Function ReturnValue(byval TempStr as string)--函数返回类型是什么？
Dim CmdStr As String
Dim StrSQL As String
StrSQL = "Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;"
Dim Conn As New SqlConnection(StrSQL)
CmdStr = "select * from customers where customerID=" & TempStr
Dim ADO As New SqlCommand(CmdStr)
ADO.Connection = Conn
Conn.Open()
ADO.ExecuteNonQuery()
ADO.Connection.Close()
End Function

我希望能将select出来的记录集返回给调用的客户端，函数类型应该是什么呢？怎么返回？我刚刚开始用.net，不知道怎么实现啊！
哪位帮帮忙！谢谢了！

[earlsen]

up

[3tzjq]

<WebMethod()> Public Function ReturnValue(byval TempStr as string) As DataTable'还可以是|DataSet|Object
Dim CmdStr As String
Dim StrSQL As String
StrSQL = "Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;"
Dim dt as new DataTable
dim oda as new OleDbDataAdapter("select * from customers where customerID=" & TempStr,StrSQL)
oda.Fill(dt)

Return dt
End Function

[killerliu]

么错拉，返回datatable就好了