Code covered by the BSD License  

Highlights from
Database Handler

Be the first to rate this file! 6 Downloads (last 30 days) File Size: 3.12 KB File ID: #28083 Version: 1.0
image thumbnail

Database Handler

by

 

Read, Insert, Delete, Update and execute Sql Queries from a database source.

| Watch this File

File Information
Description

This class abstracts database standard operations into a MATLAB class. All that is required is a correctly formatted connection string. The class uses under the hood the database machinery of the .NET framework.

Query results are encapsulated into MATLAB datasets for an efficient usage of the retrieved data tables.

Usage:

dbHanldler = DatabaseHandler(connectionString);

Retrieving Table Data Example:

tableDataset = dbHandler.SelectAll('TableName');

MATLAB release MATLAB 7.10 (R2010a)
Tags for This File   Please login to tag files.
Please login to add a comment or rating.
Comments and Ratings (3)
11 Apr 2012 Dennis

Dennis (view profile)

Hi Fayassal,
any chance you could point me in the right direction for modifying the database handler to output to a structure? I'm new to matlab, so any help is appreciated.

Thanks,
Dennis

Comment only
01 Feb 2011 Fayssal El Moufatich

Hi Gavin,

That is true! The output will be accustomed to a Dataset. Unfortunately, the Dataset Data Type is part of the Statistics toolbox. I hope Mathworks would integrate the feature also in basic MATLAB. The database handler could be also modified to output a cell array or a structure.

Best regards,
Fayssal

Comment only
24 Jan 2011 Gavin

Gavin (view profile)

Tried to use this, and I am having problems. Looks to use the 'dataset' command from the Statistics toolbox, which I don't have.

Comment only

Contact us