test123123 test123123 - 1 year ago 203
C# Question

The CommandText property has not been properly initialized (MySqlDataReader)


The Reader is always null, i have no idea why.

Before the connection was in one method everything worked fine.


private MySqlConnection connection;
private MySqlCommand command;
private MySqlDataReader Reader;

public Form1()
private void DBint()
string myConnectionString = "SERVER=xxx;PORT=3306;" +
"DATABASE=xxx;" +
"UID=root;" +
connection = new MySqlConnection(myConnectionString);
command = connection.CreateCommand();
MySqlDataReader Reader;//error occures her
Reader = command.ExecuteReader();

Answer Source

You should set the CommandText property of the command object with your SELECT statement or stored procedure name, you cannot execute an empty command.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download