how to display perticular seleted records in gv?

anjali khan

10y793.NET

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...

5 Replies

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

Ranjit Powar10y ago
Accepted 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 Mohapatra10y ago
Use AND instead 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 khan10y ago
hi

my query is
SqlCommand cmd = new SqlCommand("select * from Air_Reservation WHERE LEAVING LIKE '%' + @LEAVING + '%' OR GOING LIKE '%' + @GOING + '%'", con);
Vipan Sharma10y ago
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 Mohapatra10y ago
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.