Searching the element from GridView and display in Label?

Kanaparthi Sureshma Reddy

11y949.NET

Hi,

I have one GridView which is binded from Database.And I want to search the elements based on Id/First Name/Last Name.I am getting this but if there is no such item in the GridView which I entered in the TextBox,I want to get the error message in Label as"The searched record didn't found..

How to write code for getting this message?

This is my Code which I wrote in my button Click...

if (TxtSearch.Text == "")
{
LblSearchMsg.Text = "Please Enter the Id or First Name or Last Name..";
}
else
{
objB.id = TxtSearch.Text;
objB.First_name = TxtSearch.Text;
objB.Last_name = TxtSearch.Text;
DataSet ds = new DataSet();
ds = objD.NameBind(objB);
GridView1.DataBind();
LblSearchMsg.Visible = false;
}

In the NameBind(),I wrote this..

{

string Query = "select * from tbl_Reg where Faculty_id='" + objB.id + "' or First_name='" + objB.First_name + "' or Last_name like '%' +'" + objB.Last_name + "'+ '%'";
SqlDataAdapter da = new SqlDataAdapter(Query, con);
DataSet ds = new DataSet();
da.Fill(ds);

}
return ds;

4 Replies

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

Rahul Prajapat11y ago
Accepted answer
Hello @sureshma try this

if (TxtSearch.Text == "")
{
LblSearchMsg.Text = "Please Enter the Id or First Name or Last Name..";
}
else
{
objB.id = TxtSearch.Text;
objB.First_name = TxtSearch.Text;
objB.Last_name = TxtSearch.Text;
DataSet ds = new DataSet();
ds = objD.NameBind(objB);
if (ds.Tables[0].Rows.Count == 0)
{
LblSearchMsg.Text = "The searched record didn't found..";

LblSearchMsg.Visible = true;
}
else
{
GridView1.DataBind();
LblSearchMsg.Visible = false;
}
}
Govinda Rajulu Yemineni11y ago
ds = objD.NameBind(objB);
if(ds.Tables[0].Rows.Count > 0)
{
GridView1.Datasource=ds;
   GridView1.DataBind();
   LblSearchMsg.Visible = false;
}
else
{
   LblSearchMsg.Text="The searched record didn't found..";
   LblSearchMsg.Visible = true;
}
Kanaparthi Sureshma Reddy11y ago
Yeah..,The both answers are working.. Thanks a lot..
Vipul Malhotra11y ago
Hi,

There is a property in a Grid View, where you can define the text that would be displayed in case there is no data binded to the Grid View. The code snippet for the same would be as below:

The searched record not found

Now, as per your code, when the output of the query would be nothing, then this value would be displayed in the Grid View.

Please let me know if this helps.

Thanks