In this blog we will know
how to Search Records using TextBox and Display those values in GridView.
<%@
Page Language="C#"
AutoEventWireup="true"
CodeBehind="Default.aspx.cs"
Inherits="Search_Record_Display_in_GridView._Default"
%>
<!DOCTYPE
html PUBLIC
"-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html
xmlns="http://www.w3.org/1999/xhtml"
>
<head
runat="server">
<title>Untitled
Page</title>
</head>
<body>
<form
id="form1"
runat="server">
<div>
<asp:Label
ID="Label7"
runat="server"
Text="Search By Name"></asp:Label>
<asp:TextBox
ID="TextBox1"
runat="server"></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator1"
runat="server"
ErrorMessage="Please
insert name" ControlToValidate="TextBox1"></asp:RequiredFieldValidator>
<asp:GridView
ID="GridView1"
runat="server">
</asp:GridView>
<asp:Button
ID="btn_search"
runat="server"
Text="Search"
onclick="btn_search_Click"
/><br
/>
<asp:Label
ID="lblmsg"
runat="server"
BackColor="#FFFF66"
Font-Bold="True"
ForeColor="#FF3300"></asp:Label>
</div>
</form>
</body>
</html>
using
System;
using
System.Collections;
using
System.Configuration;
using
System.Data;
using
System.Linq;
using
System.Web;
using
System.Web.Security;
using
System.Web.UI;
using
System.Web.UI.HtmlControls;
using
System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
using
System.Xml.Linq;
using
System.Data.SqlClient;
namespace
Search_Record_Display_in_GridView
{
public partial
class _Default
: System.Web.UI.Page
{
string connStr =
ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlCommand cmd;
SqlDataAdapter sqlda;
DataSet ds;
string str;
protected void
btn_search_Click(object sender,
EventArgs e)
{
lblmsg.Text = "";
SqlConnection conn =
new SqlConnection(connStr);
conn.Open();
str = "select * from emp where name like
'" + TextBox1.Text + "%'";
cmd = new
SqlCommand(str, conn);
int count =
Convert.ToInt32(cmd.ExecuteScalar());
if (count > 0)
{
bind();
GridView1.Visible = true;
}
else
{
lblmsg.Text = "No records found";
GridView1.Visible = false;
}
}
private void
bind()
{
SqlConnection conn =
new SqlConnection(connStr);
conn.Open();
str = "select * from emp where name like
'" + TextBox1.Text + "%'";
cmd = new
SqlCommand(str, conn);
sqlda = new
SqlDataAdapter(cmd);
ds = new
DataSet();
sqlda.Fill(ds, "emp");
conn.Close();
GridView1.DataSource = ds;
GridView1.DataMember = "emp";
GridView1.DataBind();
}
}
}