pls correct that sql query.

See more:

C#

ASP.NET

SQL

i am taking username and rolename from users and groups table respectively and

i have a third role table which has a foreign key of userid and groupid from the users table and groups table.

now i want to assing roles to users on the bases of username and rolename if it doesnot exits in the database. but first i am checking that whether the role exits or not in the role table of the database.

so i write a query to implement it. its not executing properly

<pre lang="c#">"SELECT Count(UserId,GroupID) FROM roles Select UserId,GroupID from Users,Groups WHERE username = '" + TextBox1 + "' AND name = '" + TextBox2.Text + "'";

can anyone help me to correct it out.