Dataset should show backend table NULL value as null instead of blank value
HI All,
I have one small issue in my current project. In Backend(SQL) i have a combination of null and blank values for some of the columns. when i am querying it in sql, comming perfectly. but when i am binding that data to Front End Dataset NULL values are also shown as blank in dataset.
How can i get backend NULL values same as null in my Dataset. here i am getting data Conflict which rows are having NULL and which are blank values at Back End level. I am binding bulk data to dataset( 20000 to 80000) depending upon transaction.
Can any one guide me, how can i achive this through code or query to get as it is data in Dataset.
Awaiting for ur valueable response.
Regards,
Venki