what is query for this query?

Question

0.00/5 (No votes)

See more:

SqlCommand cmd = new SqlCommand("select * from user_login where groupid=Student", cnn);

in my user_login table groupid contains 3type date(Student,lecturer,admin)
I have to select data from user_login where groupid is Student .
but this query give error like : invalid collum name Student.
what is problem?

Posted 9-Jan-13 23:55pm

Member 9511889

Add a Solution

Comments

Tejal S 10-Jan-13 6:00am

GroupId datatype Pls

6 solutions

Solution 2

SqlCommand cmd = new SqlCommand("select * from user_login where groupid='Student'", cnn);

used Single '' code then execute this query

i hope your problem will solve if not please give your comment

Posted 10-Jan-13 0:00am

rizwan muhammed khan gouri

Solution 5

C#

SqlCommand cmd = new SqlCommand("select * from user_login where groupid='Student'", cnn);

Posted 10-Jan-13 0:14am

sarathsprakash

Solution 3

Hi,

If your Group_Id column datatype is varchar , then u must pass the value with in single codes dont forget this ....

SQL

select * from user_login where groupid='Student'

Posted 10-Jan-13 0:10am

pranathis012

Solution 4

Hi Friend!!!
write your query like this...

SqlCommand cmd = new SqlCommand("select * from user_login where groupid='"Student"'", con);

or

SqlCommand cmd = new SqlCommand("select * from user_login where groupid='"+txtStudent.Text+"'", con); // if there you are reading value from textbox.

i hope it will help you
thanks

Posted 10-Jan-13 0:12am

Shubh Agrahari

Comments

Faisalabadians 10-Jan-13 6:43am

SqlCommand cmd = new SqlCommand("select * from user_login where groupid='"Student"'", con);

concatenation required here

string Student;
SqlCommand cmd = new SqlCommand("select * from user_login where groupid='" + Student + "'", con);

or if you dont want to concatenate, then it must be

SqlCommand cmd = new SqlCommand("select * from user_login where groupid='Student'", con);

Solution 6

can you tell what is the type of "groupid" column in your database? and if is the foreign key column or not? as the name of column is "groupid" I am suspecting that it would be in relation with some other table. if it is not, then all the solutions provided are correct.

Posted 10-Jan-13 0:39am

Faisalabadians

Updated 10-Jan-13 0:40am

v2

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)

Tharaka MTR · Accepted Answer · 2013-01-09T23:59:00

Solution 1

try this

SQL

SqlCommand cmd = new SqlCommand("select * from user_login where groupid='Student'", cnn);

Posted 9-Jan-13 23:59pm

Tharaka MTR