Method | Description | |
---|---|---|
delete ( string table, string where ) : int |
deletes records from the database
|
|
describeTable ( string table ) : |
gets the attributes of a table
|
|
insert ( string table, string attributes, string values ) : int |
inserts a record into the database
|
|
mysqldate ( System.DateTime dat ) : string |
this function converts .NET datetime to mysql date format
|
|
selectdatable ( string table, string attributes, string where ) : |
retrives data from the database and puts it to a table
|
|
showDatabaseTables ( ) : |
retrieves all the database tables for a given database
|
|
singleval ( string table, string attribute, string where ) : string |
Retrieves only a cell from the database table
|
|
update ( string table, string attributes, string values, string where ) : int |
updates the database
|
public delete ( string table, string where ) : int | ||
table | string | table from whic data is to be deleted |
where | string | the where clause used eg 'where id=1' |
return | int |
public describeTable ( string table ) : |
||
table | string | the table whose attribute is being got |
return |
public insert ( string table, string attributes, string values ) : int | ||
table | string | table into which a record is to be inserted |
attributes | string | attributes in the table that whose data is being inserted |
values | string | values to the attributes of the table whose data is being inserted |
return | int |
public mysqldate ( System.DateTime dat ) : string | ||
dat | System.DateTime | the datetime object being converted to mysql date format |
return | string |
public selectdatable ( string table, string attributes, string where ) : |
||
table | string | table whose data is being retrieved |
attributes | string | attributes of the table which is being retived |
where | string | the where clause eg "where id>1 and name='guy'" |
return |
public showDatabaseTables ( ) : |
||
return |
public singleval ( string table, string attribute, string where ) : string | ||
table | string | table whose cell is being retrieved |
attribute | string | attribute being retrieved |
where | string | the where clause and this is mandatory |
return | string |
public update ( string table, string attributes, string values, string where ) : int | ||
table | string | the table being updated |
attributes | string | the attributes to update |
values | string | the values that correspond to the attributes |
where | string | the clause to be used eg' where id=1' |
return | int |