รบกวนสอบถามเรื่อง.NET Smart Device เขียนโปรแกรมบน HandHeld

    <WebMethod()> _
    Public Function GetLocation() As DataSet
        SQLCmd = ""
        SQLCmd = "select loc_id from dhlit.tbl_rtvloc where loc_status = 'ACTIVE' and loc_id not in (select loc_id from dhlit.tbl_rtvstock) order by loc_id"
        CMD = New OracleCommand(SQLCmd, ConDB)
        ADP = New OracleDataAdapter(CMD)
        ConDB.Open()
        ADP.Fill(DBSet, "Info")
        ConDB.Close()
        If CInt(DBSet.Tables(0).Rows.Count) > 0 Then

            Return DBSet
        Else
            Return Nothing
        End If
    End Function

Public RTVService As New RTVService.Service1
    Private Sub RTVMovetoDockDoor_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        BindDataGrid()
    End Sub
    Private Sub BindDataGrid()
        Dim datatest As New DataSet
        datatest = RTVService.GetLocation()

        Dim tableStyle As New DataGridTableStyle()
        tableStyle.MappingName = datatest.Tables("Info").TableName

        Dim column As New DataGridTextBoxColumn()
        column.MappingName = "loc_id"
        column.HeaderText = "Location"
        column.Width = 100
        tableStyle.GridColumnStyles.Add(column)

        'column = New DataGridTextBoxColumn()
        'column.MappingName = "name"
        'column.HeaderText = "Name"
        'column.Width = 40
        'tableStyle.GridColumnStyles.Add(column)

        'column = New DataGridTextBoxColumn()
        'column.Width = 70
        'column.MappingName = "email"
        'column.HeaderText = "Email"
        'tableStyle.GridColumnStyles.Add(column)

        Me.DataGrid1.DataSource = datatest.Tables(0)

        Me.DataGrid1.TableStyles.Clear()
        Me.DataGrid1.TableStyles.Add(tableStyle)

        datatest = Nothing

    End Sub