Query result is always empty.

See more:

C#

ASP.NET

SQL

Windows

Win8

Hi there. I cannot read my data from database. The query result is empty. I following to this article: GUIDE. Also, executing queries directly in DB returns me wished results. DB is SQLSERVER 2012. What i did wrong?

...string search....//the function's argument

SqlParameter sqlp = new SqlParameter("@searchSome", System.Data.SqlDbType.NVarChar, search.Length);
                    sqlp.Value = search;

                    SqlCommand cmd = new SqlCommand("SELECT EngLyrics FROM dbo.Lyrics WHERE SongName LIKE '%@searchSome%';", DBConnectInfo.connection);
                    cmd.Parameters.Add(sqlp);
                    
                    try
                    {
                        using (SqlDataReader sdr = cmd.ExecuteReader())
                        {
                            string result = String.Empty;
                            while (sdr.Read())
                            {
                                result = sdr["EngLyrics"].ToString();
                                return result;
                            }
                            return result;
                        }
                    }
                    catch (SqlException ex) { return ex.ToString(); }
                    finally
                    {
                        DBConnectInfo.connection.Close();
                    }