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:
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)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
Thanks a bunch




Reply With Quote