Postgresql query in ASP.NET C# using like operator

Asked Jan 07 '23 at 07:55

Active Jan 07 '23 at 08:41

Viewed 117 times

This code works

public void select()
{
    string str = "SELECT * FROM gazettes g WHERE g.title LIKE '%"+ hidden_key.Value +"%' OR serial LIKE '%"+ hidden_key.Value +"%'"; /*'%' || @title || '%'*/
    SqlDataSource1.SelectCommand = str;
    GV_Gazette.DataBind();
}

but I want it to work in this as well but it returns an empty value. What am I doing wrong?

public void select()
{
    string str = "SELECT * FROM gazettes g WHERE g.title LIKE @title OR serial LIKE @title";/*'%' || @title || '%'*/
    cmd.CommandText = str;
    cmd.Parameters.AddWithValue("@title", "%" + hidden_key.Value + "%");    
    dt = c.PopulateData(cmd);
    SqlDataSource1.SelectCommand = dt.ToString();
    GV_Gazette.DataBind();
}

edited Jan 07 '23 at 08:41

marc_s

732,580
175
1,330
1,459

asked Jan 07 '23 at 07:55

Lolly Molly

Use `ILIKE` in PGSQL. – Hiren Patel Jan 07 '23 at 08:00
cmd.Parameters.Add("@title", hidden_key.Value); – MichaelMao Jan 07 '23 at 08:02
https://stackoverflow.com/questions/665129/use-of-sqlparameter-in-sql-like-clause-not-working – MichaelMao Jan 07 '23 at 08:04
@HirenPatel it doesn't work – Lolly Molly Jan 07 '23 at 08:04
Can you please share data set? – Hiren Patel Jan 07 '23 at 08:05
Please also share expected output. – Hiren Patel Jan 07 '23 at 08:09
public DataTable PopulateData(NpgsqlCommand command){ dt = new DataTable(); command.Connection = conn; command.CommandType = CommandType.Text; conn.Open(); NpgsqlDataAdapter da = new NpgsqlDataAdapter(); da.SelectCommand = command; da.Fill(dt); return dt;} @HirenPatel – Lolly Molly Jan 07 '23 at 08:50
@LollyMolly I think it should be `SqlDataSource1.SelectCommand = str;` – Vivek Nuna Jan 07 '23 at 15:07

Postgresql query in ASP.NET C# using like operator

0 Answers0