Error CS0029 in C# unit test

Question

0.00/5 (No votes)

See more:

Sorry for annoying you with something that, for a lot of you, may be easy.

C#

using ExcelDataReader;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using System.IO;

namespace UtilizzoExcelByPath
{
    [TestClass]
    public class UnitTest1
    {
        static Dataset mTestData;

        [ClassInitialize]

        public static void BeforeAllTests(TestContext testContext)
        {
            using (var stream = File.Open(@"C:\Users\Lenovo\Desktop\Baa.xlsx", FileMode.Open, FileAccess.Read))
            {
                // Auto-detect format, supports:
                //  - Binary Excel files (2.0-2003 format; *.xls)
                //  - OpenXml Excel files (2007 format; *.xlsx, *.xlsb)
                using (var reader = ExcelReaderFactory.CreateReader(stream))
                {
                    mTestData = reader.AsDataSet();
                }
            }
        }

What I have tried:

I take back the error CS00029, how can I fix this error?

Posted 7-Feb-22 3:31am

Nima Nikravan

Updated 7-Feb-22 5:58am

Sean Ewington

v2

Add a Solution

Comments

Nima Nikravan 7-Feb-22 9:37am

Sorry, wrong error number.
the right error number is CS0029

Dave Kreskowiak 7-Feb-22 9:40am

What's the exact error message? Nobody gives a sh*t about the error numbers.

Nima Nikravan 7-Feb-22 9:44am

Cannot implicitly convert type 'System.Data.DataSet" in "UtilizzoExcelByPath.Dataset"

Richard MacCutchan 7-Feb-22 9:51am

Which line causes the error?

Nima Nikravan 7-Feb-22 9:53am

line 23 mTestData = reader.AsDataSet();

Richard MacCutchan 7-Feb-22 9:57am

See below.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Accepted Answer · 2022-02-07T03:56:00

Solution 1

Your declaration of Dataset is incorrect because it is mis-spelled; the compiler thinks it is part of the namespace UtilizzoExcelByPath. It should be:

C#

        static DataSet mTestData; // capital S for Set
// or better still, use the full name
        static System.Data.DataSet mTestData;

Posted 7-Feb-22 3:56am

Richard MacCutchan