Hello!
I have changed .. and it work! :D
Thank youu..
however...
there is another problem..
when i click on a letter (for example A) , it does not come that specific character which is A..
but it come out as a whole (A-Z) it stays the same...
Is it we must run the follwing scpript to create the stored proceduce??
Cause if it is, I tried to. But there are errors..
the errors are
Error source: .Net SqlClient Data Provider
Error message: Incorrect syntax near 'GO'
'CREATE/ALTER PROCEDURE' must be the first statement in a query batch.
Cause I used Microsoft Visual Studio 2010 Sql Database..
Is that that the problem?
Please help me :)
Thank you soo much!
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[PlayerName, PlayerCost, PlayerVoltage FROM WiahPlayer]
@Alphabet VARCHAR(10)
AS
BEGIN
SET NOCOUNT ON;
IF @Alphabet = 'ALL'
BEGIN
SELECT *
FROM WiahPlayer
END
ELSE
BEGIN
SELECT *
FROM WiahPlayer
WHERE PlayerName LIKE @Alphabet + '%'
END
END