SQL Syntax in Select Statement of a SQlDataAdapter

[gggram2000]

Hi!

I have a SQLDataAdapter and I want to retrieve data from my database in SQL Server 2005 . Supposing I have two tables named Guest, Sales and one of the columns is GuestFirstName. I want to retrieve One record(GuestFirstName) from table Guest that has the same GuestID as in Sales GuestID. Also in the Sales table the column SalesStatus needs to contain the text 'ToGuestInvoice'.

Directly in SQL Server 2005 I can perform this query with the following syntax:

SELECT g.GuestFirstName as GuestFirstName
From Guest AS g, Sales As s 
WHERE g.GuestID = s.GuestID AND s.SalesStatus = 'ToGuestInvoice' 
GROUP BY g.GuestFirstName 
 

But when I write this query as a select query in my SqlDataAdapter I want to express GuestFirstName as a parameter and use that parameter in run time but the syntax seems to be different because the query retrieves no records from the database. (I tried to express the parameter as @GuestFirstName but that does not work)
How can that be done?

I wrote this code: (Visual Studio 2005-C#)

           string sqlq = @" Select g.GuestFirstName from Guest g, Sales s where g.GuestID = s.GuestID And s.SalesStatus Like 'ToGuestInvoice%' GROUP BY g.GuestFirstName ";
SqlDataAdapter da = new SqlDataAdapter(sqlq, dbConnection);
 
myCommand.CommandText = sqlq;
myCommand.Parameters.Add("@GuestFirstName",SqlDbType.VarChar).Value = da;
 

[gggram2000]

Can Anyone assist me? I'd really appreciate it!

George

[gggram2000]

Anxiously waiting for a reply! Has anyone encountered this problem or something similar?? I would like to know urgently....i'll be grateful for any help possible...