trouble with my SQL RSS

• • Reply
  

  Rimo72

  Member

  2 Points

  18 Posts

  trouble with my SQL

  Dec 29, 2012 11:56 AM|LINK

  Hi guys,

  Can one of you giude in the right direction? I don't understand why this is not working.

  SqlCommand comm = new SqlCommand("SELECT tbInterestsUtilisateur.interestsID FROM tbInterestsUtilisateur INNER JOIN tbUtilisateur ON tbInterestsUtilisateur.userID = tbUtilisateur.userID WHERE  (tbUtilisateur.userName = '@username')", con);
  
                  SqlParameter param = new SqlParameter();
                  param.ParameterName = "@username";
                  param.Value = "rimo72";
                  comm.Parameters.Add(param);
  
                  SqlDataReader reader = comm.ExecuteReader();

  
  the "reader" variable is always empty.

  If I put the value directly in my query, "reader" is populated.

  What am I doing wrong?

   

  Thanks

• • Reply
  

  oned_gk

  All-Star

  31766 Points

  6492 Posts

  Re: trouble with my SQL

  Dec 29, 2012 12:30 PM|LINK

  try : (tbUtilisateur.userName = @username)
  Programming to simplify, dont look for hard way
  • Marked as answer by Rimo72 on Dec 30, 2012 02:49 PM
• • Reply
  

  Rimo72

  Member

  2 Points

  18 Posts

  Re: trouble with my SQL

  Dec 29, 2012 12:36 PM|LINK

  thanks it works fine now.

• • Reply
  

  dotnetramesh

  Member

  74 Points

  37 Posts

  Re: trouble with my SQL

  Dec 29, 2012 12:37 PM|LINK

  Hai

  remove ()and ' in where condition

  try it

  where tbUtilisateur.userName = @username

  • Edited by dotnetramesh on Dec 29, 2012 12:37 PM
• • Reply
  

  oned_gk

  All-Star

  31766 Points

  6492 Posts

  Re: trouble with my SQL

  Dec 29, 2012 12:45 PM|LINK

  if work then mark as anwer
  Programming to simplify, dont look for hard way