how to display perticular seleted records in gv?

Question

hi friends i am working on air reservation project so i m displaying these data in gridview i took the 2 textbox like source and destination .. when i selected the data from to source like bangare and destibation part is Goa.. but when i search on click button so all data displaying in gridview which started from to B like bangalore  bhopla all data is display but i want only bangalore to goa... please solve these issues...

Ranjit Powar · Answer

If you want to check the correct destination and source then use this SqlCommand cmd = new SqlCommand(select * from Air_Reservation WHERE LEAVING = @LEAVING AND GOING = @GOING con); If it helps you select it as correct answer.

Manas Mohapatra · Answer

Use AND i nstead of OR  like below: SqlCommand cmd = new SqlCommand(select * from Air_Reservation WHERE LEAVING LIKE '%' + @LEAVING + '%' AND GOING LIKE '%' + @GOING + '%' con); Secondly always use parameterised query to avoid sql injection. Browse below URL how to implement it: http://www.csharp-station.com/Tutorial/AdoDotNet/Lesson06

anjali khan · Answer

hi my query is SqlCommand cmd = new SqlCommand(select * from Air_Reservation WHERE LEAVING LIKE '%' + @LEAVING + '%' OR GOING LIKE '%' + @GOING + '%' con);

Vipan Sharma · Answer

As per mentioned bt MANAS check your logic. if still facing issue share information here. So you will get best answer of your problem. :)

Manas Mohapatra · Answer

Change logic in your filtering query. I believe that you are using SQL query to fetch records from source to destination. So you need to modify the logic which will fetch from source to destination not from source only.