Results 1 to 4 of 4

Thread: Binding text boxes to SQL Statements

Threaded View

  1. #1

    Thread Starter
    Member
    Join Date
    Aug 2007
    Location
    Nottingham
    Posts
    53

    Binding text boxes to SQL Statements

    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:

    Code:
        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
    Last edited by Pzykotik; Sep 5th, 2007 at 03:54 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width