Binding text boxes to SQL Statements

[Pzykotik]

So I've changed this post entirely as the first question was stupid and I figured it out... So, now I've got my dataset filled with a table:

    Public Function FillDataset()

        Dim connection As SqlCeConnection
        Dim command As SqlCeCommand
        Dim dataAdapter As SqlCeDataAdapter
        Dim dataSet As DataSet

        connection = New SqlCeConnection("data source=dir1")

        command.CommandText = "SELECT * FROM tblDealer"
        command.Connection = connection

        dataAdapter = New SqlCeDataAdapter(command)
        dataAdapter.Fill(dataSet)

        Return True
    End Function

Is it possible to put some text boxes on my form and run SQL Select statments on them to display data from a dataset? I'm reading something about datagrids but I wanted to just use text boxes (and then update statements on buttons later)

Thanks a bunch

[Pzykotik]

Ok, so I'm reading loads about how this can be done but it all seems to complicated! I'm obviously not very good at this whole vb.NET CF thing... =( There has to be a simple way of going about it!?

Anybody...?

[sapator]

Never tried it but on the databindings properties of the textbox supposedly you can bing your data. Althought it's very simpe compared to .net windows applications. Give it a try

[petevick]

Hi,
this quick start sample shows how to bind a text box using an XML file as a source - this should get you started.

The site has quite a few compact framework samples with source code - it may be worth you having a look at them to help get you started.

Pete