Thomas7399

Hi, I have a listbox on my form that is bound to my SQL table. I have various functions to that table from my from (add rows, delete rows, edit rows). However, after I do one of these functions, the data in the SQL table updates correctly, but the listbox …

Hi, I have yet another VB question (I am a noob!). Here is my code: Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Try Dim Equip As DataRowView = ListBox1.SelectedValue Dim Equip_Delete As String = Equip.DataView.ToString MessageBox.Show(Equip_Delete) cmd = New SqlCeCommand("DELETE FROM Sensor_Table WHERE Equipment_ID = …

Hi all, I have another question. I am trying to use an update statement to update an item in a listbox. Please see below: Imports System.Data.SqlServerCe Public Class Edit_Sensor_Form ' Shared variables Dim con As SqlCeConnection = New SqlCeConnection("Data Source=C:\Users\Bryan\documents\visual studio 2010\Projects\SiteSecure v1.1\SiteSecure v1.1\Database1.sdf") Dim myDA As New SqlCeDataAdapter Dim …

Hi, I am brand new to using SQL with VB. I am trying to be able to insert data from any given row in my SQL table. The row to be inserted is selected by the user on a listbox on Form1. Here is my code: Imports System.Data.SqlServerCe Public Class …

Hi, I am trying to insert values into my local SQL database. Here is my code: Imports System.Data.SqlServerCe Public Class AddSensor ' Shared variables Dim con As SqlCeConnection = New SqlCeConnection("Data Source=C:\Users\Bryan\documents\visual studio 2010\Projects\SiteSecure v1.1\SiteSecure v1.1\Database1.sdf") Dim cmd As SqlCeCommand Dim myDA As SqlCeDataAdapter Dim myDataSet As DataSet Dim oForm1 …

Hey there, long time reader, first time post; Here is my situation: I need to search through an array of X numbers (X is going to change, so for example, one instance could be that X = 20, the next could be X = 67). I need to find how …