Dataset returns empty

Question

0.00/5 (No votes)

See more:

Hi,

This code is correct or not ,at the time of return the value my dataset shows the empty.

DataSet dset;
        SqlDataAdapter dAdapter;
        SqlCommand command = new SqlCommand();
        //string deptno = "";
        try
        {
            con.Open();
            dAdapter = new SqlDataAdapter(spNameForXlUpload, con);
            command.CommandType = CommandType.StoredProcedure;
            command.Connection = con;
            command.CommandText = spNameForXlUpload;
            command.Parameters.Add(new SqlParameter("@XMLItemsDoc", xmlDoc.Trim()));
            
            command.ExecuteNonQuery();
            
            dAdapter.SelectCommand = command;
            dset = new DataSet();
            dAdapter.Fill(dset);
            return dset;
        }

can anyone help me to do this

Thanks..

Posted 26-Aug-12 23:36pm

pranathis012

Add a Solution

Comments

bbirajdar 27-Aug-12 5:47am

Does your SP return anything? How can we guess unless you show us what your SP does ? You are using ExecuteNonQuery() which returns only number of rows affected.. Your whole code and logic seems to be a mess..

[no name] 27-Aug-12 6:08am

i chked my SP its ok

bbirajdar 27-Aug-12 6:32am

ok

[no name] 27-Aug-12 6:23am

my SP returns recordset like this <NEWDATASET> <Table1> <eno>40
<ename>IT </Table1> <Table1> <eno>50 <ename>S/w </Table1> <Table1> <eno>60 <ename>Civil </Table1> <NEWDATASET>
but still now my dataset shows empty

bbirajdar 27-Aug-12 6:32am

ok

bbirajdar 27-Aug-12 6:32am

This means your code is wrong...

[no name] 27-Aug-12 7:31am

how to over come this issue

bbirajdar 27-Aug-12 9:03am

What I can guess is that the first part of the code is for inserting data -
con.Open();
dAdapter = new SqlDataAdapter(spNameForXlUpload, con);
command.CommandType = CommandType.StoredProcedure;
command.Connection = con;
command.CommandText = spNameForXlUpload;
command.Parameters.Add(new SqlParameter("@XMLItemsDoc", xmlDoc.Trim()));

command.ExecuteNonQuery();

Whereas in the second part you are trying to fill the data adapter with selected data
dAdapter.SelectCommand = command;
dset = new DataSet();
dAdapter.Fill(dset);
return dset;

We cannot guide you unless you show your SP... Guessing what might be wrong in your SP without seeing the code is just a waste of time

Kuthuparakkal 27-Aug-12 5:49am

What is the command for selecting rows that fills adapter, can you try to execute it alone outside code

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)

Prabhakaran Soundarapandian · Answer 1 · 2012-08-26T23:54:00

Have a look on the Below code

C#

Public DataSet GetDataformSP()
{
string connString = "<your connection="" string="">";
string sql = "name of your sp";

SqlConnection conn = new SqlConnection(connString);

try {
   SqlDataAdapter da = new SqlDataAdapter();
   da.SelectCommand = new SqlCommand(sql, conn);
   da.SelectCommand.CommandType = CommandType.StoredProcedure;
//Add parameters here as you stated in your question.    
//command.Parameters.Add(new SqlParameter("@XMLItemsDoc", xmlDoc.Trim()));

   DataSet ds = new DataSet();   
   da.Fill(ds, "result_name");

  return ds;

} catch(Exception e) {
   Console.WriteLine("Error: " + e);
} finally {
   conn.Close();
}
}</your>

_Amy · Answer 2 · 2012-08-26T23:49:00

Hi,
If your sp returns recordset then only this will work. Otherwise you can use ExecuteNoneQuery function of command object. Try this:

C#

DataSet dset = null;
SqlDataAdapter dAdapter;
//string deptno = "";
try
{
    con.Open();
    SqlCommand command = new SqlCommand(spNameForXlUpload, con);
    command.CommandType = CommandType.StoredProcedure;
    command.Parameters.Add(new SqlParameter("@XMLItemsDoc", xmlDoc.Trim()));
    dAdapter = new SqlDataAdapter(command);        
    dset = new DataSet();
    dAdapter.Fill(dset);
    return dset;
}

All the best.
--Amit

Dataset returns empty

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0