How to fix the error (DataSet is empty)

Question

Dear All,

Could anyone tell me what is wrong with the following code? (DataSet ds is empty)

However, when I put the code into SSMS, it returns a result.

Answer 1

Hi @BenTam-3003 , Welcome to Microsoft Q&A,

From the code point of view, you just created a new dataset.

Try adding code:

dataadapter. Fill(ds, "Course_table");

The data should be added to ds.Tables["Course_table"].

Best Regards,

Jiale

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.