I have been trying for days to figure out how to bulk load users into the ASP.NET security tables. After googling and experimenting I have the code below. I've been testing it to get out the bugs but now that no errors display, I don't see any new
rows in the users or membership tables. Can anyone tell me where I'm going wrong? I am a newbie at .NET coding.
Here is the code I have so far in the code behind:
Imports System.Data
Imports System.Data.Sql
Imports System.Data.SqlClient
Partial Class Management_BulkInsertUsersToSecurity
Inherits System.Web.UI.Page
Protected Sub Button1_Click(sender As Object, e As EventArgs)
Dim conn As New SqlConnection
Dim cmd As New SqlCommand
Try
conn.ConnectionString = "Data Source=pediatrics02\sea12;Initial Catalog=Quant;User ID=FakeBigUser;Password=FakePW!"
conn.Open()
cmd.Connection = conn
...
Go to the complete details ...