BlindWiz
BlindWiz
CC#
Created by BlindWiz on 1/4/2024 in #help
Creating a SqlConnection connection via connection string
Hi All, I have the following connection string: Server=mssql01,3266;Database=ProductsDev;Trusted_Connection=True; so I have the code: string con_str = "Server=mssql01,3266;Database=ProductsDev;Trusted_Connection=True;"; using(var sqlConnection = new SqlConnection(con_str)) { this.sqlConnection = sqlConnection; // store the object for the rest of the code to use. } I have this in a constructor, but when I use this sqlConnection object from another method where I am using a SqlCommand object to insert a row into a table it says it is closed, and I get the exception The ConnectionString property has not been initialized. Is the issue that I put the SqlConnection object in a using statement so its closing it? but if if it is closing it, won't this.sqlConnection.open() reopen the connection to the db? Thanks, I hope this makes sense.
4 replies