Then you need to adjust your
select
clause to ignore the blank entries. A few if statements and a
StringBuilder
should do the trick.
StringBuilder select = new StringBuilder("SELECT * from datatable WHERE");
if (!textRoll.IsEmpty && textRoll != "")
{
}
...