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?

--
Sent via .NET Newsgroups
http://www.dotnetnewsgroups.com

[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

"VJ" <vn****@hotmail .com> wrote in message
news:Oq******** ******@TK2MSFTN GP09.phx.gbl...

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?

--
Sent via .NET Newsgroups
http://www.dotnetnewsgroups.com

[vncntj]

This is my sqldatasource.. ...

<asp:SqlDataSou rce ID="SqlDataSour ce2" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:dbPMAEventsC onnectionString %>"
SelectCommand=" SELECT [Department], [Last_Name], [First_Name],
[Title], [Extension] FROM [temployees] WHERE (([Department] =
@Department) OR ([First_Name] LIKE '%' + @First_Name + '%'))">
<SelectParamete rs>
<asp:ControlPar ameter ControlID="dpdD epartment"
Name="Departmen t" PropertyName="S electedValue"
Type="String" />
<asp:FormParame ter FormField="txtF irstName"
Name="First_Nam e" Type="String" />
</SelectParameter s>
</asp:SqlDataSour ce>
but the gridview gives me NO data at all

<asp:GridView ID="GridView1" runat="server"
AutoGenerateCol umns="False" DataSourceID="S qlDataSource2"
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
<vn****@hotmail .com> wrote in message
news:11******** *************@u 72g2000cwu.goog legroups.com...

This is my sqldatasource.. ...

<asp:SqlDataSou rce ID="SqlDataSour ce2" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:dbPMAEventsC onnectionString %>"
SelectCommand=" SELECT [Department], [Last_Name], [First_Name],
[Title], [Extension] FROM [temployees] WHERE (([Department] =
@Department) OR ([First_Name] LIKE '%' + @First_Name + '%'))">
<SelectParamete rs>
<asp:ControlPar ameter ControlID="dpdD epartment"
Name="Departmen t" PropertyName="S electedValue"
Type="String" />
<asp:FormParame ter FormField="txtF irstName"
Name="First_Nam e" Type="String" />
</SelectParameter s>
</asp:SqlDataSour ce>
but the gridview gives me NO data at all

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

thanks
v

[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