Select statement

[VJ]

SELECT [Department], [Last_Name], [First_Name], [Title], [Extension]
FROM [temployees] WHERE (([Department] = @Department) OR ([First_Name]
LIKE '%' + @First_Name + '%'))

this is my sql statement on my GridView but I can't get the values to
display?

 

[sirfunusa]

Are you getting an error? Do other sql statements on other gridviews
work? How are you passing in those parameters? Do hard-coded sql
statements work?

 

[Patrick.O.Ige]

Show some snippet code and you will get an answer
Patrick

 

[vncntj]

This is my sqldatasource.....

<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:dbPMAEventsConnectionString %>"
SelectCommand="SELECT [Department], [Last_Name], [First_Name],
[Title], [Extension] FROM [temployees] WHERE (([Department] =
@Department) OR ([First_Name] LIKE '%' + @First_Name + '%'))">
<SelectParameters>
<asp:ControlParameter ControlID="dpdDepartment"
Name="Department" PropertyName="SelectedValue"
Type="String" />
<asp:FormParameter FormField="txtFirstName"
Name="First_Name" Type="String" />
</SelectParameters>
</asp:SqlDataSource>


but the gridview gives me NO data at all

<asp:GridView ID="GridView1" runat="server"
AutoGenerateColumns="False" DataSourceID="SqlDataSource2"
Font-Names="Arial" Font-Size="Smaller" Style="z-index: 109;
left: 140px; position: absolute;
top: 314px" Width="800px">

thanks
v

 

[Patrick.O.Ige]

Have you tried your SQL statement using Query Analyzer?
Pls do that and is it possible to move your Sql statement to a stored
procedure
PAtrick

 

[sirfunusa]

Sorry, can't help you if you don't answer my original questions.

 

[neilmcguigan]

You can't use an expression in the select statement

you'll have to take out the "+" signs

 

[neilmcguigan]

er, you can't use an expression in the declarative property of the
sqldatasource i mean