how to give a msg this record is not available

Question

hi frnds

i am using 2 textbox with autocomplete for the source and destination..

i already searched the record with textbox..

but if records is not found in gridview so how to do
records is not found.this msg should come when i click on search button ...

Ranjit Powar · Answer

Remove that code from Bind method and change your button click event as below protected void SearchforFlight_Click(object sender, EventArgs e) { BindGridview(); if (gvDetails.Rows.Count { txtgo.Text = ""; ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", " alert('" + "NO DATA FOUND" + "'); ", false); } }

Saineshwar Bageri · Answer

you can add this property from server side also if record is not there.

anjali khan · Answer

hi Ranjit thanks for the update... i really appreciate to u ..

anjali khan · Answer

not working.. i cant select any cities also..

Ranjit Powar · Answer

Give message where you bind gridview not in button click event. protected void BindGridview() { DataTable dt = new DataTable(); DataSet ds = new DataSet(); using (SqlConnection con = new SqlConnection("Data Source=CISBLR-01\SQL2008;Initial Catalog=Syscom;User ID=lcluser;Password=abcd@123")) { con.Open(); //SqlCommand cmd = new SqlCommand("select * from Air_Reservation WHERE LEAVING LIKE '%' + @LEAVING + '%' OR GOING LIKE '%' + @GOING + '%'", con); SqlCommand cmd = new SqlCommand("select * from Air_Reservation WHERE LEAVING = @LEAVING AND GOING = @GOING", con); SqlDataAdapter da = new SqlDataAdapter(cmd); cmd.Parameters.AddWithValue("@LEAVING", txtlev.Text.Trim()); cmd.Parameters.AddWithValue("@GOING", txtgo.Text.Trim()); da.Fill(dt); con.Close(); gvDetails.DataSource = dt; gvDetails.DataBind(); if(dt.Rows.Count { //Give message here; } } } If it helps you select it as correct answer.

anjali khan · Answer

this is ohk.. but see i am searchin from bangalore to mumbai..this data is availabe in database there is showing no data found.. but this data should be show in gridview

Ranjit Powar · Answer

protected void SearchforFlight_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); if (dt.Rows.Count { txtgo.Text = ""; ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", " alert('" + "NO DATA FOUND" + "'); ", false); BindGridview(); } } Here you give message in alert. Is that working? If yes what changes you want?

anjali khan · Answer

this code is working properly now i want if i keep in textbox like bangalore to goa but there is no flight available for this location so want to display messge there is data for this location

anjali khan · Answer

HI RANJITH U CHECKED THAT LINK see if i keep thid code on button click so second text there is showing data is not found.. m sending my code design page /// --Select-- Oneway Roundway           --%>            ///code/// SqlConnection con = new SqlConnection("Data Source=CISBLR-01\SQL2008;Initial Catalog=Syscom;User ID=lcluser;Password=abcd@123"); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BoundField bfield = new BoundField(); bfield.HeaderText = "AIRLINE"; bfield.DataField = "AIRLINE"; gvDetails.Columns.Add(bfield); BoundField field = new BoundField(); field.HeaderText = "LEAVING"; field.DataField = "LEAVING"; gvDetails.Columns.Add(field); BoundField field1 = new BoundField(); field1.HeaderText = "GOING"; field1.DataField = "GOING"; gvDetails.Columns.Add(field1); BoundField field2 = new BoundField(); field2.HeaderText = "DEPART"; field2.DataField = "DEPART"; gvDetails.Columns.Add(field2); BoundField field3 = new BoundField(); field3.HeaderText = "ARRIVE"; field3.DataField = "ARRIVE"; gvDetails.Columns.Add(field3); BoundField field4 = new BoundField(); field4.HeaderText = "PRICE"; field4.DataField = "PRICE"; gvDetails.Columns.Add(field4); BoundField field5 = new BoundField(); field5.HeaderText = "RATING"; field5.DataField = "RATING"; gvDetails.Columns.Add(field5); BindGridview(); } } protected void BindGridview() { DataTable dt = new DataTable(); DataSet ds = new DataSet(); using (SqlConnection con = new SqlConnection("Data Source=CISBLR-01\SQL2008;Initial Catalog=Syscom;User ID=lcluser;Password=abcd@123")) { con.Open(); //SqlCommand cmd = new SqlCommand("select * from Air_Reservation WHERE LEAVING LIKE '%' + @LEAVING + '%' OR GOING LIKE '%' + @GOING + '%'", con); SqlCommand cmd = new SqlCommand("select * from Air_Reservation WHERE LEAVING = @LEAVING AND GOING = @GOING", con); SqlDataAdapter da = new SqlDataAdapter(cmd); cmd.Parameters.AddWithValue("@LEAVING", txtlev.Text.Trim()); cmd.Parameters.AddWithValue("@GOING", txtgo.Text.Trim()); da.Fill(dt); con.Close(); gvDetails.DataSource = dt; gvDetails.DataBind(); } } [System.Web.Script.Services.ScriptMethod()] [System.Web.Services.WebMethod] public static List AutoCompleteList(string prefixText, int count) { DataTable dt = new DataTable(); String constr = "Data Source=CISBLR-01\SQL2008;Initial Catalog=Syscom;User ID=lcluser;Password=abcd@123"; SqlConnection con = new SqlConnection(constr); con.Open(); SqlCommand cmd = new SqlCommand("select DISTINCT LEAVING from Air_Reservation where " + "LEAVING like @SearchText + '%'", con); cmd.Parameters.AddWithValue("@SearchText", prefixText); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); List fr = new List (); for (int i = 0; i { fr.Add(dt.Rows[i]["LEAVING"].ToString()); } return fr; } [System.Web.Script.Services.ScriptMethod()] [System.Web.Services.WebMethod] public static List AutoCompleteList1(string prefixText, int count) { DataTable dt = new DataTable(); String constr = "Data Source=CISBLR-01\SQL2008;Initial Catalog=Syscom;User ID=lcluser;Password=abcd@123"; SqlConnection con = new SqlConnection(constr); con.Open(); SqlCommand cmd = new SqlCommand("select DISTINCT GOING from Air_Reservation where " + "GOING like @SearchText + '%'", con); // SqlCommand cmd = new SqlCommand("select * from Air_Reservation WHERE LEAVING LIKE '%' + @LEAVING + '%' OR GOING LIKE '%' + @GOING + '%'", con); cmd.Parameters.AddWithValue("@SearchText", prefixText); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); List fr = new List (); for (int i = 0; i { fr.Add(dt.Rows[i]["GOING"].ToString()); } return fr; } protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { int value; if (Int32.TryParse(txtadlt.Text, out value)) // if (int.tryParse(txtadlt.Text, out value)) { value = Convert.ToInt32(txtadlt.Text); } else { value = 0; } value++; txtadlt.Text = value.ToString(); } protected void ImageButton2_Click(object sender, ImageClickEventArgs e) { int value; if (Int32.TryParse(txtadlt.Text, out value)) { value = Convert.ToInt32(txtadlt.Text); } else { value = 0; } value--; txtadlt.Text = value.ToString(); } protected void ImageButton3_Click(object sender, ImageClickEventArgs e) { int value; if (Int32.TryParse(txtchld.Text, out value)) { value = Convert.ToInt32(txtchld.Text); } else { value = 0; } value--; txtchld.Text = value.ToString(); } protected void ImageButton4_Click(object sender, ImageClickEventArgs e) { int value; if (Int32.TryParse(txtchld.Text, out value)) { value = Convert.ToInt32(txtchld.Text); } else { value = 0; } value++; txtchld.Text = value.ToString(); } protected void SearchforFlight_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); if (dt.Rows.Count { txtgo.Text = ""; ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", " alert('" + "NO DATA FOUND" + "'); ", false); BindGridview(); } } protected void gvDetails_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { e.Row.Attributes["onmouseover"] = "this.style.cursor='hand';"; e.Row.Attributes["onmouseout"] = "this.style.textDecoration='none';"; e.Row.Attributes["onclick"] = ClientScript.GetPostBackClientHyperlink(this.gvDetails, "Select$" + e.Row.RowIndex); } } protected void btnbook_Click(object sender, EventArgs e) { for (int i = 0; i { string AIRLINE = gvDetails.Rows[i].Cells[0].Text; string LEAVING = gvDetails.Rows[i].Cells[1].Text; string GOING = gvDetails.Rows[i].Cells[2].Text; string DEPART = gvDetails.Rows[i].Cells[3].Text; string ARRIVE = gvDetails.Rows[i].Cells[4].Text; string PRICE = gvDetails.Rows[i].Cells[5].Text; string RATING = gvDetails.Rows[i].Cells[6].Text; GridViewRow row = gvDetails.Rows[i]; } ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", " alert('" + "Your Booking hasbeen Confirmed" + "'); ", false); } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { if (DropDownList1.SelectedItem.ToString() == "Oneway") { CalendarExtender2.Enabled = false; txtdate1.Enabled = false; } } datatable AIRLINE nvarchar(50) Unchecked LEAVING nvarchar(50) Unchecked GOING nvarchar(50) Unchecked DEPART nvarchar(50) Unchecked ARRIVE nvarchar(50) Unchecked PRICE money Unchecked RATING int Unchecked Unchecked

Ranjit Powar · Answer

try this in click event if(dt.Rows.Count { btnSearch.Text="No data Found."; }

anjali khan · Answer

i have 2 textbox and one button and a gridview. when i enter in textbox and click on button should display the records in gridview.if i enter the record which is not there it should display msg "record not found" plz help me...

Ranjit Powar · Answer

You mean to say SearchButton text? If yes when you get data from database in datatable check row and change button text as below. if(dt.Rows.Count { btnSearch.Text="No data Found."; } If it helps you select it as correct answer.

anjali khan · Answer

not like this http://asp.syncfusion.com/demos/web/Dashboard/AirlineReservation.aspx in this url when i select cities for sorece to destination it data is not there in data base so i want to show on button there is no data

Ranjit Powar · Answer

Where on page you want show message.

Amit Singh · Answer

We Can Add EmptyDataText in your GridView For Example:

anjali khan · Answer

not like that http://www.c-sharpcorner.com/UploadFile/0c1bb2/searching-records-from-database-and-display-in-gridview-usin/ in this link suppose 2 textbox is there for searching the record it will display but if data is not there then how to show record is not there

Saineshwar Bageri · Answer

Add this Property :- EmptyDataText="No Records"

how to give a msg this record is not available

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (17)