Select Where Or Or Or

[ntqb]

Can someone tell me how can i filter my results from multiple textboxes in asp.net ?

SELECT * FROM [MyTable] WHERE ([Firstname] = @Firstname) Or ([Lastname] = @Lastname) doesn't work

With one textbox is fine but with multiple texboxes no chance.

Thanks a lot!

[LifeinAsia]

What exactly is not working? The logic sounds solid.

[ntqb]

im using a gridview to show data from mssql. When im trying to filter data by first name, last name, country is not working.
in classic asp i can use OR in select statement but in asp.net i dont know how.

[ntqb]

i found the solution :) Thanks!

[bhonda]

Hey,

Well done for getting it sorted. Just for reference though, it may be a good idea to post the solution up here, so if anyone else has the same problem, they can figure it out too!

B