Click here to Skip to main content
15,917,174 members
Home / Discussions / Visual Basic
   

Visual Basic

 
Generalimaging Scanner connection through VB Pin
vash22-Jan-08 15:33
vash22-Jan-08 15:33 
Generalcodes for imaging scanner connection VB6 Pin
vash22-Jan-08 15:27
vash22-Jan-08 15:27 
Questionarray controls Pin
Agbaria Ahmad22-Jan-08 11:40
Agbaria Ahmad22-Jan-08 11:40 
GeneralRe: array controls Pin
Mycroft Holmes22-Jan-08 16:38
professionalMycroft Holmes22-Jan-08 16:38 
GeneralRe: array controls Pin
sumit703422-Jan-08 18:19
sumit703422-Jan-08 18:19 
QuestionQuick Help anyone? Pin
MUSIWA22-Jan-08 10:33
MUSIWA22-Jan-08 10:33 
AnswerRe: Quick Help anyone? Pin
pmarfleet22-Jan-08 10:56
pmarfleet22-Jan-08 10:56 
GeneralRe: Quick Help anyone? Pin
MUSIWA22-Jan-08 17:06
MUSIWA22-Jan-08 17:06 
I thought I did I thought there was an update command that I can add to my button to move the data to the database. I guess I was wrong. I am sorry if I insulted your intelligence but I am trying to learn this. Nevertheless I still need some direction. I abadon that though and now I am using an execute command see below


Dim sqlConnection1 As New System.Data.SqlClient.SqlConnection("Data Source=MUSCRIBMPC\SQLEXPRESS;Initial Catalog=adp3SQL;Integrated Security=True")
Dim fname, lname As String
fname = TextBox2.Text
lname = textbox3.text
Dim cmd As New System.Data.SqlClient.SqlCommand
cmd.CommandType = System.Data.CommandType.Text
cmd.CommandText = "update compiledpts set firstname = fname, Lastname= lname where contactid = 2"
cmd.Connection = sqlConnection1

sqlConnection1.Open()
cmd.ExecuteNonQuery()
sqlConnection1.Close()
now this stament does not work even though when I debugg the value of the textboxes have the correct values. The connection string works too. My problem is the command text is not working. Can you help me know what is wrong with it. Thanks!
GeneralRe: Quick Help anyone? Pin
pmarfleet22-Jan-08 19:51
pmarfleet22-Jan-08 19:51 
QuestionScreen saver [modified] Pin
mykingdomforanewusername22-Jan-08 6:46
mykingdomforanewusername22-Jan-08 6:46 
QuestionClick Once Deployment Pin
mia514022-Jan-08 4:41
mia514022-Jan-08 4:41 
GeneralRe: Click Once Deployment Pin
Mycroft Holmes22-Jan-08 16:46
professionalMycroft Holmes22-Jan-08 16:46 
GeneralRe: Click Once Deployment Pin
mia514023-Jan-08 4:51
mia514023-Jan-08 4:51 
QuestionHow to know the LAN connection Status. Pin
Hariharan22-Jan-08 2:37
Hariharan22-Jan-08 2:37 
GeneralRe: How to know the LAN connection Status. Pin
Justin Perez22-Jan-08 4:42
Justin Perez22-Jan-08 4:42 
QuestionMaking skin for stand alone application Pin
Jats_4ru22-Jan-08 2:07
Jats_4ru22-Jan-08 2:07 
GeneralRe: Making skin for stand alone application Pin
MatrixCoder22-Jan-08 11:58
MatrixCoder22-Jan-08 11:58 
GeneralChanging the position of a column after the data has been loaded in DataGridView Pin
David Loring22-Jan-08 2:00
David Loring22-Jan-08 2:00 
Generalproblem Use ocx in vb.Net 2005 and vista x64 Pin
hameduser22-Jan-08 1:57
hameduser22-Jan-08 1:57 
GeneralSetting Points in a Zed Graph Pin
loganj199922-Jan-08 1:53
loganj199922-Jan-08 1:53 
GeneralRe: Setting Points in a Zed Graph Pin
David Loring22-Jan-08 2:05
David Loring22-Jan-08 2:05 
GeneralRe: Setting Points in a Zed Graph Pin
loganj199923-Jan-08 13:59
loganj199923-Jan-08 13:59 
Questionhow to convert OCX from vb to that .net Pin
soniasan21-Jan-08 23:36
soniasan21-Jan-08 23:36 
AnswerRe: how to convert OCX from vb to that .net Pin
hameduser4-Feb-08 2:02
hameduser4-Feb-08 2:02 
QuestionHow to kill child threads? Pin
SimulationofSai21-Jan-08 23:00
SimulationofSai21-Jan-08 23:00 

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.