cannot implicit convert type System.data.datatable to System.data.dataset?

Question

3.00/5 (2 votes)

See more:

hi m getting this type of error..cannot implicity converty type..can any one suggest me how to solve this.??

public DataSet GetTender1(int ID)
        {
            TenderTypeDAL tenderDAL = new TenderTypeDAL();
            DataSet dataTable = new DataSet();
//this linve m getting error...
            dataTable = tenderDAL.GetTender1(ID);

            return dataTable;
        }

thanks

Posted 26-Mar-12 22:51pm

ythisbug

Updated 26-Mar-12 23:06pm

v2

Add a Solution

Comments

senguptaamlan 27-Mar-12 4:57am

tenderDAL.GetTender1(ID) what this method returns?

ythisbug 27-Mar-12 4:58am

public DataTable GetTender1(int ID)
{
DataTable dt = new DataTable();
SqlConnection con = new SqlConnection(varConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_GetTenderByID";

cmd.Parameters.Add(new SqlParameter("@Id", ID));
SqlDataAdapter adapter = new SqlDataAdapter(cmd);

try
{
adapter.Fill(dt);
}
catch
{
dt = null;
}
return dt;
}

senguptaamlan 27-Mar-12 5:02am

So the above method returns a DataTable...and Ur assigning this DataTable to a DataSet type reference.....is that possible??? Its quite expected that Ur getting error. Change Ur code....and go through the code I'm mentioning in the answer part.

Muralikrishna8811 27-Mar-12 5:02am

Hi

its better to write

dataTable.Tables.Add(tenderDAL.GetTender1(ID));

ythisbug 27-Mar-12 6:27am

thanks bro..i tried this working now.

Muralikrishna8811 27-Mar-12 6:40am

welcome

Muralikrishna8811 27-Mar-12 5:00am

Hi check tenderDAL.GetTender1(int id) method return same dataset type

3 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)

OriginalGriff · Answer 1 · 2012-03-26T23:01:00

It depends on what tenderDAL.GetTender1 returns: If it is an object which is a DataSet then it is no problem: just cast it, preferably with a check in there:

C#

dataTable = (DataSet) tenderDAL.GetTender1(ID);

or

C#

dataTable = tenderDAL.GetTender1(ID) as DataSet;
if (dataTable != null)
   {
   ...
   }

If it doesn't, then you need to look at what it does return, and see if there is a good cast between them.

senguptaamlan · Answer 2 · 2012-03-26T23:05:00

C#

public DataSet GetTender1(int ID)
{
            DataSet dt = new DataSet();
            SqlConnection con = new SqlConnection(varConnectionString);
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "usp_GetTenderByID";

            cmd.Parameters.Add(new SqlParameter("@Id", ID));
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);

            try
            {
                adapter.Fill(dt);
            }
            catch
            {
                dt = null;
            }
            return dt;
}

now call the following method

C#

public DataSet GetTender1(int ID)
{
            TenderTypeDAL tenderDAL = new TenderTypeDAL();
            DataSet ds= new DataSet();
            ds= tenderDAL.GetTender1(ID);
 
            return ds;
}

please, mark this as answer if it resolves the error...

Pankil_Plus · Answer 3 · 2012-07-29T23:18:00

Solution 3

XML

Hello

Please define dataset and datatable this way

<pre lang="c#">
 private DataSet GetDataSet()
    {
        DataSet companydata = new DataSet("CompanyList");

        DataTable company = companydata.Tables.Add("company");

        company.Columns.Add("Id", typeof(Guid));


</pre>

Posted 29-Jul-12 23:18pm

Pankil_Plus

cannot implicit convert type System.data.datatable to System.data.dataset?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0