0
Answer

SqlDataAdapter problem with a strong typed DataSet.

tcmgc

tcmgc

18y
1.6k
1
I tried to return a strong typed DataSet from a remote server to a windows form application using a SqlDataAdapter.  It did not retieve any records.  When I use the same code and return a DataSet it works.  Could anyone tell me what I'm doing wrong?

When I use the same code in a Web Service, I was able to create a strong typed DataSet.  But I can't use this because my client wants a remote server.

Here is the code:

public DsProject GetProject()
{
    DsProject ds =
null;
    try
    {
        ds =
new DsProject();
        SqlDataAdapter da =
new SqlDataAdapter(this.ProjectSelCmd);
        da.Fill(ds);
    }
    catch(Exception ex)
    {
        ds =
null;
        throw(ex);
    }
    return(ds);
}

public DataSet GetProject2()
{
    DataSet ds =
null;
    try
    {
        ds =
new DataSet();
        SqlDataAdapter da =
new SqlDataAdapter(this.ProjectSelCmd);
        da.Fill(ds);
    }
    catch(Exception ex)
    {
        ds =
null;
        throw(ex);
    }
    return(ds);
}