Dears

NewUsers is a table (in the ASPNET.mdf) has UserName, Password, Email 3 fields.

I¡¦d like to copy all the data in NewUsers to the following tables

It should be

1. NewUsers.UserName => aspnet_users.UserName
2. NewUsers.Password => aspnet_membership. Password
3. NewUsers.Email => aspnet_membership.Email
4. and setting the newsletter <SubscriptionType> to ¡§Html¡¨ in the aspnet_Profile table

How to do it? With store procedure or need C# /VB.net code?

Thanks

I did.
:)
protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            SqlConnection MyConnection;
            SqlCommand MyCommand;
            SqlDataReader MyReader;

            string cnnString = "your ConnectionString";
            MyConnection = new SqlConnection();
            MyConnection.ConnectionString = cnnString;

            MyCommand = new SqlCommand();
            MyCommand.CommandText = "SELECT [UserName], [password], [email] FROM [NewUser]";
            MyCommand.CommandType = CommandType.Text;
            MyCommand.Connection = MyConnection;


            MyCommand.Connection.Open();
            MyReader = MyCommand.ExecuteReader(CommandBehavior.CloseConne ction);


            while(MyReader.Read())
            {
                string theUserName = MyReader["UserName"].ToString();
                string thePassword =MyReader["password"].ToString() ;
                string theEmail = MyReader["email"].ToString();
                System.Web.Security.Membership.CreateUser(theUserN ame,thePassword,theEmail);

                ProfileCommon profile = this.Profile;
                profile = this.Profile.GetProfile(theUserName);

                profile.Preferences.Newsletter = (SubscriptionType)Enum.Parse(typeof(SubscriptionTy pe),"Html");
                profile.Save();

            } ;


            MyCommand.Dispose();
            MyConnection.Dispose();
        }
    }

This is handy code for anyone who wants to preload users. The Membership class will encrypt the passwords for you if you do it this way. Creating the Profile and setting it to Html is a nice touch.

People often need to create canned accounts for QA testers, or training accounts for user training. Anytime you create these common accounts you have to either delete them afterward, or change the passwords on them.

By the way, since you took extra effort to dispose the command and connection, I thought I'd point out a common misunderstanding in the Reader. The CommandBehavior.CloseConnection will only execute if ALL the records are actually read. If an exception were to occur, the connection would stay open. This isn't a big deal on this "one time" code, but it's nice the remember the importance of try/finally whenever you use a Reader in production code.

Eric