I have a table named client_master in sqlserver and i have a windows application in c#.In c# application, there are three forms.
One is to enter Client details.
Second is to update the existing clients and last one is to delete the clients.
The problem is, when i try to get all the details on my client updation form it will show only some values rather than showing the all values which are there in the database for the same client.
The reason is there are some fields which contain null values so when datareader read the null value it will direclty jump in the catch section and display "can't read null values". But I want as much information is there, all information should be there on the form, no matter if any field contains null values.
One is to enter Client details.
Second is to update the existing clients and last one is to delete the clients.
The problem is, when i try to get all the details on my client updation form it will show only some values rather than showing the all values which are there in the database for the same client.
The reason is there are some fields which contain null values so when datareader read the null value it will direclty jump in the catch section and display "can't read null values". But I want as much information is there, all information should be there on the form, no matter if any field contains null values.