Click here to Skip to main content
15,921,622 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: My code is showing syntax error in insert into statement can you please help me with a solution guys Pin
Richard MacCutchan31-Oct-18 6:54
mveRichard MacCutchan31-Oct-18 6:54 
Questionvisual zkteco Pin
Member 1402998229-Oct-18 11:38
Member 1402998229-Oct-18 11:38 
AnswerRe: visual zkteco Pin
Richard MacCutchan30-Oct-18 5:21
mveRichard MacCutchan30-Oct-18 5:21 
QuestionHow to create an custom error message box , that I can used for all my forms using vb.net Pin
Member 140121708-Oct-18 8:48
Member 140121708-Oct-18 8:48 
AnswerRe: How to create an custom error message box , that I can used for all my forms using vb.net Pin
Mycroft Holmes8-Oct-18 11:31
professionalMycroft Holmes8-Oct-18 11:31 
AnswerRe: How to create an custom error message box , that I can used for all my forms using vb.net Pin
JR21211-Oct-18 10:35
JR21211-Oct-18 10:35 
QuestionHow to add a contact in google contacts from vb 2010 Pin
_nixz_7-Oct-18 22:04
_nixz_7-Oct-18 22:04 
AnswerRe: How to add a contact in google contacts from vb 2010 Pin
Richard MacCutchan7-Oct-18 22:57
mveRichard MacCutchan7-Oct-18 22:57 
GeneralRe: How to add a contact in google contacts from vb 2010 Pin
_nixz_9-Oct-18 3:06
_nixz_9-Oct-18 3:06 
QuestionCreating random access file with visual basic.net Pin
Member 139824717-Oct-18 11:48
Member 139824717-Oct-18 11:48 
AnswerRe: Creating random access file with visual basic.net Pin
Richard MacCutchan7-Oct-18 21:57
mveRichard MacCutchan7-Oct-18 21:57 
QuestionProblem with System.Text.Encoding, Solved Pin
mo14923-Oct-18 11:58
mo14923-Oct-18 11:58 
AnswerRe: Problem with System.Text.Encoding, Solved Pin
Eddy Vluggen4-Oct-18 2:15
professionalEddy Vluggen4-Oct-18 2:15 
QuestionCheck for changes on Windows form Pin
wjburke22-Oct-18 11:59
wjburke22-Oct-18 11:59 
I am trying to simulate the isdirty feature from Access. I want to check and see if anything has changed so I can prompt the user to save their work or lose it. So far I have written a subroutine that backs up the data in the form. But I am having problems with the code for the compare when they try and exit. So how do I compare the data I stored in the dataset with what is on the form?

    Imports System.Data.SqlClient

    Public Class Form1
    Dim dsShiftLog As DataSet = New DataSet("ShiftLog")

   Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        Me.Shift_PrintersTableAdapter.Fill(Me.LazerMaintenanceDataSet.Shift_Printers)
        Me.Shift_LogTableAdapter.Fill(Me.LazerMaintenanceDataSet.Shift_Log)

        Backup_data(tbShift_Key.Text)

   End sub

Private Sub Backup_data(ShiftKey As Integer)

        Dim table1 As DataTable = New DataTable("shiftlog")
        Dim strSql As String = "SELECT * FROM Shift_Log WHERE Shift_Log.Shift_Key = '" & ShiftKey & "';"
        'Dim dtb As New DataTable
        Using SqlConn As New SqlConnection(My.Settings.LazerMaintenanceConnectionString)
            SqlConn.Open()
            Using da As New SqlDataAdapter(strSql, SqlConn)
                da.Fill(table1)
            End Using
            SqlConn.Close()
        End Using

        Dim table2 As DataTable = New DataTable("shiftprinters")
        strSql = "SELECT * FROM Shift_Printers WHERE Shift_Printers.Shift_Key = '" & ShiftKey & "';"
        'Dim dtb As New DataTable
        Using SqlConn As New SqlConnection(My.Settings.LazerMaintenanceConnectionString)
            SqlConn.Open()
            Using da2 As New SqlDataAdapter(strSql, SqlConn)
                da2.Fill(table2)
            End Using
            SqlConn.Close()
        End Using

        dsShiftLog.Tables.Add(table1)
        dsShiftLog.Tables.Add(table2)


    End Sub

AnswerRe: Check for changes on Windows form Pin
Eddy Vluggen2-Oct-18 21:49
professionalEddy Vluggen2-Oct-18 21:49 
SuggestionRe: Check for changes on Windows form Pin
Richard Deeming3-Oct-18 1:47
mveRichard Deeming3-Oct-18 1:47 
QuestionRe: Check for changes on Windows form Pin
dan!sh 3-Oct-18 2:09
professional dan!sh 3-Oct-18 2:09 
QuestionIndex and length must refer to a location within the string vb.net Pin
Victoryy Hisar Sitanggang2-Oct-18 4:14
Victoryy Hisar Sitanggang2-Oct-18 4:14 
AnswerRe: Index and length must refer to a location within the string vb.net Pin
Richard Deeming2-Oct-18 4:34
mveRichard Deeming2-Oct-18 4:34 
QuestionRegisterHotKey Pin
JR2122-Oct-18 1:58
JR2122-Oct-18 1:58 
AnswerRe: RegisterHotKey Pin
JR2126-Oct-18 12:53
JR2126-Oct-18 12:53 
QuestionProblems with SSLstream.Read (VB.NET/VS2017) Pin
Member 1185690428-Sep-18 21:58
Member 1185690428-Sep-18 21:58 
QuestionProblem with SHGetFolderPath(): Problem Closed. Pin
mo149228-Sep-18 11:30
mo149228-Sep-18 11:30 
AnswerRe: Problem with SHGetFolderPath(): Problem Closed. Pin
Richard MacCutchan28-Sep-18 21:45
mveRichard MacCutchan28-Sep-18 21:45 
GeneralRe: Problem with SHGetFolderPath(): Problem Closed. Pin
mo149228-Sep-18 23:44
mo149228-Sep-18 23:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.