Oracle 5.0, Справочное руководство

Страница: 1921 / 3232

Connector/Net Programming
1901
using MySql.Data.MySqlClient;
namespace ConsoleApplication2
{
class Program
{
private static void DisplayData(System.Data.DataTable table)
{
foreach (System.Data.DataRow row in table.Rows)
{
foreach (System.Data.DataColumn col in table.Columns)
{
Console.WriteLine("{0} = {1}", col.ColumnName, row[col]);
}
Console.WriteLine("============================");
}
}
static void Main(string[] args)
{
string connStr = "server=localhost;user=root;database=world;port=3306;password=******;";
MySqlConnection conn = new MySqlConnection(connStr);
try
{
Console.WriteLine("Connecting to MySQL...");
conn.Open();
DataTable table = conn.GetSchema("MetaDataCollections");
//DataTable table = conn.GetSchema("UDF");
DisplayData(table);
conn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
Console.WriteLine("Done.");
}
}
}
Further information on the
GetSchema()
method and schema collections can be found in the
Microsoft .NET documentation .
20.2.5.3. Using MySqlCommand
A
MySqlCommand
has the
CommandText
and
CommandType
properties associated with it. The
CommandText
will be handled differently depending on the setting of
CommandType
.
CommandType
can be one of:
1. Text - A SQL text command (default)
2. StoredProcedure - The name of a Stored Procedure
3. TableDirect - The name of a table (new in Connector/Net 6.2)
The default
CommandType
,
Text
, is used for executing queries and other SQL commands. Some
example of this can be found in the following section Section 20.2.4.1.2, “The MySqlCommand Object” .
If
CommandType
is set to
StoredProcedure
, set
CommandText
to the name of the Stored Procedure
to access.
If
CommandType
is set to
TableDirect
, all rows and columns of the named table will be returned
when you call one of the Execute methods. In effect, this command performs a
SELECT *
on the table