<div>
Then you should use, DataReader instead of Adapter.<br />
1. Read the data using DataReader<br />
2. Try Parse your date column to valid dates, if not possible alert to the user.<br />
<br />

</div>


Then you should use, DataReader instead of Adapter.
1. Read the data using DataReader
2. Try Parse your date column to valid dates, if not possible alert to the user.



<div>
same thing is happening while using a datareader aswell.
</div>


same thing is happening while using a datareader aswell.

<div>
strange, this issue is very common, but expert team is failed to provide me the solution of this issue,
</div>


strange, this issue is very common, but expert team is failed to provide me the solution of this issue,

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
When i load the excel data into dataset using datadapet.fill method, It shows empty cell value where invalid dates are present. I want to show the error of invalid date. kindly help to me to sort the issue.
</div>
</div>


Hi

When i load the excel data into dataset using datadapet.fill method, It shows empty cell value where invalid dates are present. I want to show the error of invalid date. kindly help to me to sort the issue.

Problem in load excel data into dataset using datadapet.fill method

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).