object reference not set to an instance of an object [duplicate]

1
  

System.NullReferenceException: 'Object reference not set to an instance of an object.'

Dim conexion As SqlConnection 
conexion.ConnectionString = "integrated security=SSPI;data source=LAPTOP-2QDQLE6A\SQLEXPRESS;" & "persist security info=False;initial catalog=Estudiantes"

Can someone help me with this error?

    
asked by Mario 06.06.2017 в 07:05
source

1 answer

2

The problem is that in the first line you are declaring a variable of type SqlConnection but if you do not instantiate it, you keep the value null

What you must do is in that same line assign a value, in this case creating a new instance of SqlConnection mediante keyword New

Dim conexion As New SqlConnection 
conexion.ConnectionString = "integrated security=SSPI;data source=LAPTOP-2QDQLE6A\SQLEXPRESS;" & "persist security info=False;initial catalog=Estudiantes"
    
answered by 06.06.2017 в 07:26