Posted on: 4/20/2015 2:51:13 AM | Views : 535

Hi
I have a custom provider that creates a new user. It works great but when I call my getAllUsers it fails on my SQLDataReader for some reason. This is not a problem with delete.
Public Overrides Function GetAllUsers(pageIndex As Integer, pageSize As Integer, ByRef totalRecords As Integer) As MembershipUserCollection Dim con = New SqlConnection(ConfigurationManager.ConnectionStrings("DefaultConnection").ConnectionString) Dim cmd = New SqlCommand Dim con1 = New SqlConnection(ConfigurationManager.ConnectionStrings("DefaultConnection").ConnectionString) Dim cmd1 = New SqlCommand cmd.CommandText = "syst.getCountUsers" cmd.CommandType = CommandType.StoredProcedure cmd.Connection = con Dim users As MembershipUserCollection = New MembershipUserCollection() Dim reader As SqlDataReader = Nothing ...

Go to the complete details ...