我在C#中使用数据库方法。现在,我尝试返回该值,但是由于该字符串是在while
循环中创建的,因此它说它不存在。有没有一种方法kampioen
可以返回在while读取循环中创建的字符串及其值?
public string getkampioen(string selecteditem)
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
string query = ("select * FROM clubs where naam = '" + selecteditem + "'");
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader Reader = cmd.ExecuteReader();
while (Reader.Read())
{
string kampioen = (string)Reader["aantalkampioenschappen"].ToString();
}
return kampioen;
}
}
您可以在while循环之前声明字符串。
public string getkampioen(string selecteditem)
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
string query = ("select * FROM clubs where naam = '" + selecteditem + "'");
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader Reader = cmd.ExecuteReader();
string kampioen = "";
while (Reader.Read())
{
kampioen = (string)Reader["aantalkampioenschappen"].ToString();
}
return kampioen;
}
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句