please HELP! dbnull problem

[b][red]This message was edited by jtmuzix at 2005-1-14 7:57:18[/red][/b][hr]
First let me make myself clear and say that Im not asking you to debug any code. Im using VS Studio.NET 2003. The language which Im working is VB.NET 2003. I have an access database using the JET OLEDB connection and data adapter type. I have created a program that will (sort of) manipulate this database.

This database has a few different tables. Just for examples sake let's say they are Scannerlog and Equiplog. Scannerlog table is just text fields that can be bound to textboxes without any problems (no problems here). However, the equiplog has text fields AS WELL as Boolean (yes/no) fields. I can bind the text fields to text boxes and vice versa, however Im having EXTREME difficulty getting checkboxes to correctly bind with the Boolean (yes/no) fields in the database. When binding Im using the checked control property and receive an error stating that I cannot cast DBnull to other types. Any ideas on what I can do to fix this issue?

One last question I have (isnt as critical) is that I have a search feature setup that can search the databases certain table for a certain string in a column and if the string is found it will do some operation . Which is what I want, EXCEPT, I would like it to fill the form with the correct strings and values according to the certain string I searched for. Lets say for example, I search for the string Bob in the Name Column. If Bob is returned then I want it to show the personal information form with all of bobs information (address, name, phone number, etc) in the appropriate textboxes respectively. As of right now I can get the form to display if bob is returned but none of Bobs information is in the textboxes. Any tips and/or advice would be greatly appreciated.
Jason T.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!