how to create procedure search string in mysql

this my code SP

DELIMITER $$

USE `dbcoba`$$

DROP PROCEDURE IF EXISTS `carii`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `carii`(IN id_lembaga INT)
BEGIN
    SELECT l.id_lembaga,p.propinsi_nama,k.kabupaten_nama,l.nama_lembaga,pr.peraturan_terkait
  FROM tbl_nama_lembaga l
  JOIN tbl_peraturan pr ON pr.id_peraturan=l.id_peraturan
  JOIN tbl_kabupaten k ON k.kabupaten_id=pr.kabupaten_id
  JOIN tbl_propinsi p ON p.propinsi_id=k.propinsi_id
  JOIN tbl_sektor sek ON sek.sektor_id=pr.sektor_id
  JOIN tbl_type_perda ty ON ty.type_id=pr.type_id
  WHERE l.id_lembaga=id_lembaga;
  END$$

DELIMITER ;

and I am make asp.net code like this

default.aspx.cs
protected void Search(object sender, EventArgs e)
    {
      
      
      get_sampah(int.Parse(txtcari.Text.Trim()));
    }


private void get_sampah(int id_lembaga)
    {

        using (MySqlConnection con = new MySqlConnection(strConnString))
        {
            using (MySqlCommand cmd = new MySqlCommand("carii", con))
            {
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@id_lembaga", id_lembaga);
                using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
                {
                    DataTable dt = new DataTable();
                    sda.Fill(dt);
                    GridView1.DataSource = dt;
                    GridView1.DataBind();
                }
            }
        }
    }

CREATE PROCEDURE SearchCountry
  -- Add the parameters for the stored procedure here
  @Name varchar(max),
  @CountryName varchar(max)
AS
BEGIN
  -- SET NOCOUNT ON added to prevent extra result sets from
  -- interfering with SELECT statements.
  SET NOCOUNT ON;

  -- Insert statements for procedure here
  SELECT * FROM Table_Name
  WHERE
  Column_Name like '%'+@Name+'%'
  or
  Column_Name like '%'+@CountryName+'%'

END

what string do you want to search?
Please elaborate your question.