venkii R

venkii R

  • NA
  • 13
  • 18.7k

Dataset should show backend table NULL value as null instead of blank value

Aug 5 2011 3:30 AM
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