Search results for query: *

  • Users: jimmy1981
  • Content: Threads
  • Order by date
  1. J

    DataView

    Hi, Im trying to write a program that pulls in 3 tables from SQL Server and then checks those tables for specific values. the code below is working when i try to find an operator in the operators table: Dim dv As DataView Dim iOp As String = Mid(LineText, 5, 3)...
  2. J

    How to create an array of bytes?

    I have a bluetooth pen that I need to send an array of bytes too, can somebody offer advice on how i create an array of bytes for the following:0x68 0x00 0x02 0xFF 0x0A (in the guide this is the array of bytes I need to send)Thanks.
  3. J

    Question Problem with DataGrid

    I have added a DataGrid to my form and it seems to be working well apart from when I add a row, save the changes and then attempt to delete a row, i get a Concurrency Violation with the DeleteCommand. Any help would be much appreciated. My Code: Imports System.Data Public Class Window2...
  4. J

    Delete a record from a datasource

    I have a sample database that I am able to navigate, add new and update but I am falling over when it comes to deleting a record. Currently the user would navigate the record and then select delete, I have this code which seems to delete it from the view but when i re-load the form it is there...
  5. J

    Query Help

    Hi, I am new to SQL queries and was after some help. I have a database with fields ID, Line, StationName, StationNumber and Variant. I need to: Find the line and station from the database (from selections made from user) This will show what variants the station has attached to it. I then...
  6. J

    Saving to SQL, data is not there

    Hi, I am trying to update records in a database table, the code below adds the data correctly but when I close the form down to look in the database the data is not there, can someone tell me what I'm doing wrong? Using conn AsNew SqlCeConnection("Data Source = my connection string") ' Open...
  7. J

    add 1 to the first 3 characters of a string

    Hi, I have a barcode that once scanned returns a string 8 characters long. Further along the program I have this line of code: Mid(Header_FirstStop, 1, 3) = (Mid(Header_FirstStop, 1, 3) + 1) Eg, 00100000 I would want to then be 00200000 or eg, 01200000 would be 01300000, yet when I add...
Back
Top