Hi,

I was wondering if anyone knew of a way of creating datasets in MySQL? Or if not, is there a PHP class that would accomplish this?

Thanks,
Andrew

this link might help. Give us some more detail on what you're trying to accomplish.

http://www.oreillynet.com/databases/...a_sets_in.html

Hi DougLife – thanks for your reply. What I am trying to accomplish is the use of datasets in MySQL just like the ones found in .NET…

Thanks again,
Andrew

You can talk to a MySQL database using .NET code. Just install the MyODBC drivers. You can't use ADO.NET in PHP tho.

Explain what you mean by datasets, it could be a multitude of things.

Hi,

What I mean by datasets is the ability to fetch data from the database, dis-connect from the database and then take that same data and query it using SQL. In short, a mini-in-memory database, just like with the .NET platform...

Thanks,
Andrew

a recordset then

http://www.phpclasses.org/browse/package/192.html

Originally Posted by chrishirst

a recordset then

No, a dataset.

http://msdn2.microsoft.com/en-us/lib...a.dataset.aspx

The DataSet, which is an in-memory cache of data retrieved from a data source, is a major component of the ADO.NET architecture. The DataSet consists of a collection of DataTable objects that you can relate to each other with DataRelation objects. You can also enforce data integrity in the DataSet by using the UniqueConstraint and ForeignKeyConstraint objects. For further details about working with DataSet objects, see Using DataSets in ADO.NET.


Whereas DataTable objects contain the data, the DataRelationCollection allows you to navigate though the table hierarchy. The tables are contained in a DataTableCollection accessed through the Tables property. When accessing DataTable objects, note that they are conditionally case sensitive. For example, if one DataTable is named "mydatatable" and another is named "Mydatatable", a string used to search for one of the tables is regarded as case sensitive. However, if "mydatatable" exists and "Mydatatable" does not, the search string is regarded as case insensitive. For more information about working with DataTable objects, see Creating a DataTable.


A DataSet can read and write data and schema as XML documents. The data and schema can then be transported across HTTP and used by any application, on any platform that is XML-enabled. You can save the schema as an XML schema with the WriteXmlSchema method, and both schema and data can be saved using the WriteXml method. To read an XML document that includes both schema and data, use the ReadXml method.
In a typical multiple-tier implementation, the steps for creating and refreshing a DataSet, and in turn, updating the original data are to:

1. Build and fill each DataTable in a DataSet with data from a data source using a DataAdapter.
2. Change the data in individual DataTable objects by adding, updating, or deleting DataRow objects.
3. Invoke the GetChanges method to create a second DataSet that features only the changes to the data.
4. Call the Update method of the DataAdapter, passing the second DataSet as an argument.
5. Invoke the Merge method to merge the changes from the second DataSet into the first.
6. Invoke the AcceptChanges on the DataSet. Alternatively, invoke RejectChanges to cancel the changes.