Suggest a feature
×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: ASP
Posted by: Mario Lopes
Added: May 22, 2018 8:40 AM
Views: 7
Tags: concat like sql
comofazer like sql
  1.   s.SelectParameters.Clear();
  2.         s.SelectCommand = "select * from perfumes where routelink like CONCAT('%',?,'%')";
  3.         s.SelectParameters.Add("@a", txtPesquisa.Text);
  4.         s.DataBind();