C# Online Compiler | .NET Fiddle

<no name> by Anonymous

using System;

namespace Task2
{
    public class Program
    {
        public static void Main(string[] args)
        {
            string sql_z = "";
            string[,] p = new string[5, 2];

            p[0, 0] = "p1"; p[0, 1] = "3";
            p[1, 0] = "p2"; p[1, 1] = "";
            p[2, 0] = "p3"; p[2, 1] = "1";
            p[3, 0] = "p4"; p[3, 1] = "";
            p[4, 0] = "p5"; p[4, 1] = "";


            sql_z = sql_z + "SELECT * FROM docs WHERE ";
            for (int i = 0; i < 5; i++)
            {
                if (p[i, 1] == "") { sql_z = sql_z + p[i, 0] + " LIKE '%' "; }
                else { sql_z = sql_z + p[i, 0] + " = '" + p[i, 1] + "' "; }
                if (i < 4) sql_z = sql_z + " and ";
                else sql_z = sql_z + ";";
            }


            Console.WriteLine(sql_z);
            Console.ReadLine();

        }
    }
}

​x
 
using System;
​
namespace Task2
{
    public class Program
    {
        public static void Main(string[] args)
        {
            string sql_z = "";
            string[,] p = new string[5, 2];
​
            p[0, 0] = "p1"; p[0, 1] = "3";
            p[1, 0] = "p2"; p[1, 1] = "";
            p[2, 0] = "p3"; p[2, 1] = "1";
            p[3, 0] = "p4"; p[3, 1] = "";
            p[4, 0] = "p5"; p[4, 1] = "";
​
​
            sql_z = sql_z + "SELECT * FROM docs WHERE ";
            for (int i = 0; i < 5; i++)
            {
                if (p[i, 1] == "") { sql_z = sql_z + p[i, 0] + " LIKE '%' "; }
                else { sql_z = sql_z + p[i, 0] + " = '" + p[i, 1] + "' "; }
                if (i < 4) sql_z = sql_z + " and ";
                else sql_z = sql_z + ";";
            }
​
​
            Console.WriteLine(sql_z);
            Console.ReadLine();
​
        }
    }
}
​

Compilation error (line 15, col 0): 'StrComp' is not declared. It may be inaccessible due to its protection level.
Compilation error (line 15, col 0): 'CompareMethod' is not declared. It may be inaccessible due to its protection level.
Compilation error (line 28, col 0): 'For' loop control variable cannot be of type 'String' because the type does not support the required operators.
Compilation error (line 28, col 0): 'Len' is not declared. It may be inaccessible due to its protection level.
Compilation error (line 28, col 0): 'Text1' is not declared. It may be inaccessible due to its protection level.
Compilation error (line 29, col 0): 'InStr' is not declared. It may be inaccessible due to its protection level.
Compilation error (line 29, col 0): 'Mid' is not declared. It may be inaccessible due to its protection level.
Compilation error (line 29, col 0): 'Text1' is not declared. It may be inaccessible due to its protection level.
Compilation error (line 39, col 0): 'End Sub' must be preceded by a matching 'Sub'.

Last Run:	1:11:11 pm
Compile:	0s
Execute:	0.117s
Memory:	0b
CPU:	0s

View IL Code