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