我有一个项目有数据库和存储变量。我想将所有的值和列存储在数据库中并再次访问,但是当我尝试访问im时,只给出了database.How中的最后一个值,我能解决这个问题吗?
public class Variables
{
public static readonly List<Dictionary<string, string>> rows = new List<Dictionary<string, string>>();
public static Dictionary<string, string> column;
public static String Name = null;
public static String Surname = null;
public static String Gsm = null;
public static String QRCodeID = null;
public static String Email = null;
public static String indirimOrani = null;
}
public class SelectSave()
{
var cmdSelectSave = new SqlCommand
{
CommandText =
"SELECT Name,Surname,Gsm,QRCodeID,Email,indirimOrani FROM elmacustomers WHERE OnayID=1",
CommandType = CommandType.Text,
Connection = sqlConElmaCafePlus
};
SqlDataReader reader = null;
reader = cmdSelectSave.ExecuteReader();
while (reader.Read())
{
Variables.column = new Dictionary<string, string>
{
["Name"] = reader["Name"].ToString(),
["Surname"] = reader["Surname"].ToString(),
["Gsm"] = reader["Gsm"].ToString(),
["QRCodeID"] = reader["QRCodeID"].ToString(),
["Email"] = reader["Email"].ToString(),
["indirimOrani"] = reader["indirimOrani"].ToString()
};
Variables.rows.Add(Variables.column);
}
}
public void DataReceive()
{
foreach (Dictionary<string, string> column in Variables.rows)
{
MessageBox.Show(Variables.column["Name"]);//That's giving only last Name value in database. I want to scan all names in database.
}
}发布于 2016-08-16 18:11:16
在DataReceive()函数中,在迭代行时,对迭代器使用一些不同的名称,如datarow,然后使用以下代码:
foreach (Dictionary<string, string> column in Variables.rows.ToList())
{
MessageBox.Show(column["Name"]);
}https://stackoverflow.com/questions/38968991
复制相似问题