Answered by:

Remove empty values from DataTable using Linq

Question

Hi, I have a DataTable that returns me also Null and empty values from the SQL Server. How can I remove the Null and empty values with Linq and bind the result to the DropDown keeping the columns names of the DataTable?

Raghavendra Shanbhag | Blog: www.SharePointColumn.com
Please click "Propose As Answer " if a post solves your problem or "Vote As Helpful" if a post has been useful to you.Disclaimer: This posting is provided "AS IS" with no warranties.

Raghavendra Shanbhag | Blog: www.SharePointColumn.com
Please click "Propose As Answer " if a post solves your problem or "Vote As Helpful" if a post has been useful to you.Disclaimer: This posting is provided "AS IS" with no warranties.

Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.