ExecuteNonQuery: Connection property has not been initialized.

Question

1.00/5 (1 vote)

See more:

Hi everyone as of now this is my code Ive done..

Dim SqlconnectionString As String = "Data Source=192.168.0.4;Initial Catalog=CYBERYA;Persist Security Info=True;User ID=cyberya;Password=Piso4minutes;MultipleActiveResultSets=True"

Using con As New SqlClient.SqlConnection(SqlconnectionString)

Dim adapter As New SqlClient.SqlDataAdapter()
adapter.InsertCommand = cmd

'--Update the original SQL table from the datatable
Dim iRowsInserted As Int64 = _
adapter.Update(dt)

End Using

Dim myconnect2 As New SqlClient.SqlConnection
myconnect2.ConnectionString = "Data Source=192.168.0.4;Initial Catalog=CYBERYA;Persist Security Info=True;User ID=cyberya;Password=Piso4minutes;MultipleActiveResultSets=True"

Try
mycommand.ExecuteNonQuery()
Catch ex As System.Data.SqlClient.SqlException
MsgBox(ex.Message)
End Try
myconnect2.Close()
MsgBox("Success")
End Sub

yet there's an error quoted: ExecuteNonQuery: Connection property has not been initialized.

in which

Line 233:
Line 234: Try
Line 235: mycommand.ExecuteNonQuery()
Line 236: Catch ex As System.Data.SqlClient.SqlException
Line 237: MsgBox(ex.Message)

i already declare my sqlconnection so i need your help here why this error comes out thanks in advance

Posted 5-Jun-13 16:11pm

Member 10033107

Updated 5-Jun-13 16:16pm

v2

Add a Solution

Comments

ZurdoDev 5-Jun-13 22:13pm

It's hard to read your code. You should click "Improve question" and add code tags. You need to set the Connection property on your SqlCommand.

[no name] 5-Jun-13 22:19pm

It means exactly what it says. You created mycommand but never associate any connection object to it. Look at your first bit of code and compare it to the second bit of code.

Member 10033107 5-Jun-13 22:20pm

so can you give any links or samples for that thing so i will fix that?? thanks for your response guys..

[no name] 5-Jun-13 22:22pm

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.aspx

3 solutions

Solution 1

You create the connection, but you never .Open() it...

Posted 5-Jun-13 16:15pm

Ron Beyer

Comments

Member 10033107 5-Jun-13 22:18pm

ooh so how is thet like conn.open??

i already did that with this command so i was wondering why is that happen with the error

Dim mycommand As SqlClient.SqlCommand = New SqlClient.SqlCommand()
mycommand.CommandText = "INSERT INTO tblsummaryImport ([id],[status],[SRN],[SrCode],[SrNumber],[CustomerName],[HomeContact],[BusinessContact],[MobileContact],[LotHouseNo],[RoomUnitStall],[BldgFloor],[BldgName],[Street],[Subdivision],[Barangay],[CityMunicipality],[Province],[Region],[Package],[PromoCode],[PaymentType],[ApplicationDate],[Endorseddate],[loanstatus],[PaymentDate],[ScheduleDate],[ActivationDate],[PCDelivery],[No.PCAvailed],[DatePCPickedUp],[SalesAgent],[Coordinator],[SalesChannel],[Salesgroup],[createdby],[timestamp]) Values(@id,@status,@srn,@customername,@homecontact,@businesscontact,@mobilecontact,@lothouseno,@roomunitstall,@bldgfloor,@bldgname,@street,@subdivision,@barangay,@citymunicipality,@province,@region,@package,@promocode,@loanstatus,@application,@paymenttype,@scheduledate,@activationdate,@pcdelivery,@nopcavailable,@datepcpickup,@salesagent,@salesgroup,@createdby,@timestamp)"
myconnect2.Open()

[no name] 5-Jun-13 22:20pm

It's there but hard to read in the unformatted code "myconnect2.Open()".

Member 10033107 5-Jun-13 22:22pm

so what will id o or alternative command i will write?? it so unusual to see this because i already stated it O.o help..guys!! im almost near to finish this ^^

Solution 2

Sorry, I didn't see the open...

Instead of creating the command directly, use the SqlConnection.CreateCommand, which automatically associates the connection with the command.

C#

SqlCommand myCommand = myconnect2.CreateCommand();
myCommand.CommandText = sql;

Posted 5-Jun-13 16:30pm

Ron Beyer

Updated 5-Jun-13 16:31pm

v2

Comments

Member 10033107 5-Jun-13 22:35pm

ron i already did what youve said to check open(); yet it works as well but an error calls out like this :Failed to convert parameter value from a String to a Int64.

Member 10033107 5-Jun-13 22:36pm

this is the code ive been working on

Dim strSql As String = "INSERT INTO tblsummaryImport ([id],[status],[SRN],[SrCode],[SrNumber],[CustomerName],[HomeContact],[BusinessContact],[MobileContact],[LotHouseNo],[RoomUnitStall],[BldgFloor],[BldgName],[Street],[Subdivision],[Barangay],[CityMunicipality],[Province],[Region],[Package],[PromoCode],[PaymentType],[ApplicationDate],[Endorseddate],[loanstatus],[PaymentDate],[ScheduleDate],[ActivationDate],[PCDelivery],[No.PCAvailed],[DatePCPickedUp],[SalesAgent],[Coordinator],[SalesChannel],[Salesgroup],[createdby],[timestamp]) Values(@id,@status,@srn,@customername,@homecontact,@businesscontact,@mobilecontact,@lothouseno,@roomunitstall,@bldgfloor,@bldgname,@street,@subdivision,@barangay,@citymunicipality,@province,@region,@package,@promocode,@loanstatus,@application,@paymenttype,@scheduledate,@activationdate,@pcdelivery,@nopcavailable,@datepcpickup,@salesagent,@salesgroup,@createdby,@timestamp)"

Dim SqlconnectionString As String = "Data Source=192.168.0.4;Initial Catalog=CYBERYA;Persist Security Info=True;User ID=cyberya;Password=Piso4minutes;MultipleActiveResultSets=True"

Using con As New SqlClient.SqlConnection(SqlconnectionString)

Dim cmd As New SqlClient.SqlCommand("Populatecsv", con) ' create command objects and add parameters
With cmd.Parameters
.Add("@id", SqlDbType.BigInt)
cmd.Parameters("@id").Value = ID
.Add("@srn", SqlDbType.VarChar, 50)
.Add("@srcode", SqlDbType.VarChar, 50)
.Add("@srnumber", SqlDbType.VarChar, 50)
.Add("@status", SqlDbType.VarChar, 500)
.Add("@CustomerName", SqlDbType.VarChar, 500)
.Add("@HomeContact", SqlDbType.VarChar, 500)
.Add("@BusinessContact", SqlDbType.VarChar, 500)
.Add("@MobileContact", SqlDbType.VarChar, 500)
.Add("@LotHouseNo", SqlDbType.VarChar, 500)
.Add("@RoomUnitStall", SqlDbType.VarChar, 500)
.Add("@BldgFloor", SqlDbType.VarChar, 500)
.Add("@BldgName", SqlDbType.VarChar, 500)
.Add("@Street", SqlDbType.VarChar, 500)
.Add("@Subdivision", SqlDbType.VarChar, 500)
.Add("@Barangay", SqlDbType.VarChar, 500)
.Add("@CityMunicipality", SqlDbType.VarChar, 500)
.Add("@Province", SqlDbType.VarChar, 500)
.Add("@Region", SqlDbType.VarChar, 500)
.Add("@Package", SqlDbType.VarChar, 500)
.Add("@PromoCode", SqlDbType.VarChar, 500)
.Add("@ApplicationDate", SqlDbType.DateTime)
.Add("@PaymentDate", SqlDbType.DateTime)
.Add("@EndorsedDate", SqlDbType.DateTime)
.Add("@PaymentDate", SqlDbType.DateTime)
.Add("@ScheduleDate", SqlDbType.DateTime)
.Add("@ActivationDate", SqlDbType.DateTime)
.Add("@PCDelivery", SqlDbType.VarChar, 500)
.Add("@NoPCAvailable", SqlDbType.VarChar, 50)
.Add("@DatePCPickUp", SqlDbType.DateTime)
.Add("@SalesAgent", SqlDbType.VarChar, 500)
.Add("@Coordinator", SqlDbType.VarChar, 500)
.Add("@SalesChannel", SqlDbType.VarChar, 500)
.Add("@SalesGroup", SqlDbType.VarChar, 500)
.Add("@CreatedBy", SqlDbType.VarChar, 500)
.Add("@loanStatus", SqlDbType.VarChar, 500)
.Add("@timestamp", SqlDbType.DateTime)
End With
con.Open()

Dim adapter As New SqlClient.SqlDataAdapter()
adapter.InsertCommand = cmd

'--Update the original SQL table from the datatable
Dim iRowsInserted As Int64 = _
adapter.Update(dt)
Try
cmd.ExecuteNonQuery()
Catch ex As System.Data.SqlClient.SqlException
Msg

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 10033107 · Accepted Answer · 2013-06-05T16:32:00

hey guys im almost there having an error : "Failed to convert parameter value from a String to a Int64."

this what ive change with your advice guys:

Using con As New SqlClient.SqlConnection(SqlconnectionString)

Dim cmd As New SqlClient.SqlCommand("Populatecsv", con) ' create command objects and add parameters
With cmd.Parameters
.Add("@id", SqlDbType.BigInt)
cmd.Parameters("@id").Value = ID
.Add("@srn", SqlDbType.VarChar, 50)
.Add("@srcode", SqlDbType.VarChar, 50)
.Add("@srnumber", SqlDbType.VarChar, 50)
.Add("@status", SqlDbType.VarChar, 500)
.Add("@CustomerName", SqlDbType.VarChar, 500)
.Add("@HomeContact", SqlDbType.VarChar, 500)
.Add("@BusinessContact", SqlDbType.VarChar, 500)
.Add("@MobileContact", SqlDbType.VarChar, 500)
.Add("@LotHouseNo", SqlDbType.VarChar, 500)
.Add("@RoomUnitStall", SqlDbType.VarChar, 500)
.Add("@BldgFloor", SqlDbType.VarChar, 500)
.Add("@BldgName", SqlDbType.VarChar, 500)
.Add("@Street", SqlDbType.VarChar, 500)
.Add("@Subdivision", SqlDbType.VarChar, 500)
.Add("@Barangay", SqlDbType.VarChar, 500)
.Add("@CityMunicipality", SqlDbType.VarChar, 500)
.Add("@Province", SqlDbType.VarChar, 500)
.Add("@Region", SqlDbType.VarChar, 500)
.Add("@Package", SqlDbType.VarChar, 500)
.Add("@PromoCode", SqlDbType.VarChar, 500)
.Add("@ApplicationDate", SqlDbType.DateTime)
.Add("@PaymentDate", SqlDbType.DateTime)
.Add("@EndorsedDate", SqlDbType.DateTime)
.Add("@PaymentDate", SqlDbType.DateTime)
.Add("@ScheduleDate", SqlDbType.DateTime)
.Add("@ActivationDate", SqlDbType.DateTime)
.Add("@PCDelivery", SqlDbType.VarChar, 500)
.Add("@NoPCAvailable", SqlDbType.VarChar, 50)
.Add("@DatePCPickUp", SqlDbType.DateTime)
.Add("@SalesAgent", SqlDbType.VarChar, 500)
.Add("@Coordinator", SqlDbType.VarChar, 500)
.Add("@SalesChannel", SqlDbType.VarChar, 500)
.Add("@SalesGroup", SqlDbType.VarChar, 500)
.Add("@CreatedBy", SqlDbType.VarChar, 500)
.Add("@loanStatus", SqlDbType.VarChar, 500)
.Add("@timestamp", SqlDbType.DateTime)
End With
con.Open()

Dim adapter As New SqlClient.SqlDataAdapter()
adapter.InsertCommand = cmd

'--Update the original SQL table from the datatable
Dim iRowsInserted As Int64 = _
adapter.Update(dt)
Try
cmd.ExecuteNonQuery()
Catch ex As System.Data.SqlClient.SqlException
MsgBox(ex.Message)
End Try
con.Close()
MsgBox("Success")
End Using

ExecuteNonQuery: Connection property has not been initialized.

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us