getting error on dataset and datatable keywrd.

Question

0.00/5 (No votes)

See more:

C#

public DataSet ConnectDataBaseReturnDS(string Query)
   {
       ds = new DataSet();
       con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\M\Documents\Visual Studio 2010\Projects\fc 28-3\fc\App_Data\fc.mdf;Integrated Security=True;User Instance=True");
        cmd.CommandText = Query;
       cmd.Connection = con;
      da = new SqlDataAdapter(cmd);
      da.Fill(ds);
       con.Open();
       cmd.ExecuteNonQuery();
       con.Close();
    }

error ocured on keyword dataset,sqldataadpter,and etc... i've define namespace for it.. bt still getting error.. dont knw waht to do..
plz help me out.
is there mistake any i have made????

the error dispaying is

expected class delegate, enum ,interface or struct

Posted 8-Apr-13 20:16pm

mahi0607

Updated 8-Apr-13 20:19pm

v3

Add a Solution

Comments

Prasad Khandekar 9-Apr-13 2:53am

There is no SqlCommand object. cmd is uninitialized.

2 solutions

Solution 1

Have you added System.Data namespace?

I think you are missing this namepace.

C#

using System.Data;

Add the above namespace and check.

Posted 8-Apr-13 20:37pm

Chinmaya C

Comments

mahi0607 9-Apr-13 9:42am

yes i've put it..

Chinmaya C 9-Apr-13 10:32am

Could you please post the exception for better understanding...

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)

skantg · Accepted Answer · 2013-04-08T20:48:00

Solution 2

By looking into error you provided it seems that the function is defined outside the class boundary(check your parentheses).

Any function should be defined only inside the boundaries of class delegate, enum ,interface or struct.

Posted 8-Apr-13 20:48pm

skantg

Comments

mahi0607 12-Apr-13 7:06am

thnks dude for pointing me to my mistake.