mysql.netc#编码错误
public array[] getall(string sql)
{
array[] arr = new array[100];
int i = 0;
try
{
sqlcommand command = new sqlcommand(sql,db.conn);
db.open();
sqldatareader reader = command.executereader();
while (reader.read())
{
item it = new item();
it.id = convert.toint32(reader[id]);
it.name = (reader[name]).tostring();
it.level = (reader[level]).tostring();
it.email = (reader[email]).tostring();
it.days = convert.todouble(reader[days]);
arr[i] = it;
i++;
}
}
page：
case 1:
string sql = select * from users; array[] arr = man.getall(sql); console.writeline(----------------------------------------------------------); console.writeline(编号\t昵称\t等级\t天数\t邮箱); console.writeline(----------------------------------------------------------); foreach (array item in arr) { if (item != null) { console.writeline({0}\t{1}\t{2}\t{3}\t{4}); } else { break; } console.writeline(----------------------------------------------------------); } break;