how do i write query that contains '%' character in config?

Question

I need to pass query something like Select * from EmpTable where EmpName LIKE '%ARP%' in application configuration file. ?

Omar Maher · Answer

try this static void Main() { string cstr = "server=(local)\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;" ; using ( SqlConnection conn = new SqlConnection( cstr ) ) { conn.Open(); string selstr = "select FirstName from Employee where lastname = @name" ; SqlCommand cmd = new SqlCommand( selstr, conn ); SqlParameter name = cmd.Parameters.Add( "@name" , SqlDbType.NVarChar, 15 ); name.Value = "Tang" ; SqlDataReader rdr = cmd.ExecuteReader(); if ( rdr.Read() ) { Console.WriteLine(rdr.GetString( 0 ) ); } else { Console.WriteLine( "not available yet" ); } } }

Omar Maher · Answer

put query in your code and use sql paramters , it will solve this issue

Nepethya Rana · Answer

I haven't implemented UI. It's an small application read log files to generate report so that I could analyse the report. So I thought I will pass the query through config file.

Nepethya Rana · Answer

I did not understand. Did you mean to concat % in code?

Manas Mohapatra · Answer

Try to add " % " instead of % in configuration file. In your code you can replace same( % ) with %. Secondly, why are you storing SQL query in config file?

how do i write query that contains '%' character in config?

Answers (5)