I was doing some work that required that some parts of the database were encrypted and couldn’t find an all-in-one location for information. If that’s what you’re looking for, this ain’t it either. I will, however, briefly explain how to create symmetric and asymmetric keys that use passwords. First off,…
Tag: SQL Server
Sql OUTPUT Params, SqlDataReaders and “Object reference not set to an instance of an object”
When you call ExecuteReader() on a SqlCommand object that has OUTPUT parameters you won’t be able to access the OUTPUT parameters until the SqlDataReader has been closed. Private Shared Sub SomeMethod() Using Con As New SqlConnection(“DSN…”) Con.Open() Using Com As New SqlCommand(“MyProc”, Con) Com.CommandType = System.Data.CommandType.StoredProcedure Com.Parameters.Add(New SqlParameter(“@YourOutputParam”, System.Data.SqlDbType.Int) With…