Delegates will be the end of me

[Todd]

I am desperately trying to figure out the following problem,
simplified for discussion.

I have a WinForm with a button, textbox, and datagrid. When I click
the button, I want to execute the method defined in the textbox, which
must return a dataset, and pass this dataset to the datasource of my
datagrid. Delegates and/or Reflection seem to be the natural way to
accomplish this.

My "Data tier" resides in another assembly which is referenced in my
WinForms project. I have in that assembly the following class
definition:

namespace Apex.Data
{
public class Class1
{
private Class1(){}

public static DataSet GetDataSet()
{
//return my dataset here...
}
}
}

So, in my attempts to figure this out, I've created the following
delegate and event handler for my button's click event:

public delegate DataSet DataProvider();

private void button1_Click(o bject sender, System.EventArg s e)
{
//1. manual binding
//this.dataGrid1. DataSource =
Apex.Data.Class 1.GetDataSet(). Tables[0];

//2. explicitly defined delegate
//DataProvider method = new
DataProvider(Ap ex.Data.Class1. GetDataSet);
//DataSet ds = method();
//this.dataGrid1. DataSource = ds.Tables[0];

//3. dynamically defined delegate
string functionName = this.textBox1.T ext;
string className = functionName.Su bstring(0,funct ionName.LastInd exOf("."));
string methodName =
functionName.Su bstring(functio nName.LastIndex Of(".")+1);

DataProvider method =
(DataProvider)S ystem.Delegate. CreateDelegate( typeof(DataProv ider),
typeof(Apex.Dat a.Class1), functionName);
DataSet ds = method();
this.dataGrid1. DataSource = ds.Tables[0];
}

The results of these 3 attempts:

1. I was just making sure the dang static method itself works. It
does.
2. Define the delegate explicitly. No problem.
3. Create the delegate at runtime. NOT HAPPENING.

The problem with #3 appears to be that System.Type.Get Type(className)
returns null. Why does it return null? Is there a better approach to
this whole problem? Thanks in advance.

[Ken Kolda]

The example 3 that you showed is using typeof(Apex.Dat a.Class1) instead of
GetType(classNa me). Can I assume that the example #3 that you show works?

Now, if you replace the typeof(...) with GetType(classNa me), the reason this
is likely not working is that you're not providing the necessary assembly
information so the class loader can find the type. Here's an excerpt from
the MSDN documentation on GetType(string typeName):

"typeName can be a simple type name, a type name that includes a namespace,
or a complex name that includes an assembly name specification.
If typeName includes only the name of the Type, this method searches in the
calling object's assembly, then in the mscorlib.dll assembly. If typeName is
fully qualified with the partial or complete assembly name, this method
searches in the specified assembly."

You need to provide a fully qualified class name, which looks like this:
MyNamespace.MyC lass,MyAssembly .

Ken
"Todd" <tp****@apexcg. com> wrote in message
news:47******** *************** ***@posting.goo gle.com...

I am desperately trying to figure out the following problem,
simplified for discussion.

I have a WinForm with a button, textbox, and datagrid. When I click
the button, I want to execute the method defined in the textbox, which
must return a dataset, and pass this dataset to the datasource of my
datagrid. Delegates and/or Reflection seem to be the natural way to
accomplish this.

My "Data tier" resides in another assembly which is referenced in my
WinForms project. I have in that assembly the following class
definition:

namespace Apex.Data
{
public class Class1
{
private Class1(){}

public static DataSet GetDataSet()
{
//return my dataset here...
}
}
}

So, in my attempts to figure this out, I've created the following
delegate and event handler for my button's click event:

public delegate DataSet DataProvider();

private void button1_Click(o bject sender, System.EventArg s e)
{
//1. manual binding
//this.dataGrid1. DataSource =
Apex.Data.Class 1.GetDataSet(). Tables[0];

//2. explicitly defined delegate
//DataProvider method = new
DataProvider(Ap ex.Data.Class1. GetDataSet);
//DataSet ds = method();
//this.dataGrid1. DataSource = ds.Tables[0];

//3. dynamically defined delegate
string functionName = this.textBox1.T ext;
string className = functionName.Su bstring(0,funct ionName.LastInd exOf(".")); string methodName =
functionName.Su bstring(functio nName.LastIndex Of(".")+1);

DataProvider method =
(DataProvider)S ystem.Delegate. CreateDelegate( typeof(DataProv ider),
typeof(Apex.Dat a.Class1), functionName);
DataSet ds = method();
this.dataGrid1. DataSource = ds.Tables[0];
}

The results of these 3 attempts:

1. I was just making sure the dang static method itself works. It
does.
2. Define the delegate explicitly. No problem.
3. Create the delegate at runtime. NOT HAPPENING.

The problem with #3 appears to be that System.Type.Get Type(className)
returns null. Why does it return null? Is there a better approach to
this whole problem? Thanks in advance.

[Todd]

Thanks Ken!

That worked, especially after I got the method name correct in my
code! :~|

I put a second textbox on my form in which I enter the assembly name.
Here's the code now, which uses a different constructor for the
CreateDelegate( ) method than I was using before only because the IL is
slightly leaner with this code:

string functionName = this.textBox1.T ext;
string className = functionName.Su bstring(0,funct ionName.LastInd exOf("."));
string methodName = functionName.Su bstring(functio nName.LastIndex Of(".")+1);
string assemblyName = this.textBox2.T ext;

DataSet ds = ((DataProvider) System.Delegate .CreateDelegate (typeof(DataPro vider),
Assembly.Load(a ssemblyName).Ge tType(className ).GetMethod(met hodName)))();

this.dataGrid1. DataSource = ds.Tables[0];

"Ken Kolda" <ke*******@elli emae-nospamplease.co m> wrote in message news:<#6******* *******@TK2MSFT NGP09.phx.gbl>. ..

The example 3 that you showed is using typeof(Apex.Dat a.Class1) instead of
GetType(classNa me). Can I assume that the example #3 that you show works?

Now, if you replace the typeof(...) with GetType(classNa me), the reason this
is likely not working is that you're not providing the necessary assembly
information so the class loader can find the type. Here's an excerpt from
the MSDN documentation on GetType(string typeName):

"typeName can be a simple type name, a type name that includes a namespace,
or a complex name that includes an assembly name specification.
If typeName includes only the name of the Type, this method searches in the
calling object's assembly, then in the mscorlib.dll assembly. If typeName is
fully qualified with the partial or complete assembly name, this method
searches in the specified assembly."

You need to provide a fully qualified class name, which looks like this:
MyNamespace.MyC lass,MyAssembly .

Ken
"Todd" <tp****@apexcg. com> wrote in message
news:47******** *************** ***@posting.goo gle.com...

I am desperately trying to figure out the following problem,
simplified for discussion.

I have a WinForm with a button, textbox, and datagrid. When I click
the button, I want to execute the method defined in the textbox, which
must return a dataset, and pass this dataset to the datasource of my
datagrid. Delegates and/or Reflection seem to be the natural way to
accomplish this.

My "Data tier" resides in another assembly which is referenced in my
WinForms project. I have in that assembly the following class
definition:

namespace Apex.Data
{
public class Class1
{
private Class1(){}

public static DataSet GetDataSet()
{
//return my dataset here...
}
}
}

So, in my attempts to figure this out, I've created the following
delegate and event handler for my button's click event:

public delegate DataSet DataProvider();

private void button1_Click(o bject sender, System.EventArg s e)
{
//1. manual binding
//this.dataGrid1. DataSource =
Apex.Data.Class 1.GetDataSet(). Tables[0];

//2. explicitly defined delegate
//DataProvider method = new
DataProvider(Ap ex.Data.Class1. GetDataSet);
//DataSet ds = method();
//this.dataGrid1. DataSource = ds.Tables[0];

//3. dynamically defined delegate
string functionName = this.textBox1.T ext;
string className =

functionName.Su bstring(0,funct ionName.LastInd exOf("."));

string methodName =
functionName.Su bstring(functio nName.LastIndex Of(".")+1);

DataProvider method =
(DataProvider)S ystem.Delegate. CreateDelegate( typeof(DataProv ider),
typeof(Apex.Dat a.Class1), functionName);
DataSet ds = method();
this.dataGrid1. DataSource = ds.Tables[0];
}

The results of these 3 attempts:

1. I was just making sure the dang static method itself works. It
does.
2. Define the delegate explicitly. No problem.
3. Create the delegate at runtime. NOT HAPPENING.

The problem with #3 appears to be that System.Type.Get Type(className)
returns null. Why does it return null? Is there a better approach to
this whole problem? Thanks in advance.