SQLClient

This class provides the functions as SQLServer client.

Methods
SQLClient.ExecuteNonQuery($sql)
SQLClient.ExecuteSelectQuery($sql)
SQLClient.GetSchema()
SQLClient.Initialize($servername)
SQLClient.SelectDatabase($databasename)

ex)
$server = "mysqlserver";
# new instance
$sc = new SQLClient;
# initialize
$sc = $sc.Initialize($server);
# get schema information
$sc.GetSchema();

# execute select query
$sql = "select * from [TestTable]";
$sc.ExecuteSelectQuery($sql);

# execute insert SQL
$sql = "insert into [TestTable] ([TestCol]) values ('TestValue')";
$sc.ExecuteNonQuery($sql);

Last edited Mar 2, 2013 at 12:51 PM by Tom__S, version 4

Comments

No comments yet.