Sql Error

[aru]

Command.AddParameter("STUDENT")
Command.SetParameter("STUDENT",Search.Text)

Reader.New1

Command.CommandText = "select * from student where studentname like @STUDENT"
Connection.BeginTransaction
Reader.Value = Command.ExecuteReader

Do While Reader.ReadNextRow = True
ViewStudentTable.AddRow (Reader.GetValue(1))

Loop
Reader.Close

Connection.EndTransaction

This is Not Working .
How we add a LIKE query is this "%" symbol is necessary?
Can you Help Me ?
:sign0085:

 

[Erel]

The Connection.BeginTransaction and EndTransaction are not required here and can only cause problems.

The '%' symbol is necessary. Maybe you need something like:

Command.SetParameter("STUDENT","%" & Search.Text & "%")