C# cant call created dataset in code

Question

0.00/5 (No votes)

See more:

Hello, I have this problem
I have created DataSet called DataReport and placed table from Sql Server on it. then on form I placed reportviewer and designed new report

everything went smoothly

now I am not using connectionstring automatically, but threw Settings, anyway I have this Code

daData1 is tableadapter
DataReport is dataset that I created
DataDetails is the name of the Table on DataReport
rp is reportviewer

daData1.SelectCommand = new SqlCommand("SELECT * from DataDetails", cs);
DataReport.Clear();
daData.Fill(DataReport.DataDetails);

problem is that at one time everything was fine, worked fine, but my cpu crashed, havent saved, and made code again, but now DataReport is not working, it highlights as FORM not as DataSET

I dont know what is going on,

any help thank you

Posted 20-Aug-12 1:34am

shonezi

Add a Solution

Comments

ZurdoDev 20-Aug-12 11:06am

What's the error? It isn't clear what is exactly broken now.

2 solutions

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)

Ganesh Nikam · Accepted Answer · 2012-08-20T02:18:00

Solution 2

hii,
just change

daData.Fill(DataReport,"DataDetails");

Posted 20-Aug-12 2:18am

Ganesh Nikam

Comments

shonezi 20-Aug-12 8:31am

and this also worked, thank you all

Christian Graus · Accepted Answer · 2012-08-20T01:35:00

Solution 1

If the same code is not working, restart your computer, sounds like something is broken.

Posted 20-Aug-12 1:35am

Christian Graus

Comments

shonezi 20-Aug-12 7:44am

I restarted, same thing, I am puzzled, it worked now it doesnt, and I have done everything the same, maybe it is something in properties

shonezi 20-Aug-12 7:46am

it says I dont have object reference, but it worked before????

Christian Graus 20-Aug-12 7:47am

What object is null ? What makes you think it shouldn't be null ? I bet it is null and you missed a line from what you typed before.

shonezi 20-Aug-12 7:51am

it says an object reference is required for non-static field, method or property System.Data.DataSet.Clear();

shonezi 20-Aug-12 7:51am

I have no idea what is that

Christian Graus 20-Aug-12 7:54am

Ah. Always post the exact error message. We can understand it. System.Data.Dataset.Clear() makes no sense. You need to clear YOUR dataset, you are trying to call a static method, but it's not static ( that is, it requires an ACTUAL dataset to call, like myDataset ) The code you posted is DataReport.Clear(), which would work.

shonezi 20-Aug-12 7:55am

that's the problem, it did work but then I made the exact same code, everything and now when I type DataReport it highlights and I have no extension Clear on it, I cant type it???

shonezi 20-Aug-12 7:56am

DataReport is DataSet I created, its there in solution tree with extension xsd

shonezi 20-Aug-12 8:01am

first time when I did this when it worked and I typed DataReport it was normally in black color of font and after dot Clear could be typed

Christian Graus 20-Aug-12 8:00am

Then the object no longer exists.

shonezi 20-Aug-12 8:01am

doesnt exist??? but how

Christian Graus 20-Aug-12 8:02am

Because you had not saved, I guess. The compiler does not lie.

shonezi 20-Aug-12 8:03am

how to solve this now

Christian Graus 20-Aug-12 8:05am

Fix your code !!!! Make sure the object exists.

shonezi 20-Aug-12 8:11am

well, thats the problem, I dont how, because I wrote it JUST THE SAME when it worked, so I am buffled

Christian Graus 20-Aug-12 8:12am

your code is the same, but it's trying to use an object that does not exist, which I believe you added in the designer.

shonezi 20-Aug-12 8:14am

ok, I am going from the beggining.....I am adding DataSet

shonezi 20-Aug-12 8:16am

this su....cks.....again the same thing

shonezi 20-Aug-12 8:31am

I dont know what I did, but now it works :)