returning a recordset to a calling class.

[protoculture]

I have created a class to handle all my database I/O. I have set up a method to pass in sql statements in that class and Im hoping to get that method to return a recordset object.

How can I return a recordset object to my calling class?

( am I even approaching this correctly? , thanks for your consideration )

 

[michael_hk]

public DataTable GetData(string sql)
{
	// get connection, execute sql, whatever
	// eg. DataTable dt = WhatEverMethod();

	return dt;
}

 

[protoculture]

public DataTable GetData(string sql)
{
	// get connection, execute sql, whatever
	// eg. DataTable dt = WhatEverMethod();

	return dt;
}

thanks for that quick reply. So what about on my original class part? Do I have to create a datatable in that as well and then fill it with the returned object?

 

[michael_hk]

thanks for that quick reply. So what about on my original class part? Do I have to create a datatable in that as well and then fill it with the returned object?

Yep, with something like this

DataTable dt = obj.GetData("Select * from myTable");

 

[protoculture]

cheers! thanks for your help