如何C# Mysql 查询同一行数据且保存至String[]?
我尝试
我尝试过用reader[1]或者reader.Getstring(1)
但报错没有数组
因为我要查询TEXT
INT的数据可以准确查出
相关代码
`string strcon = "server=127.0.0.1;User Id=233;password=233;Database=233";
string sql = $"select count(*) from Users where name='" + Name.Text + "'"; //Name.Text是前台文本框用于输入name查询
MySqlConnection conn = new MySqlConnection(strcon);
conn.Open();
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
int id;
string mail=null;
string Name1=null;
string PASSWORD=null;
reader.Read();
id = reader.GetInt32(0);
while (true)
{
try
{
if (reader.HasRows)
{
while (reader.Read())
{
mail = reader["mail"].ToString(); //这里用reader[1]和reader.Getstring(1)不行
Name1 = reader["name"].ToString();
PASSWORD = reader["password"].ToString();
break;
}
}
}
catch { }
MessageBox.Show(id.ToString() + " " + mail + " " + Name1 + " " + PASSWORD);
}`
id列代号0;mail列代号1;name列代号2;password代号3