Click here to Skip to main content
16,007,779 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Contract specifications and DLL's and debuggers. Pin
cdansreau10-Jan-08 5:34
cdansreau10-Jan-08 5:34 
GeneralRe: Contract specifications and DLL's and debuggers. Pin
Dave Kreskowiak10-Jan-08 13:07
mveDave Kreskowiak10-Jan-08 13:07 
GeneralStill struggling with appdomain Pin
cstrader2329-Jan-08 5:35
cstrader2329-Jan-08 5:35 
GeneralExtract icon from dropdown Pin
cstrader2329-Jan-08 4:33
cstrader2329-Jan-08 4:33 
GeneralRe: Extract icon from dropdown Pin
Dave Kreskowiak9-Jan-08 4:48
mveDave Kreskowiak9-Jan-08 4:48 
GeneralRe: Extract icon from dropdown Pin
cstrader2329-Jan-08 5:30
cstrader2329-Jan-08 5:30 
GeneralRe: Extract icon from dropdown Pin
Dave Kreskowiak9-Jan-08 6:49
mveDave Kreskowiak9-Jan-08 6:49 
QuestionPlease help with Error in VB.Net Code :-( Pin
Support1239-Jan-08 3:13
Support1239-Jan-08 3:13 
Hi all,

I am using the following code:

<br />
Dim connectionString As String = "Initial Catalog=DATABASEName;Data Source=INSTANCENameIthink;Integrated Security=SSPI;"<br />
Dim cn As SqlConnection = New SqlConnection(connectionString)<br />
Dim sqlCommand As SqlCommand = New SqlCommand("SELECT * FROM StagingEmployer ORDER BY StagingDate", cn)<br />
cn.Open()<br />
Dim TestRowset As SqlDataReader = sqlCommand.ExecuteReader()<br />
<br />
While TestRowset.Read()<br />
If (Convert.ToString(TestRowset(35)) = "U") Then<br />
Dim sqlCommand2 As SqlCommand = New SqlCommand("UPDATE stagingEmployerTest SET" _<br />
+ " [Employer_Number] = '" + Convert.ToString(TestRowset(0)) _<br />
+ "', [Name] = '" + Convert.ToString(TestRowset(1)) _<br />
+ "', [Trading_Name] = '" + Convert.ToString(TestRowset(2)) _<br />
+ "', [Business_Number] = '" + Convert.ToString(TestRowset(3)) _<br />
+ "', [Company_Number] = '" + Convert.ToString(TestRowset(4)) _<br />
+ "', [Tax_File_Number] = '" + Convert.ToString(TestRowset(5)) _<br />
+ "', [Street_Address_1] = '" + Convert.ToString(TestRowset(6)) _<br />
+ "', [Street_Address_2] = '" + Convert.ToString(TestRowset(7)) _<br />
+ "', [Street_Address_3] = '" + Convert.ToString(TestRowset(8)) _<br />
+ "', [Street_Suburb] = '" + Convert.ToString(TestRowset(9)) _<br />
+ "', [Street_State] = '" + Convert.ToString(TestRowset(10)) _<br />
+ "', [Street_Postcode] = '" + Convert.ToString(TestRowset(11)) _<br />
+ "', [Street_Country] = '" + Convert.ToString(TestRowset(12)) _<br />
+ "', [Postal_Address_1] = '" + Convert.ToString(TestRowset(13)) _<br />
+ "', [Postal_Address_2] = '" + Convert.ToString(TestRowset(14)) _<br />
+ "', [Postal_Address_3] = '" + Convert.ToString(TestRowset(15)) _<br />
+ "', [Postal_Suburb] = '" + Convert.ToString(TestRowset(16)) _<br />
+ "', [Postal_State] = '" + Convert.ToString(TestRowset(17)) _<br />
+ "', [Postal_Postcode] = '" + Convert.ToString(TestRowset(18)) _<br />
+ "', [Postal_Country] = '" + Convert.ToString(TestRowset(19)) _<br />
+ "', [Contact_Name] = '" + Convert.ToString(TestRowset(20)) _<br />
+ "', [Contact_Title] = '" + Convert.ToString(TestRowset(21)) _<br />
+ "', [Contact_Salutation] = '" + Convert.ToString(TestRowset(22)) _<br />
+ "', [Phone] = '" + Convert.ToString(TestRowset(23)) _<br />
+ "', [Fax] = '" + Convert.ToString(TestRowset(24)) _<br />
+ "', [Email] = '" + Convert.ToString(TestRowset(25)) _<br />
+ "', [Broker] = '" + Convert.ToString(TestRowset(26)) _<br />
+ "', [Underwriter] = '" + Convert.ToString(TestRowset(27)) _<br />
+ "', [Diplomatic_Indemnity] = '" + Convert.ToString(TestRowset(28)) _<br />
+ "', [Status] = '" + Convert.ToString(TestRowset(29)) _<br />
+ "', [Image] = '" + Convert.ToString(TestRowset(30)) _<br />
+ "', [Created] = '" + Convert.ToString(TestRowset(31)) _<br />
+ "', [Created_By] = '" + Convert.ToString(TestRowset(32)) _<br />
+ "', [Modified] = '" + Convert.ToString(TestRowset(33)) _<br />
+ "', [Modified_By] = '" + Convert.ToString(TestRowset(34)) _<br />
+ "', [Action] = '" + Convert.ToString(TestRowset(35)) _<br />
+ "', [StagingDate] = '" + Convert.ToString(TestRowset(36)) + "'" _<br />
+ " WHERE [Employer_Number] = '" + Convert.ToString(TestRowset(0)) + "'")<br />
sqlCommand2.ExecuteScalar()<br />
End If<br />
MsgBox("Result :" + Convert.ToString(TestRowset(35)))<br />
End While<br />
<br />
<br />
' Close Reader and Connection.<br />
TestRowset.Close()<br />
cn.Close()<br />


Now the first section works fine... (the first select statement.) it returns 3 rows of data into my TestRowset.
Now why would the second section (the Update - SqlCommand2.ExecuteScalar()) give the following error:

ExecuteScalar: Connection property has not been initialized.

???

what does this mean?
I have never done anything like this from scratch so this would be my first attempt. Smile | :)

"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison

GeneralRe: Please help with Error in VB.Net Code :-( Pin
Dave Kreskowiak9-Jan-08 4:19
mveDave Kreskowiak9-Jan-08 4:19 
GeneralRe: Please help with Error in VB.Net Code :-( Pin
Support1239-Jan-08 17:36
Support1239-Jan-08 17:36 
QuestionHow to update a datagrid from a Command builder Pin
Vimalsoft(Pty) Ltd9-Jan-08 0:45
professionalVimalsoft(Pty) Ltd9-Jan-08 0:45 
AnswerRe: How to update a datagrid from a Command builder Pin
Dave Kreskowiak9-Jan-08 4:14
mveDave Kreskowiak9-Jan-08 4:14 
GeneralRe: How to update a datagrid from a Command builder Pin
Vimalsoft(Pty) Ltd9-Jan-08 4:21
professionalVimalsoft(Pty) Ltd9-Jan-08 4:21 
GeneralRe: How to update a datagrid from a Command builder Pin
Dave Kreskowiak9-Jan-08 5:02
mveDave Kreskowiak9-Jan-08 5:02 
Questionmp3 steganography Pin
thanmas9-Jan-08 0:38
thanmas9-Jan-08 0:38 
GeneralRe: mp3 steganography Pin
Dave Kreskowiak9-Jan-08 4:10
mveDave Kreskowiak9-Jan-08 4:10 
Generalsyntax highlighting in richtextbox Pin
balakpn9-Jan-08 0:32
balakpn9-Jan-08 0:32 
GeneralRe: syntax highlighting in richtextbox Pin
Dave Kreskowiak9-Jan-08 4:09
mveDave Kreskowiak9-Jan-08 4:09 
QuestionNeed Help on Delegates Pin
Senthil S8-Jan-08 23:05
Senthil S8-Jan-08 23:05 
GeneralRe: Need Help on Delegates Pin
Dave Kreskowiak9-Jan-08 4:05
mveDave Kreskowiak9-Jan-08 4:05 
GeneralMonth&Year Pin
Priya S8-Jan-08 20:23
Priya S8-Jan-08 20:23 
GeneralRe: Month&Year Pin
Christian Graus8-Jan-08 20:43
protectorChristian Graus8-Jan-08 20:43 
GeneralRe: Month&Year Pin
Priya S8-Jan-08 20:56
Priya S8-Jan-08 20:56 
GeneralHelp to add CheckBox control to the flexgrid Pin
aaraaayen8-Jan-08 19:50
aaraaayen8-Jan-08 19:50 
GeneralRe: Help to add CheckBox control to the flexgrid Pin
Dave Kreskowiak9-Jan-08 3:58
mveDave Kreskowiak9-Jan-08 3:58 

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.