SQLdataSource with 2 parameters

[drewdr]

I've got a LastName textbox and a FirstName textbox.

How do I make LastName mandatory, and FirstName optional ?

If I use Select..........Where (LastName=?) AND (FirstName=?)
i need input from both textboxes, and if I use OR- it is either.

[Jitesh]

May be you can use something like
Select..........Where (LastName=?) AND (FirstName=?+%)

So if the first name is blank the query will get all the Firstnames

"dr****@yahoo.com" wrote:

I've got a LastName textbox and a FirstName textbox.

How do I make LastName mandatory, and FirstName optional ?

If I use Select..........Where (LastName=?) AND (FirstName=?)
i need input from both textboxes, and if I use OR- it is either.