Hi all.
I've already posted this in the visual C# 2005 forum but I thought it was more appropriate to put it here.
Does anyone know how I can define a method that can return both a DataTable and a int or string?
I've tried this:


internal interface IQuery
{
        void OpenConnection();
        void CloseConnection();
        T DoQuery<T>();
}
abstract internal class QueryClass : IQuery
{
...
    public abstract T DoQuery<T>();
}
class OpenQuery : QueryClass
{
     public override T DoQuery<T>()
     {
       DataTable dt = new DataTable();
            try
            {
                try
                {
                    this.OpenConnection();
                    dt.Load(Command.ExecuteReader());

                    return dt;
...
                }
            }
     }
}
...
OpenQuery query = new OpenQuery(queryname, parameters);
return query.DoQuery<DataTable>();


Obviously I can't return a DataTable when the return type is not defined in the DoQuery method and I can't call Load on a generic type. How do you guys work around this??

 - mega
Moving to C# .NET

__________________
- mega
Aspiring JavaScript Ninja

Hi ,Why cant u try returning of type "OBJECT".

I could but then I would have to cast the DataTable to an object when I return it from the DoQuery and then cast it back to a DataTable again when I want to use it in the caller code. That can't be good for performance. I'm thinking there is no way this can be done in a strong type way.

 - mega
Moving to C# .NET

HI , ok , U can create a structure with two variables of type one datatable and second int .Now U can use this structure as a return Type .

Good Luck

Yeah, that would do it. But for this project I followed your advise and defined the method return type as object. I think it's the best choice out of poor possibilities.

 - mega
Moving to C# .NET