Help Filling Dataset

I have a class that works fine using the SQLDataReader but when I try and duplicate the process using a Dataset instead of a SQLDataReader it returnsa a null value.

This is the code for the Method to return a datareader

public

SqlDataReader GetOrgID()

{

Singleton s1 =Singleton.Instance();

Guid uuid;

uuid =

newGuid(s1.User_id);

SqlConnection con =newSqlConnection(conString);

string selectString ="Select OrgID From aspnet_OrgNames Where UserID = @.UserID";

SqlCommand cmd =newSqlCommand(selectString, con);

cmd.Parameters.Add(

"@.UserID",SqlDbType.UniqueIdentifier, 16).Value = uuid;

con.Open();

SqlDataReader dtr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

return dtr;

This is the code trying to accomplish the same thing with a Dataset instead.

publicDataSet organID(DataSet dataset)

{

Singleton s1 =Singleton.Instance();

Guid uuid;

uuid =

newGuid(s1.User_id);

string queryString ="Select OrgID From aspnet_OrgNames Where UserID = @.UserID";

SqlConnection con =newSqlConnection(conString);

SqlCommand cmd =newSqlCommand(queryString, con);

cmd.Parameters.Add(

"@.UserID",SqlDbType.UniqueIdentifier, 16).Value = uuid;

SqlDataAdapter adapter =newSqlDataAdapter();

adapter.SelectCommand = cmd;

adapter.Fill(dataset);

return dataset;

}

Assume that the conString is set to a valid connection string. The Singlton passes the userid in from some code in the code behind page ...this functionality works as well.

So assume that the Guid is a valid entry..I should return a valid dataset but its null.

Additionally if I change the sql query to just be Select * From aspnet_OrgNames I still get a null value...I am assuming I am doing something wrong trying to fill the dataset.

Any help would be appreciated.

Hi,

Are you passing in a valid dataset which is not null?
include a ' dataset = new DataSet(); ' before you fill in the data and check if it works
if it does, it just means you passed in a null value...

|||

Thank you, Thank you, Thank you!!!

VERY MUCH APPRECIATED!!!