sql asp.net problem

[regwood79]

Hi everybody need some help:

I have a web form that takes some data from my textboxes and send them through a DAL and return the data from my table. On loading the page it works fine because at that point i am passing no arguments the problem comes in when i want to pass arguments from my text boxes. it is giving me an sql exception: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

I don't know what i am doing wrong. Earlier i was getting an error of Can not convert System.DateTime to System.String but i made a crude fix for that but i have to go later and try to make that right.

Any help would be appreciated.

I put my code in the attachment.

 

[Paszt]

I looked through the code and couldn't find anything.
To trace this problem, use breakpoints and step through the code noticing the values of variables/objects. You may also want to add error handling (Try Catch blocks).