select sql server querry in c sharp

Question

0.00/5 (No votes)

See more:

SELECT * From sec_users_ids where UserName = ('"+ userName +"')"

i am passing a querry to command.commandtext(str_querry) ant then command.executenonquerry()
how i come to know that that particular data is present there or not
i already created connection and .......

Posted 5-Jul-11 20:15pm

kami124

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

2irfanshaikh · Answer 1 · 2011-07-05T20:19:00

Solution 1

try this

SELECT count(*) From sec_users_ids where UserName = ('"+ userName +"')"

int i = Convert.ToInt32(command.ExecuteScalar());

if ( i == 0)
   //User does not exist
else
   //User exist

Posted 5-Jul-11 20:19pm

2irfanshaikh

Comments

kami124 6-Jul-11 2:34am

thanks

SanjeevSingh · Answer 2 · 2011-07-05T20:20:00

Solution 2

hello,

one way of doing this is take data into a datatable using sqladapter and then check a condition for rowcount if count is greater than 0 that means data is there.

thanks
sanjeev

Posted 5-Jul-11 20:20pm

SanjeevSingh

abhhy09 · Answer 3 · 2011-07-05T20:20:00

Solution 3

to get the record you may use datareader instead of executenonquery

Posted 5-Jul-11 20:20pm

abhhy09

_Maxxx_ · Answer 4 · 2011-07-05T20:24:00

Solution 4

If you want jsut to find if the user exists, change the sql to

Select count(*) from ....

then the result of your executenonquery will be the number of rows found

e.g.

int x = command.executenonquery

then check x

Posted 5-Jul-11 20:24pm

_Maxxx_