how to create procedure search string in mysql

Question

hothorasman panjaitan · Answer

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_lembagap.propinsi_namak.kabupaten_namal.nama_lembagapr.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(); } } } }

Abrar Ahmad Ansari · Answer

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

hothorasman panjaitan · Answer

I want to find some name / country

Abrar Ahmad Ansari · Answer

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