Hi,
I have a problem. I need to save in a parameter @Username the username of someone who inserts data in my create user form. I am using the CREATE USER WIZARD control and for example if I store the Usernme in a variable it's ok:

string var = CreateUserWizard1.UserName;
-----------------------------------------------
but if I want to store it in a parameter like this:

SqlParameter @Username = new SqlParameter();
@Username = CreateUserWizard1.UserName;

I get this: Cannot implicitly convert type 'string' to 'System.Data.SqlClient.SqlParameter'

What's going on plz help!

I'm surprised you can create a variable name beginning with an @ at all. The SqlParameter you create is an object with various properties. You need to set those properties, either in the constructor or after creation. One way would be to use: or There are other ways as described here: http://msdn2.microsoft.com/en-us/lib...parameter.aspx

--

Joe (Microsoft MVP - XML)

Learnt something from your post :)
The @ symbol can be used as the initial character of an identifier. Its purpose is usually to let you use what is otherwise a keyword be a variable name. More info here: http://msdn2.microsoft.com/en-us/library/aa664670(VS.71).aspx

Not recommended practice though.

--

Joe (Microsoft MVP - XML)

Thanks a lot for your help but I need to return the value that is stored in @UserName parameter and when I try, it returns me the name of the parameter not its value
PD: I am using:
SqlParameter userParam = new SqlParameter("@UserName", CreateUserWizard1.UserName);
        Response.Write(userParam);
Whats wrong with that?

Do, Response.Write(userParam.Value); that should give you the value.

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0
================================================== =========

I did it, no problem!
Thanks a lot!

No problem, glad it worked out for you.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0
================================================== =========