protected void Button1_Click1(object sender, EventArgs e) { DataTable PassRecord = new DataTable(); String str = "select First_Name,Email_Account,Surname,id from ID where (First_Name like '%'+ @search +'%' ) OR (Surname like '%'+ @search +'%') OR (Email_Account like '%'+ @search +'%')"; SqlCommand Srch = new SqlCommand(str, con); Srch.Parameters.Add("@search", SqlDbType.NVarChar).Value = TextBox1.Text; if (TextBox1.Text != "") { con.Open(); Srch.ExecuteNonQuery(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = Srch; DataTable dt = new DataTable(); DataTable dtResult = new DataTable(); da.Fill(dt); PID = (int)(Session["id"]); int SaveTheFirst = PID; foreach (DataRow dr in dt.Rows) { PID2 = dr["id"].ToString() ; if (PID.ToString() != PID2 ) { counter++; var field = "<a href='" + Page.ResolveUrl("~/PageView.aspx?Email=" + dr["id"].ToString()) + "'>" + (dr["First_Name"] + "").ToString() + "</a>"; Response.Write(field); HttpContext context = HttpContext.Current; Response.Write("<br/>"); } } con.Close(); } else { string display = " Not Valid Search Criteria!"; ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + display + "');", true); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)