[C#] Use a listBox from a Class.

[Wizatek]

Why not do it like this

 

struct sData
{
public int index;
public string name;
public int type;

public sData( int index, string name, int type)
{
this.index = index;
this.name = name;
this.type = type;
}
}

class MySql1
{
public List<sData> Select()
{
string query = "SELECT * FROM `t_magic` `a_name` WHERE `a_index` = 48";

List<sData> list = new List<sData>();

if (this.OpenConnection() == true)
{

MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader dataReader = cmd.ExecuteReader();

while (dataReader.Read())
{
sData data = new sData
(
int.parse(dataReader["a_index"]),
dataReader["a_name"],
int.parse(dataReader["a_type"])
);

list.Add(data);

}

dataReader.Close();

this.connection.Close();

return list;
}
else
{
return list;
}
}
}

 

hmm sorry, for some reason it don't let me copy/paste tabs >.