Search results for query: *

  1. J

    Question Problem Updating Database From A Bound Control

    Hi all, i have a form with 2 visible controls (a textbox and a combo box). when the form loads i create a data adapter as follows daSurveyDetail = New SqlCeDataAdapter(strSQL_Global, myConnection) daSurveyDetail.Fill(dsSurveyDetail, "dsSurveyDetail") cbSurveyDetail = New...
  2. J

    combo box valuemember

    i am trying to get the valuemember of a combo box the combo box is populated as follows Dim strSQL As String = "SELECT ageYear, ageBand from tblMobAgeBands WHERE firstGroup = 1 ORDER BY tableID" Dim objConnection As New SqlCeConnection(My.Resources.myConnection) Dim...
  3. J

    Question using OleDbCommand

    hi, i am trying to insert some data from a dataset into a database. i have used the following code that works absolutly fine. For Each dr In myDataSet.Tables(0).Rows strSQL = "INSERT INTO [~AgeBandsEmpty] (a,b,c) VALUES ('" & dr ("a") & "','" & dr ("b") & "','" & dr ("c") & "')"...
Back
Top