How I Can Use N' Switch in My Sql Query That I am Encountered A Problem Such a Below Format In My Queries
strSql="select * from member_info where username=N'@username and password=N'@password";//
                    SqlDataAdapter objCommand=new SqlDataAdapter(strSql,objConnection);
                 objCommand.SelectCommand.Parameters.Add(new SqlParameter("@username",SqlDbType.NVarChar,50));//.Value=username.Text;
                 objCommand.SelectCommand.Parameters["@username"].Value="ali";//username.Text;
                 objCommand.SelectCommand.Parameters.Add(new SqlParameter("@password",SqlDbType.NVarChar,50));
                 objCommand.SelectCommand.Parameters["@password"].Value="12"
Any One Help Me About This Problem .
Regards YoOrD

__________________
       YoOrD .
Beauty is not on the face
Beauty is on the heart
~~<<Ghibran Khalil>>~~

You shouldn't need to use that when you are using a parameterized query.

I have to use use this switch because without this option i cant or inserted or fetched data is not correct .
Regards YoOrD

Hello,

The problem is the quotes around parameters in the query:

N'@username and password=N'@password

You shouldn't have those ' in the query; the ' will throw it off. Parameters don't use the ', otherwise it assumes the user name is '@username', Although with no ending quote that will throw an error also.

It should be:
username = @username and password = @password

Someone correct me if I'm wrong.

Brian

Brian,

To my knowledge, you are correct. The question, how do we prefix the parameter with the N'? And is that necessary? I thought that using that prefix specifies the datatype for the string, so I would also think that by specifying the correct datatype for the parameter you are accomplishing the same thing. I'm not sure either way.

thanx to brian.
but i examined it the only way that i can correctly insert data into a remote sql server database and when i ommite it the data was ureadable and substituted (or) each character replaced with a '?'
i must mentioned that i am using farsi or arabic collation to insert farsi data into a sql server database and the only solution that i found the i use the 'N Switch in my queries.
ant one have using this switch or this type experience.
i have had this problem ASP And Not In ASP.NET(ADO.NET) I dont know that i will encoutred such a problem in ASP.NET Or No But I think its a Query And It is Correct For All Type Of Query And I Use It Succefully In Query Analyzer And In The ASP And I Get The Proper Goal.
But I Must Check It In New Platform(.Net) And I Must Examine that is it work correct witnout using this switch with the Farsi Locals.
Thanx TO All:)
Any One To Help Me.

Thanx To All I Must Notify Some Thing Here That I Have To Use Such Syntax For a Remote Sql Serverhttp://www.microsoft.com/middleeast/...port_characterThat Corrupts Data When I Am Going Inserting Some Thing Farsi And It is Unusable It Is Force Me To Use It.
Any One Can Lookup Above Link To Learn More .
Regards YoOrD.:)

if u use [u]VS.NET Visual mode </u>when u set ur CommandText to:
It will create ur Paramaeters & U'll only need to set them.
but if u dont use [u]VS.NET Visual mode</u> u just set ur test to:
Again & set ur Parameters urself.

HTH.


Always:),
Hovik Melkomian.