About Where clause(MDX)

Hey guys,

I looked over the web and couldn't find much help. Can someone help me with my SELECT statement? What I want to do is concatenate a varible to my WHERE clause. This is what I have:

myDataAdapter = new SqlDataAdapter("SELECT * FROM details WHERE DetailsID = " + lstBoxCategory.SelectedValue.ToString(), connection);

I tried this also but it didn't work:

myDataAdapter = new SqlDataAdapter("SELECT * FROM details WHERE DetailsID = '" + lstBoxCategory.SelectedValue.ToString() + "' ", connection);

Hi,

I have ListView/DataPager on the page that I use together with an EntityDataSource, because I want to filter the results, I programmatically set the Where-property and the WhereParameters of the EntityDataSource.

But: After the Paging-Postback the Value for Where is gone (empty string) whereas the WhereParameters are still there. Isn't the where value saved in ViewState as well? Can I change this behaviour?

Thanx, S.

why do i get

BC30506: Handles clause requires a WithEvents variable defined in the containing type or one of its base types.

with the code

 below ..thanks

<form id="form1" runat="server">

    <div>

               <asp:Button ID="Button1" runat="server" Text="Run Access" />

    </div>

    </form>

 SQL Query Where Clause 
  
Hello,
FROM dbo.SSD a , dbo.SSAAppEAL b
WHERE a.SSN = b.SSN 
AND (a.AssocClaim = 1) 
AND b.somedate = SELECT MAX (b1.somedate) 
                   FROM dbo.SSAAppEAL b1
                   WHERE b1.SSN = b.SSN

                   AND b1.somedate < sysdate

When ever I add this Query to my Select Statement. SQL management studio is shutting down abruptly.
The mail fault is with this statement
b.somedate = SELECT MAX (b1.somedate) 

                   FROM dbo.SSAAppEAL b1

                   WHERE b1.SSN = b.SSN

                   AND b1.somedate < sysdate

Can any one help me out
TIA