VB SQL 2 Question part 2

I have created several command text with several command type to insert into a SQL Database. These command call 13 different Module SQL connection strings from a VB code form. Question: Is there a certain number of command and connections strings I'm allowed to use with this set up? yes or No
Here is the Error I get:
ExecuteNonQuery requires an open and available connection. The connection's current state is closed.


 Imports System.Data.SqlClient
 Module ClintCounsPLn
     Public con13 As New SqlConnection("Data Source = localhost\GECACSQL; Initial Catalog = Housingtwoyrsbck; Integrated Security= True")
     Public cmd13 As New Data.SqlClient.SqlCommand
 End Module


  cmd13.Connection = con

 cmd13.CommandType = System.Data.CommandType.Text

  cmd13.CommandText = " insert into ClientCounPLn values ('" & txthmSS.Text & "','" & txthmFn.Text & "','" & txthmLN.Text & "','" & cmbHomEvic.SelectedItem & "')"

  con13.Open()
             cmd13.ExecuteNonQuery()
 con13.close()
MyExpqust15Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Haris DulicCommented:
Hi,

i think this line is the problem:

 cmd13.Connection = con

change it to

 cmd13.Connection = con13

and then try.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MyExpqust15Author Commented:
OK, I am trying it now. I will let you know if it works

Thank you,

Rodney
0
MyExpqust15Author Commented:
Thank you Haris Djulic2015-04-30 at 14:15:15ID: 40753713, I did miss this little step, which is huge to the success of the data transfer
0
Haris DulicCommented:
Did the correction resolve the issue?
0
MyExpqust15Author Commented:
Yes this issue is resolved!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.