search code in text box ?

OnTextChanged="SearchByTagButton_Click" />

using System;

using System.Data;

using System.Data.SqlClient;

public partial class AdminSearch : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void SearchByTagButton_Click(object sender, EventArgs e)

{

String strConn = "Data Source=HAKANPUR-PC\\SQLEXPRESS;Initial Catalog=Medtoc;Integrated Security=True";

SqlConnection conn = new SqlConnection(strConn);

conn.Open();

SqlCommand cmd = new SqlCommand("Select * FROM Patients WHERE tag_number like @SearchByTagTB+'%'", conn);

try

{

SqlParameter search = new SqlParameter();

search.ParameterName = "@SearchByTagTB";

search.Value = SearchByTagTB.Text.Trim();

cmd.Parameters.Add(search);

SqlDataReader dr = cmd.ExecuteReader();

DataTable dt = new DataTable();

dt.Load(dr);

gvPatients.DataSource = dt;

gvPatients.DataBind();

}

catch (Exception ex)

{

Response.Write(ex.Message);

}

finally

{

//Connection Object Closed

conn.Close();

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Madan Shekar7y ago
Accepted answer

OnTextChanged="SearchByTagButton_Click" />

using System;
using System.Data;
using System.Data.SqlClient;
public partial class AdminSearch : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void SearchByTagButton_Click(object sender, EventArgs e)
{
String strConn = "Data Source=HAKANPUR-PC\\SQLEXPRESS;Initial Catalog=Medtoc;Integrated Security=True";
SqlConnection conn = new SqlConnection(strConn);
conn.Open();
SqlCommand cmd = new SqlCommand("Select * FROM Patients WHERE tag_number like @SearchByTagTB+'%'", conn);
try
{
SqlParameter search = new SqlParameter();
search.ParameterName = "@SearchByTagTB";
search.Value = SearchByTagTB.Text.Trim();
cmd.Parameters.Add(search);
SqlDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(dr);
gvPatients.DataSource = dt;
gvPatients.DataBind();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
//Connection Object Closed
conn.Close();
}
}
}
Subin Thomas7y ago
thanks madan for the code i made some changes and it worked
Salman Beg7y ago
Hi. You can use like operator to do the same, declare @test varchar(max); set @test='t'; select * from table where column1 like @test+'%'; You can use this above line in a stored procedure and pass your textbox value as a parameter. Thanks.