如何使用QuestionID c#知道datatable具有列表对象中的所有值

Question

这里是代码示例:

DataSet dataSet = new DataSet();
DataTable dt = new DataTable();

dt.Columns.Add("QuestionID", typeof(string));
dt.Columns.Add("ElementValue", typeof(string));

DataRow r1 = dt.NewRow();
r1[0] = "238";
r1[1] = "text";
dt.Rows.Add(r1);

r1 = dt.NewRow();
r1[0] = "111";
r1[1] = "text";
dt.Rows.Add(r1);

r1 = dt.NewRow();
r1[0] = "605";
r1[1] = "date";
dt.Rows.Add(r1);

r1 = dt.NewRow();
r1[0] = "123";
r1[1] = "text"; 
dt.Rows.Add(r1); 

r1 = dt.NewRow();
r1[0] = "562";
r1[1] = "text"; 
dt.Rows.Add(r1); 
r1 = dt.NewRow();
r1[0] = "938";
r1[1] = 938; 
dt.Rows.Add(r1);

和List对象:

class keyValue
{
    public string key { get; set; }
    public string value { get; set; }
}

List<keyValue> k_v = new List<keyValue>();
            {
                new keyValue { QuestionID= "238", value = "value_238" };
                new keyValue { QuestionID= "111", value = "value_111" };
                new keyValue { QuestionID= "605", value = "value_605" };
                new keyValue { QuestionID= "123", value = "value_123" };
                new keyValue { QuestionID= "901", value = "value_901" };
                new keyValue { QuestionID= "562", value = "value_562" };
                new keyValue { QuestionID= "938", value = "value_938" };
                new keyValue { QuestionID= "911", value = "value_911" };
            }

如何检查listObject是否满足DataTable (有所有问题if )，以及是否必须以DataTable表示所有QuestionId

Answer 1

首先，除非您有特定的理由这样做，否则不要实现您自己的键值对列表；而是使用Dictionary<string, string>()。

var dict = new Dictionary<string, string>();
dict.Add("123", "question"). 

既然如此，您可以检查密钥是否很容易存在：

foreach(var row in dt.Rows)
{
    bool isKeyLoaded = dict.ContainsKey(row[0]);
}