Error compiling a c#-Prg. using mysql-connector-net
Posted by: Claudia Buehler
Date: February 29, 2012 03:41AM

I try to use an c#-example of the mysql-connector-net documentation. But compiling the example I get the following error message:

ttt.cs(4,40): error CS0116: A namespace can only contain types and namespace declarations
ttt.cs(5,37): error CS0116: A namespace can only contain types and namespace declarations
ttt.cs(6,40): error CS0116: A namespace can only contain types and namespace declarations
Compilation failed: 3 error(s), 0 warnings


Code of the program:

MySql.Data.MySqlClient.MySqlConnection conn;
MySql.Data.MySqlClient.MySqlCommand cmd;
MySql.Data.MySqlClient.MySqlDataReader myData;

conn = new MySql.Data.MySqlClient.MySqlConnection();
cmd = new MySql.Data.MySqlClient.MySqlCommand();

string SQL;
UInt32 FileSize;
byte[] rawData;
FileStream fs;

conn.ConnectionString = "server=127.0.0.1;uid=root;" + "pwd=12345;database=test;";

SQL = "SELECT file_name, file_size, file FROM file";

try
{
conn.Open();

cmd.Connection = conn;
cmd.CommandText = SQL;

myData = cmd.ExecuteReader();

if (! myData.HasRows)
throw new Exception("There are no BLOBs to save");

myData.Read();

FileSize = myData.GetUInt32(myData.GetOrdinal("file_size"));
rawData = new byte[FileSize];

myData.GetBytes(myData.GetOrdinal("file"), 0, rawData, 0, FileSize);

fs = new FileStream(@"C:\newfile.png", FileMode.OpenOrCreate, FileAccess.Write);
fs.Write(rawData, 0, FileSize);
fs.Close();

MessageBox.Show("File successfully written to disk!","Success!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);

myData.Close();
conn.Close();
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
MessageBox.Show("Error " + ex.Number + " has occurred: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}

Options: ReplyQuote


Subject
Written By
Posted
Error compiling a c#-Prg. using mysql-connector-net
February 29, 2012 03:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.