...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(); }
SqlCommand("SELECT EngLyrics FROM dbo.Lyrics WHERE SongName LIKE '%' + @searchSome + '%';", DBConnectInfo.connection);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)