I create your procedure and this is my search button code
protected void search_Click(object sender, EventArgs e)
{
SqlConnection _cn = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["behtopConnectionString"].ConnectionString);
SqlCommand _cm2 = new SqlCommand("Electronic_Search", _cn);
_cm2.CommandType = CommandType.StoredProcedure;
_cm2.Parameters.Add("@Key", txtsearch.Text);
i dont know what should i bind in my gridview i want in my grid view put link that show my columns name that have value=1 after that click on link and it go to Corresponding page
now what should i do?